[SOLVED] query error

[soycharliente]

I'm in the process of writing a password reset form. I have narrowed down the source of my problem to this bit of code found inside one of my queries.

 

md5(concat('[email protected]', '2007-07-30 08:35:58'))

 

I am using that in a comparison in one of my SQL queries. I tried running just that inside phpMyAdmin in a SQL window and it gives me an error.

 

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'md5(concat('[email protected]', '2007-07-30 08:35:58'))' at line

 

Can someone help me out and tell me what's wrong? And no, I didn't forget the line number. It just cut off.

[akitchin]

if you're running JUST the md5() command, SQL will choke because that isn't a valid statement.  it's expecting a query, not just a function:

 

SELECT md5(concat('[email protected]', '2007-07-30 08:35:58')) AS result

 

this should return the value, or give a better measure of the actual syntax error.