The above was just for a simple test, not the statemnet I would use.
Now why would that not work?
If 'IS NULL' returns true, select '2' else select ',2'.
Problem is I get this error every time:
#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 'IS NULL(`vg_user_data`.`friends_list`), '2', ',2')' at line 1
I could check the field first, but why use two db calls when I should be able to do it in one?!
Thanks for any help.
Last edited by CrazyMerlin; 02-25-2007 at 11:21 PM.