Printable Version of Topic

Click here to view this topic in its original format

HTMLHelp Forums _ Server-side Scripting _ MySQL PHP Select Concat from Database

Posted by: Dante Monaldo Mar 18 2012, 11:07 PM

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!

Posted by: Dante Monaldo Mar 19 2012, 07:44 PM

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

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


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

BTW, I'm using PHP with MySQL.

Posted by: Brian Chandler Mar 21 2012, 08:30 PM

QUOTE
The problem is that I need to do this all in one line of SQL.


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


Posted by: Dante Monaldo Mar 23 2012, 12:40 AM

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!

Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)