how do I ?......

Anon

Hi thanks for any help.....have images stored in folder and its name in stored in db as image_name how do i get those images back out? what is the syntax?..... thought it might be something similiar to this?....

<body>

<?php

$db = mysql_connect("localhost", "root");

mysql_select_db("antiques",$db);

$result = mysql_query("SELECT * FROM general",$db);

if ($myrow = mysql_fetch_array($result)) {

echo "<table border=1>\n";

echo "<tr><td>Name</td><td>Description</td><td>Price</td><td>Image Name</td></tr>\n";

do {

printf("<tr><td>%s </td><td>%s </td><td>%s </td><td>%s </td></tr>\n", $myrow["name"], $myrow["description"], $myrow["price"], $myrow["<img src=\"images/"image_name."\">"]);

} while ($myrow = mysql_fetch_array($result));

echo "</table>\n";

} else {

echo "Sorry, no records were found!";

}
?>
</body>

[deleted]

$myrow["<img src=\"images/"image_name."\">"]);

that doesn't make any sense does it? :-)

what you should do is put the filename in the tag, not the tag in the filename;

echo "<img src=\"images/".$myrow["image_name"]."\">");

Anon

thanks for that vincent, works at last....

echo "<img src=\"images/".$myrow["image_name"]."\">");

i have a question...what do the dots before $myrow and after the image_name"] do or mean?

Anon

The dots concatenate strings together. Say for example you had two strings:

$string1 = "Hello";
$string2 = "Name"; // somebody's name

And you wanted to get "Hello, Name" into a variable, you would do something like this:

$welcome = $string1 . ", " . $string2;

And $welcome will be what you wanted 🙂

Hope this helps,
-Josh B