Code Forums - View Single Post

Wysocki · 02-07-2005, 05:10 PM

Code:

SELECT * FROM  `recvitem` 
ORDER BY if('0000-00-00'==shipdate,recvdate,shipdate)

Just tried the if() function above but this gives me a syntax error. Not sure why though.

[EDIT:] Son of a gun, I just can't seem to remember the syntax differences between PHP and MySql. The double equal sign got me! Now it works, thanx for your help!

02-07-2005, 05:10 PM	#5 (permalink)
Wysocki Recruit Join Date: Jan 2005 Location: Covina, CA Posts: 23	Code: SELECT * FROM `recvitem` ORDER BY if('0000-00-00'==shipdate,recvdate,shipdate) Just tried the if() function above but this gives me a syntax error. Not sure why though. [EDIT:] Son of a gun, I just can't seem to remember the syntax differences between PHP and MySql. The double equal sign got me! Now it works, thanx for your help!