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.



Thanks!

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...



I would really appreciate any help, or at least a tip to get around this.

BTW, I'm using PHP with MySQL.

Can you explain why? Your attempt above makes no sense at all to me...

What values do you need to get from the DB --- use SQL
What format do you need to write them out in -- use php

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



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!