Re: returning all rows
| From: | Bogdan Stancescu | Date: | Mon, 20 May 2002 16:18:57 +0000 |
| Subject: | Re: returning all rows | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19275@lists.php.net to get a copy of this message | ||
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"; ?>