Jump to content
#FlattenTheCurve ×

Swapping text to an image

Recommended Posts


I have a database with all my game collection on and have the code to display it on a webpage, my problem is in one field called Media, i have the text 'Physical' in it and i would like to change this within PHP to an image of a floppy disk when it displays on the webpage.

Can this be done.

I have done something similar with and if statement to display a 'tick' instead of a 1.


	( owned = 1, '✔', 'X' ) AS owned,
		( completed = 1, '✔', ' ' ) AS completed

i would like to do this as above rather than adding it to the MySQL database - the floppy image is on my computer in a folder called Images.

Share this post

Link to post
Share on other sites

if you want to do it in the query (as you have above) then something like

SELECT IF(Media='Physical', '<img src="images/floppy.png">', Media) as Media


Edited by Barand

Share this post

Link to post
Share on other sites

Hi thank you for your reply, I have tried the above code and I get a error

Parse error: syntax error, unexpected 'Images' (T_STRING) 

here is my Select code


		$sql = "SELECT

	IF(Media='Physical', '<img src="Images/floppy.png"">', Media) as Media



Share this post

Link to post
Share on other sites

Escape the quotes.

IF(Media='Physical', '<img src=\"Images/floppy.png\">', Media) as Media


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.