linking images to mySQL database

[Charlie_chalk]

Hi

I understand its better to link images to you mySQL database than to put them in there. Can someone please tell me how I do either/both. I have to use phpmyadmin (host won't allow anything else).

When I put a link into the field it just outputs the link when called from my PHP page.

I've just created my first mySQL/PHP test thingy tonight, so I'm very new to all this, sorry if I sound thick!

Thanks

Steven

[compwizard]

First of all, you need to have a table with some fields, and a path field...something like this:

ID | PICPATH 
------------
1  | image1.jpg
2  | test654.jpg
3  | image5.jpg
4  | cat.jpg
5  | lion.jpg 

Then you need a sql statement like this:

<?php
    mysql_connect("localhost", "mysql_user", "mysql_password") or die("could not connect");
    mysql_select_db("mydb");

    $result = mysql_query("SELECT id, picpath FROM mytable");

    while ($row = mysql_fetch_array($result)) {
    echo "ID: " . $row[0] . " PIC = <img src='" . $row[1] . "'><hr>";       

   }

    mysql_free_result($result);
?>

Something similar to that anyway...you just have to use an HTML img tag with the src= to the picpath.