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>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment