Just lose the "WHERE city=\"$city\" in the SQL. Bogdan
Todd Williamsen wrote: >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