PHP Image Variable.

[Jack!]

I have a variable stored in a database, which is a number up to three characters long (I.e 234)

I wish to display an image called the same as the number in the database, which obviously varies per account.

How can I get it to display something like www.site.com/234.png on the page? www.site.com/number.png?

Sorry if it doesn't make sense.

Jack.

[Huggies]

I have a variable stored in a database, which is a number up to three characters long (I.e 234)

I wish to display an image called the same as the number in the database, which obviously varies per account.

How can I get it to display something like www.site.com/234.png on the page? www.site.com/number.png?

Sorry if it doesn't make sense.

Jack.

<?php
$sql = "SELECT your_image FROM your_table WHERE your_conditions_here";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
?>
<img src="<?php echo $row['your_image']; ?>" />
<?php
} ?>

something like that?

[Jack!]

<?php
$sql = "SELECT your_image FROM your_table WHERE your_conditions_here";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
?>
<img src="<?php echo $row['your_image']; ?>" />
<?php
} ?>

something like that?

<img src="/images/skins/<?php echo $row['your_image']; ?>.png" />

Would that work?

[Huggies]

<img src="/images/skins/<?php echo $row['your_image']; ?>.png" />

Would that work?

I think it should, sorry I can't help you out alot, I'm fairly new to PHP. Let me know if it does work though!

[Jack!]

I think it should, sorry I can't help you out alot, I'm fairly new to PHP. Let me know if it does work though!

Didn't work, haha.

[Blinger]

You need to get $row from a query from the database. So you perform your query, then I do a number rows to see if it exists (returns 1 - not sure if needed), then do the $rows = mysql_fetch_array.
Jacks method looks okay.

[Jack!]

You need to get $row from a query from the database. So you perform your query, then I do a number rows to see if it exists (returns 1 - not sure if needed), then do the $rows = mysql_fetch_array.
Jacks method looks okay.

Well what I currently have is a config file that grabs the data from the database and stores it in a session which all works fine, what I was trying is:

<img src="/images/skins/<?php echo $_SESSION['skin']; ?>.png" />

Is what I was trying but no luck, should that work?

[Blinger]

Well what I currently have is a config file that grabs the data from the database and stores it in a session which all works fine, what I was trying is:

<img src="/images/skins/<?php echo $_SESSION['skin']; ?>.png" />

Is what I was trying but no luck, should that work?

post your config file.

[Jack!]

post your config file.

Config file works fine as I have other sessions stored that gather the information and display it elsewhere on the system fine.

[Blinger]

Config file works fine as I have other sessions stored that gather the information and display it elsewhere on the system fine.

It's hard to say if your script should work or not without seeing it. Post that snippet of code then.