MySQL PHP Select Concat from Database, Select all columns and concat from same database Options

[Dante Monaldo]

I've been having some trouble with an SQL query and was wondering if someone could take a look.

I am trying to SELECT all of the columns in a database and CONCAT one column inside a image HTML tag. Ideally what I want is to retrieve all of the columns and put <img src=" and "/> around image_url column. Below is the working code that I have right now, but I can only get the image column with the HTML tags around it (my_image) to appear. None of the other columns write.

CODE

$sql = "SELECT CONCAT('<img src=\"', image_url, '\" width=\"50px\" />') AS my_image FROM products";

Thanks!

This post has been edited by Dante Monaldo: Mar 18 2012, 11:10 PM

[Dante Monaldo]

Sorry, I should have been more descriptive. I actually just figured it out. See below:

CODE

SELECT *, concat('<img src=\"', image_url, '\" width=\"50px\" />') AS image FROM products

Basically, I was trying to retrieve all the columns of a database and concat one column inside an image tag. I knew I was missing something small; turns out it was simply just a comma.

Thanks anyways though!