It needs that line to sort them by city. But it only returns one row "Bogdan Stancescu" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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
