Do everything as you did, except for that if-statement.
$Query = "SELECT * FROM table";
$Results = mysql_query($Query);
$num = mysql_num_rows($Results);
if ($num < 1 || !isset($num))
echo "Nothing here!";
else
echo "Do something today!";
Niklas
-----Original Message-----
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 18. helmikuuta 2002 16:27
To: Php-General; ':[EMAIL PROTECTED]'
Subject: RE: [PHP] Mysql_num_rows
Please show your exact code, because your code snippet looks right.
Then, again, maybe it's because it's an Aggie machine...<GRIN>
-----Original Message-----
From: Niklas Lamp�n [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 8:11 AM
To: Php-General
Subject: RE: [PHP] Mysql_num_rows
Maybe you can round the problem with
if ($num < 1)
echo "Nothing today!";
else
echo "Something to do today!";
if (!isset($num) || $num == 0)...
Niklas
-----Original Message-----
From: Frank Miller [mailto:[EMAIL PROTECTED]]
Sent: 18. helmikuuta 2002 16:05
To: [EMAIL PROTECTED]
Subject: [PHP] Mysql_num_rows
Thanks to everyone that helped me with my last problem I've run into
another problem and was wondering if someone here could offer any help
or
suggestions. The project I'm working on is an event calender. It does
several things but the problem I've run into is when I click a date on
the
calendar if there are no events for that day I want to print a message
on
the web page saying as much. I've read the documentaion that said if
I'm
using a select statement to use mysql_num_rows and that it returns an
integer. Here is a snippet of my code
$query = "SELECT *,TIME_FORMAT(eventtime, '%l:%i %p')AS eventtime,
DATE_FORMAT(dateofevent,'%M %e, %Y') AS fdateofevent FROM tamutevents
where refid=$refid";
$result = mysql_query($query,$connection) or die("Error in Query"); $num
= mysql_num_rows($result);
Next I say if ($num == 0)
{
echo " There are no events scheduled today!";
}
else
{
echo "blah, blah, blah";
}
The problem is if there are no records that match the select then it
always
goes to the else part. I've tried printing the value of $num and it
works
if there is something scheduled but when there is nothing scheduled $num
shows nothing on the screen.
I'm using Mysql 3.23.38 and php 4.06 on a windows test machine but it
works
the same on php 4.06 and Mysql 3.23.46 on my Linux server.
Has anyone else run into this and if so can you tell me what to do about
it.
Thanks in advance - Frank
Frank Miller
Computer Specialist and Webmaster
Technology and Distance Education
Texas A&M University-Texarkana
2600 North Robison Rd
Texarkana, Texas 75501
Phone: 903-223-3156
Fax: 903-223-3139
Office: 165
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
