php - How can i select last 10 charge code that user bought? -

i have table in mysql has 3 column , 1 code user bought it, others time code has bought , last 1 buyers phone number; exampale :

#code          #phone        #date 2154856265     3214490       2013-08-15

so how can make query in php format return me statement : want last 10 code user = 3214490 ordered date?

thanks patient ;)

you're kidding, right? trivial query get.

select code table phone = 3214490 order date desc limit 10

Detect