Image link retrieval from database

evmace

Can someone tell me why this code doesn't work to call up an image link and put it in the HTML?

Thanks in advance.

<?php

if(isset($GET["id"])){$id=$GET["id"];}else{exit;}

$db = mysql_connect(XXXXX);
@mysql_select_db(XXXXX,$db);
$sql="SELECT * FROM gallery WHERE id=$id";
$query=@($sql, $db);
if (mysql_num_rows ($query)>0){
$row=@mysql_fetch_array ($query);
$image=$row["thumb"];
print $image;}
?>

then in my html: <img src="thumbs/thumb.php3?id=1">

sidney

try this

  if (mysql_num_rows ($query)>0){ 
$row=@mysql_fetch_array ($query); 
$image=$row["thumb"]; 
header("Location: $image");
exit;}

evmace

Nope, still didn't work. The images in my html still come up as missing images icons...and the source still says "img src="thumbs/thumb.php3?id=1" etc...

It's like it's not even getting to the PHP or something.

sidney

what idoes a sample image link look like

evmace

sidney

no ive seen that i mean the link held in the db

evmace

Oh sorry...

It's just the file name. (file.gif for example).

In the table there are fields for the image ID (id), thumbnail name (thumb), image name (image), and image description (title).

"thumb" always points to a file name only.

sidney

and what is the path to the image folder

evmace

there are two folders:

/gallery, which has the index.php3 file with img src links

and

/gallery/thumbs, which has thumb.php3 and all the thumbnail images in it...

sidney

try

header("Location: http://www.yourdomain.com/gallery/thumbs/$image");

evmace

Sadly, nope.

I've searched long and hard for an answer to this...I'm so confused why it's not working. Thanks for your help, though. Much appreciated...

sidney

can you link directly to a image in the folder direct using browser

http://www.yourdomain.com/gallery/thumbs/file.gif

evmace

Yup -- when I change the links in the index.php3 file to static links, they work just fine...

It's just when I refer to code, it doesn't.

sidney

and what is that link

evmace

Static:

www.domainname.com/gallery/thumbs/file.gif

Dynamic:

"www.domainname.com/gallery/index.php3" has img src references to "www.domainname.com/gallery/thumbs/thumb.php3?id=1" etc...

thumb.php3 has the code from the first post.

Forget about any links those images might have...I just want my thumbnails to actually pull up on "/gallery/index.php3"

sidney

we need to check you db is returning the file

make thumb.php your original code in your first post

link to thumbs.php by copi this into your address bar in your browser and replace domain name with real

www.domainname.com/gallery/thumbs/thumb.php3?id=1

you should get the file.gif(in text) outputed to browser