sorry, I know it's not your job to troubleshoot SQL, but if you can help me with this, I can't get this to work: I'm getting "no data available". here's my statement;
select *
IF(col17=1, "<img src= \"
www.mysite.com/images/red.png\", "<img src= \"
www.mysite.com/images/blue.png\")
FROM table1, table2 where table1.ID = table2.id
I've tried changing "col17=1" to "mycolumnname=1" as well
tried different ways to write the img src statement as well, using ' and ".
What am I missing here? Is the "if" in thye right place?
Thank you so much!
