Im trying to make a logon script in PHP. When I run the webpage i get an error that says: [error] mysql_numrows(): supplied argument is not a valid MySQL result resource in [dir] on line 79 [/error] Here's my code: [code] <? $sqlusername="root"; $sqlpassword="fakepassword"; $database="webspace"; mysql_connect('localhost',$sqlusername,$sqlpassword); @mysql_select_db($database) or die( "Unable to connect to database!"); $query="SELECT * FROM main WHERE field='username'"; $result=mysql_query($query); //#####PROBLEM######// $num=mysql_numrows($result); //#####PROBLEM######// $i=0; $verify=0; while ($i < $num) { $compare=mysql_result($result,$i,"username"); if ($username == $compare){ $verify=1; $row=$i; } else { $i++; } } if ($verify == 1){ $query="SELECT * FROM main WHERE field='password'"; $result=mysql_query($query); $compare=mysql_result($result,$row,"password"); if ($compare == $password){ print "Done!"; } else { print "HAHAHAHAHAHA! You forgot your password!"; } } if($verify != 0){ print $username; print " is a non-existing username! That or Jake can't program PHP for sh*t!"; } mysql_close(); ?> [/code] How do i fix this? Or is there an another way of counting the number of rows in a sequence? Thanks in advance for any help! Jake

I don't see anything wrong with this query... but if it's me I'd do it by the book, like this: $query = "SELECT * FROM `main` WHERE `field` = 'username'"; $result = mysql_query($query) or die (mysql_error()); $num = mysql_num_rows($result); sometimes that ' and ` can really make a difference :D mysql_numrows() is deprecated mysql_error() will show you more details if the query was wrong, something like: 'you have an error in your syntax near: FROM `main`... so you can look at that section more closely... hope that helps ^o^ are you in Asia? do you watch Animax Asia? Please Vote

thanks for your help but im still having problems. it turns out that whenever a php-primitive function is called, there's an error