query question

[sepultura]

i want to query a table but i want the first result that pops up to have a certain attribute.

for instance if i want the first result to have a product_id of 3, the query result would be...

product_id = 3
product_id= 1
product_id = 2
etc etc..

i want the 3 to come first and then the rest of the query to come.
does this make sense?
is this possible?
thank you for any help you can give me.

[thorpe]

i think you'd need to do two queries. one to get the first product, then another to get the rest. either that or do one query, dump it in an array and then sort it.

[thorpe]

unless of course 3 is the highest product_id, then you could just do...

SELECT * FROM products ORDER BY product_id DESC

[sepultura]

the product_id will be different everytime (1, 2 or 3) depending on a passed variable.

I was hoping for an easy solution 🙁
thanks for your help thorpe