Jump to content

Archived

This topic is now archived and is closed to further replies.

vfd

storing and retriving paths - help wanted

Recommended Posts

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));

}

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.