mySQL query error

[sciwaysoft]

I have a table teldir2 having three fields Name,phone,category.

I want to echo the records where category is Stores. in decending order by name. But i get error

mysql_fetch_array(): supplied argument is not a valid MySQL result resource

here is my code.... I really need help... in very short time....

$getdata = @(" select Name,phone,category from teldir2 where category='Stores' ORDER BY Name DESC");
while($r=mysql_fetch_array($getdata)){
extract($r);
echo("<b>$Name on $category<BR><BR>$phone</b>");
}

[spighita]

Is that all of your code?

Assuming that, that is all of your code.

Connect and then Select your database.

Also I had a problem once because I was using a Uppercase and then lower case. I lost lots of time trying to figure out what was wrong and inside my SQL statement i had left an uppercase and when I made it lower case it solved my problem.