[Resolved] COUNT prob

[Dolemite50]

Hi,
I battled with this one all night and all day today but its got me licked.

I have a code that looks like this:

$query_count = "SELECT COUNT(*) FROM songs WHERE sgenre ='$genre'";     

$result_count = mysql_query($query_count, $conn);  

$totalrows = mysql_result($result_count, 0) or die(mysql_error());
$limitvalue = $page * $limit - ($limit); 
$getInfo = "SELECT songid, stitle, bandName  FROM songs WHERE sgenre ='$genre' ORDER BY stitle DESC LIMIT $limitvalue, $limit";....

This is working great except when there are no results in the genre query, it pukes. It seems to exit the script at that point.

[Dolemite50]

Sorry,
I meant to preview the post and it submitted.

My question is, will I get in trouble using the COUNT function on a query with no results? If not, what else might be causing this?

Thanks alot.

[Weedpacket]

if($totalrows>0)
{
// get your rows
}
else
{
// do something else
}

What do you mean "pukes"?

[wazo00]

It's stopping because of:

or die(mysql_error());

It's returning 0 and seems like a fail.

[Dolemite50]

A-hah!
That was grand, wazoo.

Removing "or die" fixed it!
(I also remmed out "or puke")

Thanks alot guys.