Image Path Help

[artisticre]

CREATE TABLE Label (
labelid int(4) NOT NULL auto_increment,
label varchar(100) NOT NULL default '',
picturelink longtext NOT NULL,
PRIMARY KEY (labelid),
UNIQUE KEY labelid (labelid)
) TYPE=MyISAM;

this is my table, I am really new to mysql & php. I would like to know how to make an image show up on my webpage. I don't want to use blobs. I understand you can just pass the path of the image but how?

thanks in advance

[Sphynx]

Well here's the way I do it. I store the image name in the DB, not the path. So that's pretty self-explanitory, eh. Insert your relavent data into the table.

Ok then you want to query your table. We'll deal with only the image name field for simplicity here.

// Connect to the DB and select your database
$dbconn = mysql_connect("localhost", "DB_USER_NAME", "DB_PASSWORD"); 
  mysql_select_db("DATABASE_NAME",$dbconn);

Next up, query the table and display the result. Here is where as a personal choice I echo back the img tag, the image path, and the file name that we query from the table.

$sql = "SELECT img_field_name FROM MY_TABLE";
$result = mysql_query($sql);
while($rs = mysql_fetch_array($result)){
  echo "<img src=\"YOUR/PATH/TO/IMAGE/".$rs['imagefieldname']."\">";
}

Hope that gives you the gist of the query and display?