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.
I think I may have to do two SELECT statements, one for all the columns and one for the CONCAT image column. The problem is that I need to do this all in one line of SQL.
I've tried using multiple SELECT statements in several different ways, but I keep getting errors. For example...
Sorry, I should have been more descriptive. I actually just figured it out. See below:
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)