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.


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
                                              -- 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            |

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to