It needs that line to sort them by city. But it only returns one row "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I know I have asked this silly question before, but forgive me since I have > been a bit rusty with PHP lately > > So how do I return all rows? > > I have this: > > $sql= "SELECT id, city, date FROM meetings WHERE city = \"$city\" "; > $result = mysql_query($sql,$connection) or die("Couldn't execute query"); > while ($row = mysql_fetch_array($result)) { > $id = $row["id"]; > $city = $row["city"]; > $date = $row["date"]; > } > echo "$date"; > ?> > >
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php