Select, From And Where

[hahaitwork]

$get = mysql_query ('SELECT id , name, description, price , shipping FROM products WHERE id < 100 ORDER BY id DESC');

 

How do I manage to make it like this, so it order from 1-100 ids, and also check if there is quanity's

 

 

$get = mysql_query ('SELECT id, name, description, price , shipping FROM others WHERE quantity > 0 ORDER BY id DESC');

 

Both works, but I want them mixed together, so it reads if there is quanity's And from id < 100

- Thanks

Edited October 23, 2012 by hahaitwork

[Maq]

You said it right in your post, just add in the condition:

 

WHERE id < 100 AND quantity > 0 ORDER BY id DESC');

Edited October 23, 2012 by Maq

[White_Lily]

You answered the question yourself as Maq so correctly stated lol.

[hahaitwork]

You said it right in your post, just add in the condition:

 

WHERE id < 100 AND quantity > 0 ORDER BY id DESC');

 

Hehe, thanks.. I hoped it to be something like this, but I didn't know about the "AND" function.. so I tried , etc and that did not work thx !

[hahaitwork]

1 more question as well, how do I make so the id will go from 100-200 ? Simple stuff I bet..

WHERE id < 100 AND quantity > 0 ORDER BY id DESC');

[White_Lily]

This may need to be a different query. But...

 

WHERE id >=100 AND id < 200 AND quantity > 0 ORDER BY id DESC');

[hahaitwork]

This may need to be a different query. But...

 

WHERE id >=100 AND id < 200 AND quantity > 0 ORDER BY id DESC');

 

Works pretty well , Thanks