Need help with MySQL Case statements

[urbandsigns.com]

Ok new to PHP. I've done this before with MSSQL but having a hard time in php.

[code]select (case when collectionImg = '' then '' else '<img src=' collectionImg '><br>' end) as collectionImg[/code]

Basically I want it to check to see if there is a collectionImg. If there is, build the html for me, if not do nothing. Everything works except it doesn't display the collectionImg variable. How do I need to format that part (collectionImg) to get it to work?

[Barand]

The posted code is SQL, not PHP. So where does PHP come into the frame?

[urbandsigns.com]

Good point. Meant to say new to PHP and MySql. Now how about some help?

[willpower]

$image= "my variable from the sql query"

if ($img<>"") {do this }


Thats pretty much it...a simple conditional statement.