storing and retriving paths - help wanted
Posted 17 June 2003 - 10:12 PM
I am currently working on my website and am facing a problem.
I have a table of this sort...
Table name: persons
The fields are: name, photo, profile.
This is for my family website. For each person I have stored their photo link and their profile link.
For example for person1 the fields are...
person1, images/person1/image1.jpg, profiles/person1/index.html
When i query the database using \"phpmyadmin\" it shows all the fields. But
when I use the above php script and try to print each field... it prints the name field but shows blank for photo and profile. Could you kindly let me know what i\'m doing wrong.
This is the code i use...
$result = mysql_query($sqlquery);
if ($myrow = mysql_fetch_array($result))
printf(\"%s %s %s<br>\", $myrow[\"name\"], $myrow[\"photo\"], $myrow[\"profile\"]);
while ($myrow = mysql_fetch_array($result));
Posted 17 June 2003 - 11:07 PM
Something i found tough when i was learning Coldfusion, which i have noticed applies the same with PHP, When displaying an image from a database it has to be in an image tag, for e.g.
<img src=\"$images\"> Like that. Natrually you add the width and hight if needed.
Hope it helps, but i am a newbie too. But try it out anyways. Cheers
Posted 31 July 2003 - 08:37 AM
So for each instance of your loop, you must output:
echo "<img src = "";echo $row["imagepath"];echo "">";
Just as you would to display other HTML - data in table cells etc.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users