Help With Where Query!!!

[lch_hosting]

Hi,
I am writing an order script and I need a command that will selected from a table where the email address matches the users input and where the id number is the greatest... What is the code to do that? Here is what I have so far

$query ="SELECT * FROM _step_two WHERE email='$user_email'" ;

I've spent hours trying to get it to work, anyone know how to do!? Thanks!!!

[Tranced]

hmm..perhaps i'm not the authority on this, but if you want just one entry based on this e-mail address that has the greatest ID number, you could try this-->

$query ="SELECT * FROM _step_two WHERE email='$user_email' ORDER BY ID DESC LIMIT 1" ;

i hope this helps.

[lch_hosting]

YOUR THE MAN !!! THAT WORKED THANKS SOO MUCH!!

[Tranced]

glad i could help