Returning all rows
| From: | Todd Williamsen | Date: | Mon, 20 May 2002 16:01:38 +0000 |
| Subject: | Returning all rows | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19274@lists.php.net to get a copy of this message | ||
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";
?>