while uses

[B1011011]

Can you put a while loop inside another while loop?

I have a while loop putting items into the array and then printing them to the screen. But i want to run another while loop or connect to another DB to pull another set of data.

For instance... I have table1 that pulls x and y from a database and prints out in the while loop. I have table2 that has y and z. I want to print z with x and y but I cant seem to pull the data in a while loop inside DB1s while loop.

Any ideas or suggestions?

Ben

[CHeeSeBLiND]

yep, it is possible to put on while loop inside another

[B1011011]

how

[B1011011]

Heres code

<?
$dbuser = 'fiesty';
$dbhost = 'localhost';
$dbpass = '******';
$dbname = 'fiesty';
$dbtable = 'lookCat';
$mysql_link = mysql_connect($dbhost,$dbuser,$dbpass);
$column = mysql_list_fields($dbname,$dbtable,$mysql_link);
$sql = "SELECT IDref FROM $dbtable where Category = $IDcat";
$result = mysql_db_query($dbname,$sql);

while($value = mysql_fetch_array($result))
{
$cat = $value["Category"];
$idref = $value["IDref"];
print "<font face=\"Arial, Helvetica, sans-serif\"><a href=\"cimages.php?id=$idref\"> $idref </a></font><br>";
}

$dbuser = 'fiesty';
$dbhost = 'localhost';
$dbpass = '*******';
$dbname = 'fiesty';
$dbtable = 'pictures';
$mysql_link = mysql_connect($dbhost,$dbuser,$dbpass);
$column = mysql_list_fields($dbname,$dbtable,$mysql_link);
$sql = "SELECT * FROM $dbtable where ID = $idref";
$result = mysql_db_query($dbname,$sql);

while($value1 = mysql_fetch_array($result))
{
$desc = $value1["description"];
print "<font face=\"Arial, Helvetica, sans-serif\"><a href=\"cimages.php?id=$idref\"> $desc </a></font><br>";

}
?>

So see. I want to put desc from pictures in the same line as the print out from lookCat.

[CHeeSeBLiND]

<?PHP

$dbuser = 'fiesty'; 
$dbhost = 'localhost'; 
$dbpass = '******'; 
$dbname = 'fiesty'; 
$dbtable = 'lookCat'; 

$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
if (!@mysql_select_db("$dbname",$db))
    die("An Error Occured");

$sql = "SELECT IDref FROM $dbtable where Category = $IDcat"; 
$result = mysql_query($sql); 

while($value = mysql_fetch_array($result)) { 

   $cat = $value["Category"]; 
   $idref = $value["IDref"]; 

   print "<font face=\"Arial, Helvetica, sans-serif\"><a href=\"cimages.php?id=$idref\"> $idref </a>"; 

   $sql = "SELECT * FROM $dbtable where ID = $idref"; 
   $result2 = mysql_query($sql); 

   while($value1 = mysql_fetch_array($result)) {

      $desc = $value1["description"];

      print " <a href=\"cimages.php?id=$idref\"> $desc </a></font><br>"; 

}

} 

?>

i think that should work

[B1011011]

I got it!. Thanks!

[whofarted]

$result2 = mysql_query($sql); 

   while($value1 = mysql_fetch_array($result)) { 

should be

$result2 = mysql_query($sql); 

   while($value1 = mysql_fetch_array($result2)) { 

[CHeeSeBLiND]

oh yeah, hehe