You might be missing a quote so here and there unless you have the quotes stored in the database too.
Since your photos are stored on disk, make sure the webserver has access to them. Then make sure that your string is something like <img src="<path><photoFileName>"> in php: printf("<img src=\"%s%s\">", $somepath, $somefilename); in your php line: echo "<img src=".$row['photoFileName']." alt='photo'>"; the line echoed doesn't have any quotes in it. Ron elk dolk wrote: > Hi all, > I am new to web programming. > > I have code to add pictures to a MYSQL database. Now I can't seem to figure > out how to get them back out ! so we can see them. > The MySQL doesn't seem to be a problem (yet), also I'm trying to learn PHP. > > What I usually do is to load the images in a folder "img" and then the name > of the pic (i.e. "myphoto.jpg") in the database, so i retrieve the name of > the pic with: > > Code: <?php > $connex = MySQL_connect(server,login,password); > $sql_query = "select picname from photos where..."; > $result = MySQL_query($sql_query,$connex); > $row = MySQL_fetch_array($result); > ?> > > and then: > > Code: echo "<img src=".$row['photoFileName']." alt='photo'>"; > > but I can't see the photo > Any pointers or code samples will be greatly appreciated... > > > --------------------------------- > Bored stiff? Loosen up... > Download and play hundreds of games for free on Yahoo! Games. -- ================================================================= It's is not, it isn't ain't, and it's it's, not its, if you mean it is. If you don't, it's its. Then too, it's hers. It isn't her's. It isn't our's either. It's ours, and likewise yours and theirs. -- Oxford Uni Press ================================================================= Ron Croonenberg | | Phone: 1 765 658 4761 Lab Instructor & | Fax: 1 765 658 4732 Technology Coordinator | | Department of Computer Science | e-mail: [EMAIL PROTECTED] DePauw University | 275 Julian Science & Math Center | 602 South College Ave. | Greencastle, IN 46135 | ================================================================= http://www.csc.depauw.edu/RonCroonenberg.html ================================================================= -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php