query help

[corillo181]

[code]

<?php
include'../includes/db.php';
$conn=mysql_query("SELECT photo_id,path FROM tra_test_thumbs")or die(msql_error());
$find=mysql_query("SELECT path FROM tra_test_photo WHERE photo_id=$id");
while($fbp=mysql_fetch_array($find)&& $fetch=mysql_fetch_array($conn)){
?>
<a href="<?php echo $fbp['path'];?>"><img src="<?php echo $fetch['path'];?>"></a>

<?php
}
?>

[/code]

why isn't this working?

[joshi_v]

May be one of the two queries returning 0 rows!(In while loop you are using && condition.so )

[corillo181]

this did the trick

[code]

<?php
include'../includes/db.php';
$conn=mysql_query("SELECT photo_id,path FROM tra_test_thumbs")or die(msql_error());

while($fetch=mysql_fetch_array($conn)){
$id=$fetch['photo_id'];
$find=mysql_query("SELECT path FROM tra_test_photo WHERE photo_id=$id");
$fbp=mysql_fetch_array($find);
?>
<a href="<?php echo $fbp['path'];?>"><img src="<?php echo $fetch['path'];?>"></a>

<?php
}
?>

[/code]