Jump to content


Photo

storing and retriving paths - help wanted


  • Please log in to reply
2 replies to this topic

#1 vfd

vfd
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 17 June 2003 - 10:12 PM

Hi,

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))
{
do
{
printf(\"%s %s %s<br>\", $myrow[\"name\"], $myrow[\"photo\"], $myrow[\"profile\"]);
}
while ($myrow = mysql_fetch_array($result));
}

#2 deki

deki
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 17 June 2003 - 11:07 PM

Hey dude,

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

#3 michael yare

michael yare
  • Members
  • PipPip
  • Member
  • 25 posts
  • LocationLondon, UK

Posted 31 July 2003 - 08:37 AM

You need to output the HTML required to display the image path too...

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