something like this : Inetpub\wwwroot\album\img
as I am running out of time! could someone complete this code just with one echo and img src so that I can retrive my photos ?
MySQL columns : photoID=seq number
photoFileName=name of my photo like 3sw.jpg
title=title
description=short description
<?php
$link = mysql_connect('localhost', 'root', 'pw');
if (!$link) {
die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db('album', $link);
$query = "SELECT * FROM photo";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result))
{
////echo???
}
mysql_free_result($result);
?>
The path would be relative to your web root folder.
in your case
<img src="/album/img/image_name">
or if you are testing on your own machine use
<img src="http://localhost/album/img/image_name";>
or if you need it to work for outside connections :
<img src="http://your_ip_addres/album/img/image_name";>
i suggest using the relative path.
while ($row = mysql_fetch_array($result)) {
echo "<img src='/album/img/".$row["photoFileName"]."' />
}
P.S.
Chris sorry for accidentaly sending it only to you the first time..
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
