[OsteeN]

So, i got error in my php code at this line:

Code

//Counting table row
$count=mysql_num_rows($result);

mySQL error:

Code

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a5899566/public_html/checklogin.php on line 30

Heres the code that is interacted with the line:

Code

$sql = "SELECT * FROM $tbl_name WHERE username='$usern' and password='$passn'";
$result=mysql_query($sql);

//Counting table row
$count=mysql_num_rows($result);

Anyone help? :3

[kalwat]

$result=mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query);

try that.

[OsteeN]

$result=mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query);

try that.

Then it says this:

Code

Error: Query was empty with query

[Reserve]

Can you echo $results and post the contents?

[OsteeN]

Can you echo $results and post the contents?

Nope i can't, all i get is the query thing i posted over those 2 posts.

[BlueLight™]

Did you connect to your database before hand? Are your table names correct?

[OsteeN]

Did you connect to your database before hand? Are your table names correct?

Yep, this is at login section. The register works fien, and it isnerts the details into the table.

[Poppins]

Then it says this:

Code

Error: Query was empty with query

Use the variable in your script: $sql -_-

[BlueLight™]

Try and make the "and" in the $sql statement capitals like "AND".