mysql_num_rows not working

[HDFilmMaker2112]

while($row10000=mysql_fetch_array($result10000)){
$product_id3=$row10000['product_id'];
$sql15000="SELECT * FROM $tbl_name WHERE product_id=".$product_id3;
$result15000=mysql_query($sql15000);
while($row15000=mysql_fetch_array($result15000)){
extract($row15000);
if(mysql_num_rows($result15000)==0){
$content='<div class="center">Search found no results.</div>';
}
else{
$content.=$product_name;
}
}
}

 

The above does not display the $content variable when there are no rows returned, just comes up with a blank page. Works fine when there are results returned.

 

[jcbones]

That is how it should work, as the while statement will never run, being that it will return false on row 0.

 

You MUST put the mysql_num_rows() function BEFORE the while statement.

[Maq]

That is how it should work, as the while statement will never run, being that it will return false on row 0.

 

You MUST put the mysql_num_rows() function BEFORE the while statement.

EDIT: This ^

[HDFilmMaker2112]

That is how it should work, as the while statement will never run, being that it will return false on row 0.

 

You MUST put the mysql_num_rows() function BEFORE the while statement.

 

That's what I figured... was just to lazy to change it to try it myself.

 

 

EDIT: Just tried it, still a blank page.

while($row10000=mysql_fetch_array($result10000)){
$product_id3=$row10000['product_id'];
$sql15000="SELECT * FROM $tbl_name WHERE product_id=".$product_id3;
$result15000=mysql_query($sql15000);
if(mysql_num_rows($result15000)==0){
$content='<div class="center">Search found no results.</div>';
}
else{
while($row15000=mysql_fetch_array($result15000)){
extract($row15000);
$content.=$product_name;
}
}
}

[jcbones]

Cannot help you, as there are many reasons that you would get a blank page.  I KNOW that you have all error reporting set on HIGH!!!

 

 

ini_set ("display_errors", "1");
error_reporting(E_ALL);

[HDFilmMaker2112]

Well turned on error reporting and all I'm getting is notices that I have an Undefined Index and that the Content variable is undefined (because it's being called but nothing's a signed to it, for whatever reason.

 

 

The page is actually displayed properly when the keyword exists, just when there are no results returned does it not show anything.

[jcbones]

Is your first query executing?

[HDFilmMaker2112]

Is your first query executing?

Nope, that would be way, the first query is what actually does the search look-up so.... Moved it outside the first while and working perfectly now.

 

Thanks.