fitching data from database

[imprint]

Good Morning all phpbuilders....🙂

i have one error in my script when i fetch the album title and description and pictures..... title and description is duplicated....

this is pic show my problem...

http://im42.gulfup.com/W3GwN.jpg

and this is my code...

<?php

include ('connect.php');

$sql="select albums.title,albums.description,albums.date,pictures.name from albums left join pictures on albums.date=pictures.date";
if ($query=mysql_query($sql)){

while ($row=mysql_fetch_array($query)){
echo "<h1>".$row['title']."</h1> <br><img src='pic/".$row['name']."'><br><h2>".$row['description']."</h2>";
}
}

?>

i want to fetch album pictures with one title and description....

i hope find good answers... 🙂

[imprint]

where r u.......................
if anyone didn't understand anything in my post tell me....

[Weedpacket]

imprint wrote:

where r u.......................

I don't know about the others, but I've been in bed and then at work.

[imprint]

imprint;11026509 wrote:

Good Morning all phpbuilders....🙂

i have one error in my script when i fetch the album title and description and pictures..... title and description is duplicated....

this is pic show my problem...

http://im42.gulfup.com/W3GwN.jpg

and this is my code...

<?php

include ('connect.php');

$sql="select albums.title,albums.description,albums.date,pictures.name from albums left join pictures on albums.date=pictures.date";
if ($query=mysql_query($sql)){

while ($row=mysql_fetch_array($query)){
echo "<h1>".$row['title']."</h1> <br><img src='pic/".$row['name']."'><br><h2>".$row['description']."</h2>";
}
}

?>

i want to fetch album pictures with one title and description....

i hope find good answers... 🙂

i want any one solve my problem.....