cant get it to work

[Anon]

i want to do this:

$query = "select * from dvd order by title"

and

$query2 = "select count(*) from dvds where quanity >= 1"

#1 gets the dvds from the catalog and then #2 tells me how many of them have more than 1.

so i can display the catalog and with a few more lines of code not displayed here i can get it to count the total number of items, but i cant get the results from the $query2 to display (thats the count of how many have quanity >= 1).

[tomhath]

I read your post three times. But there's still something I can't figure out: What's your question?