Return text if no content

[Andy_Pugh]

Hi there!

I'm trying to get a way to display an if command if it can't find any content from a specific category

I.e if it looks in a category for content and nothing appears it will display "Sorry, no albums found"

here is my current code

<?
if ($cdid == "") {
$sql="SELECT * FROM cdreview WHERE cdartist LIKE '" . $_GET["cdartist"] . "%'ORDER BY cdartist ASC";
$result=mysql_query($sql);
$ncount=0;
echo "<font size=1> </font>";
while ($myrow=mysql_fetch_array($result)) {
if ($ncount<100)
{
$ncount=$ncount+1;
$cdreview = str_replace("\'", "'", $cdreview);
?>

Any idea?

Hope you can help :queasy:

[jdorsch]

First of all you aren't doing any checks or escaping on your $_GET param that you are sticking in your SQL statement leaving you open to SQL injection.

Secondly you are just doing a count to 100, so that means if 10,000 records are returned you are going to fetch them all even if you don't need them and eat up resources. You should be using LIMIT.

Thirdly you can use mysql_num_rows($result); to see how many rows were returned. If 0 are returned them you can print your text, otherwise you can do your loop.