Echo your data in the loop.
like 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";
}
----- Original Message -----
From: "Todd Williamsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 5:01 PM
Subject: [PHP-DB] Returning all rows
> 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
