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
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
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\ ;
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,
Put the echo inside the while statement.
HTH
Todd Williamsen [EMAIL PROTECTED] said:
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
;
}
- 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
Well, then maybe you only have one row with that city in the database?
If you want to order, but return all rows, use ORDER BY.
Plus, you don't output anything in the while loop - how do you know
there's only one row?
Bogdan
Todd Williamsen wrote:
It needs that line to sort them by city.