Monday, May 20, 2013

Join Query in PHP retrieving date from database MYSQL Time From another Table - Part II


<?php
include_once('db.php');

$date = $_POST['date'];

$res =  mysql_query("select time.id,time.date_id, time.time from time inner join date on date.date_id = time.date_id WHERE date.date ='$date'  ");
?>
<select name="show_place" >
<option>Select</option>
<?php
while($row = mysql_fetch_array($res))
{
echo "<option value = ".$row[id].">  $row[time]</option>";

}
?>
</select>

No comments: