A Question of Images...

Maz1701

Hey all!

I'm fairly new to PHP, but I've been working my way through and have been able to figure out a number of things, but I've hit a wall with one project...

I've been the (HTML only) Webmaster of a Star Trek based PBeM (play by e-mail) game for about three years now, and I'm tired of the constant updates that the changing roster of players requires. I've been working on a PHP driven roster table and have been able to get it looking almost like the original HTML page did. You can take a look at it at...

http://www.vex.net/~madcat/test/roster.php

Now this is a pretty basic table, with four columns for the character's name, rank, position, and species. In the original HTML table (located at http://www.vex.net/~madcat/caduceus/roster2.html ) the "Ranks" of the characters were replaced with images of the various ranks (yeah, yeah, very geeky I know).

To make a long story into a short question, how do I go about replacing text data from a MySQL database into an image from an image library and pasting it into the table in place of the text rank names? Do I need to alter the database? Can I enter URLs for images into a MySQL table? Or is there a way to dynamically take the rank name and pull the appropriate image from it?

Thanks!!!!

TGixer

maz,

im a newbie too, but i think you can replace your Rank name, with the image path (assuming the images are on the server already).

/images/rank1.jpg

and when u output the data just add the img tag.

echo "<img src=images/$picture_name><br>\n";

i think this is correct..hehe

good luck🙂

mrmufin

Yeah, I'm all for what TGixer suggested: store the image src="" path in the database, rather than the image. It's much faster to pull a short text string out of CHAR column than to pull the actual image out.

TGixer

wow..

I'm ACTUALLY learning!! hehe:p :rolleyes:

Chalk one up for me🙂 😃

Maz1701

Thanks Folks! This gives me something to work with...Once I get it ironed out, I'll most likely be asking about how to dynamicly change the BGCOLOR of cells in the table based on Rank...but one thing at a time!

Thanks again!