October 25th, 2007, 02:28 PM
|
|
5B's
|
|
Join Date: Oct 2002
Location: PC, FL
Posts: 364
Time spent in forums: 1 h 48 m 26 sec
Reputation Power: 6
|
|
Quote: | Originally Posted by bmn hi, i'm new to php and i was trying out some code from a tutorial and i got an error saying: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\calendar2\index.php on line 30"
heres the code:
PHP Code:
<?php
$sql = "SELECT * FROM appointments WHERE month=10 AND day=1;";
$result = mysql_query($sql);
$numrows = mysql_num_rows($result); //line 30
if($numrows == 0){
echo "<br>available";
}
else{
echo "<br>taken";
}
?>
An anyone tell me whats wrong? thanks |
PHP Code:
<?php
$result = mysql_query("SELECT * FROM appointments WHERE month=10 AND day=1");
$numrows = mysql_num_rows($result); //line 30
if($numrows == 0){
echo "<br>available";
}
else{
echo "<br>taken";
}
?>
Edit, looks like your problem is here,... day=1;";
__________________
-- Jason
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
