Looping Question

[Anon]

Hi All I'm Trying to loop through a Mysql Table

with a limit of 3 and show the first 3 results this parts is fine

I need to do some extra checking
in the while loop
where it confusing me

On the loop I want to check the qty field if it is 0 then dont list it and go to the next avilable result if avaliable

can this be done and how

Thanks For any Help
Richie TM

[Anon]

What does your SQL query look like? Why not simply add "WHERE qty!=0" to it?

[Anon]

If I add qty!=0 wouldn't that list all 0 qty's

code

// loop through table and get first 3 results
$results = mysql_query("SELECT * FROM music WHERE user_id = '$user_id' ORDER BY order_list LIMIT 3");
while($row = mysql_fetch_array($result)) {
echo "List fisrt 3 results";

ie 1. Dance with me
2. Hotel California
3. Beat it
4. Madonna Music
Say Hotel California's qty was 0

then the list should show 1, 3, 4

I used a if() it remove the zero qty but does not advance to the next selection.

Using php3

Thanx

[Anon]

Actully that did work thanx I didn't use the ! on my qty!=0 thanx again