problem reading images

[robertduif]

I try to retrieve uploaded images from a directory on the server (image-title is string in the database) with this code (att: $uploadname is the stringname of the image in the database):

$result = mysql_query ("SELECT onderwerp. tekst, datum, foto FROM wijkinfo ORDER BY datum",$link);
$uploadname = $_FILES['foto']['name'];

PRINT "<p align='left'><table>\n";
while ($myrow = mysql_fetch_row($result)) {
printf("<tr><td>Onderwerp: %s<br>Tekst: %s<br>Datum: %s<br>Foto:<br> %s img src=img/$uploadname width=300 height=300 border=1 </tr><tr></p>\n",
$myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6]);
}

The result is:
Onderwerp: Amusement
Tekst: abc
Datum: 2005-12-31
Foto:
AnnieSchmidtFr8.jpg1108743985.8086 img src=img/ width=300 height=300 border=1

For me that's quite an achievement, but I'd rather see the picture itself than the stringname.

Can anybody help please??? I'd be very grateful!

[hmemnon]

$FILES is a superglobal array created when you upload an image.
In your case you already have the images in your server, so $FILES is empty.
When you're doing $uploadimage=$_FILES['foto']['name'] you're basicly equaling your var to null.
If you want to get the picture just do
<img src=img/$myrow[4]>

Try it

Cheers

[robertduif]

Originally posted by hmemnon
$FILES is a superglobal array created when you upload an image.
In your case you already have the images in your server, so $FILES is empty.
When you're doing $uploadimage=$_FILES['foto']['name'] you're basicly equaling your var to null.
If you want to get the picture just do
<img src=img/$myrow[4]>

Try it

Cheers

Sorry, doesnt work either. Just gives broken links. Thanks anyway!

[robertduif]

Originally posted by robertduif
Sorry, doesnt work either. Just gives broken links. Thanks anyway!

After all it did work! $myrow[4] should be $myrow[3] (the fourth item, starting from 0). Apart from that I added microtime to the name of the images, but did it at the end so there was no extension. Now I put the time i front of the name. All problems solved!
Thanks again.

[hmemnon]

Great...
Good luck for your project, mark the thread as solved then mate

Cheers