Just lose the "WHERE city=\"$city\" in the SQL.


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

Reply via email to