Inserting Image

[Anon]

In my database I have a variable called "Image" where I placed the the end of the url of an image on my site (the unique part of the url). For example, one image is http://www.notjustball.com/images/arizona_cardinals/cardinals_bs.jpg
and I only inserted arizona_cardinals/cardinals_bs.jpg into my database, assuming that I could use this to tack onto the end of an img<> but I don't know how to do this. Does anyone know how I can insert a variable from my database into an image tag?

[Anon]

simple just echo the variable

<?
$image="bs";
?>

<image src="http://www.notjustball.com/images/arizona_cardinals/cardinals_<?echo$image;?>.jpg">

Assuming everything is a jpg this is the way to do it.

[mfoster]

/ Set a variable to your image directory. /

$image_directory = 'http://www.notjustball.com/images/';

/ Now log onto your database and grab the image you are want to tack onto the the directory url. /

/ Configure the login information /
$dbhost= "www.yourhost.com";
$dbuser= "your_username";
$dbpass= "your_username";
$dbname= "your_database";

/ Try to connect to database /
mysql_connect( "$dbhost", "$dbuser", "$dbpass") or
die ( "Unable to connect to database server...");

/ Select database /
mysql_select_db( "$dbname" ) or
die ( "Unable to select database...");

/ Select everthing from the table that you need /
$result=mysql_query(" SELECT * FROM images WHERE img='$img' ");

/ Set you result to a variable /
while ($row=mysql_fetch_array($result)){

$image1 = $row['image1'];

/ Now you have your database result and your image directory. Now combine them with . sign. /

$result = $image_directory . $image1;

This Should be it!

-Mark