From: "Chris Dowell" <[EMAIL PROTECTED]>
Or alternatively
$result = mysql_query("SELECT * FROM tablename");
if (mysql_num_rows($result))
{
while ($row = mysql_fetch_row($result))
{
// display results
}
}
else echo "No results";
bah... you're wasting precious resources on a mysql_num_rows call
Or alternatively
$result = mysql_query("SELECT * FROM tablename");
if (mysql_num_rows($result))
{
while ($row = mysql_fetch_row($result))
{
// display results
}
}
else echo "No results";
Hope this helps
Cheers
Chris
John Nichel wrote:
Dustin Krysak wrote:
Hi there... I have a simple search pa
Dustin Krysak wrote:
Hi there... I have a simple search page (mysql database), and I can get
it to display the results no issues, but i was wondering how I could
display a message stating there were no results, instead of just having
the field blank. I am familiar with IF and ELSE statements, bu
mysql_num_rows () will tell you how many rows return in the query
> [Original Message]
> From: Dustin Krysak <[EMAIL PROTECTED]>
> To: PHP <[EMAIL PROTECTED]>
> Date: 09/14/2004 9:37:24 PM
> Subject: [PHP] php - no results - display other message
>
> Hi there... I
Dustin Krysak wrote:
Hi there... I have a simple search page (mysql database), and I can get
it to display the results no issues, but i was wondering how I could
display a message stating there were no results, instead of just having
the field blank. I am familiar with IF and ELSE statements, bu
Hi there... I have a simple search page (mysql database), and I can get
it to display the results no issues, but i was wondering how I could
display a message stating there were no results, instead of just having
the field blank. I am familiar with IF and ELSE statements, but I am
not sure how
6 matches
Mail list logo