mysql_num_rows error

[abch624]

Hi Guys I have this sql statement that I execute,

$sql_check_language="SELECT isoID FROM $tbl_languagetemplate WHERE isoID='$newlangaugeID'";
$result_check_language=mysql_query($sql_check_language);
$count=mysql_num_rows($result_check_language);

 

When I reach this code I get this error: "Query was empty"

 

I have 0 rows for this query in the database. I expect 0 to be returned.... Any help guys or any ways to catch this?

 

Cheers - Zahid

[vikramjeet.singla]

will please provide output for $sql_check_language variable...

[abch624]

I did an echo on the $sql_check_language variable I get this:

 

SELECT isoID FROM languagetemplate WHERE isoID='uykgfyk' Query was empty

 

cheers - zahid

[themistral]

So do you want to check to see if the query is empty?

 

In that case try

 

if (mysql_num_rows($result_check_language) > 0) {
    // run the code if 1 or more results
} else {
    // error message or whatever here
}

 

Hope that's what you were getting at!!

[Xurion]

If you're simply counting rows (and not using the data) you should write an SQL statement that uses the COUNT method.

 

SELECT COUNT(*) FROM table;

 

And reference it with:

 

$row['COUNT'];

[vikramjeet.singla]

can you execute this code and let me know the output:

 

$sql_check_language="SELECT isoID FROM $tbl_languagetemplate WHERE isoID='$newlangaugeID'";
$result_check_language = mysql_query($sql_check_language) or die(mysql_error());

 

and want to make sure have you created the connection....

[MasterACE14]

I believe the problem is not in the query or PHP itself. But in a typo.

 

take a closer look:

$sql_check_language="SELECT isoID FROM $tbl_languagetemplate WHERE isoID='$newlangaugeID'";

WHERE isoID='$newlangaugeID'";

'$newlangaugeID'

langauge

 

there's your problem above.

 

Regards ACE