Hi,

Im trying to get a less than or equal to (<=) query to work.

$query = "SELECT ProductId, Album, Artist, Stock FROM storeritem WHERE Stock="0" ";

This is the current code i am using. Is there something wrong or missing from this?

its got all the other code in to display because if i remove the WHERE Stock="0" from the query it shows all the items.

you want what less than or equal to what???

surely you cannot mean the stock column, because negative stock doesn't make sense

unless your stock is a text column I'd try

y'don't need quote marks around non text columns

Sorry i missed bits out of my first post

I wanted it to <= 10 .

The problem was i want using quote marks around it. I've done it now, Thanks

there is no "equals less than or equals" operator, only a "less than or equals" operator

change this --

... WHERE Stock= <=10

to this --

... WHERE Stock <=10

You can't embed quotes within quotes unless you escape them or use a different type of quote. If you need quotes here then just change the "0" to '0' and it should work. Lord knows why you want the Stock field to be treated as a string though.