PHP / SQL Display problem

[Gensic]

Hey guys,

 

I have problem displaying some stuff from mysql.

Idea was that Order's have rows like - OrderID|CustomerID|OrderDesc

 

So when i run $checkIsHavingOrders = mysql_query("SELECT * FROM orders ORDER BY OrderID DESC limit 10 WHERE CustomerID = '$myID'");

it should print

 

OrderID|CustomerID|OrderDesc

1001|1|Skin

1021|1|Skin

1031|1|Skin

 

(I made up the numbers so you can get image of thing i am trying to do..)

 

Thanks for your time!

[Ch0cu3r]

What are you asking? How to get the results from the query?

 

Have a look at the mysql_fetch_assoc.

 

NOTE: You should stop using the mysql_* functions as they are deprecated. Meaning they are no longer supported and could be removed from future versions of PHP. YOu should use mysqli or pdo instead.