here is my code:
the 2nd while loop is not returning any data. I have two entries in the spr_guests table. Any ideas?
$sql = "SELECT * FROM spr_problemdata WHERE STATUS = 'Submitted' ORDER BY SPR_ID";
$rows = OCIParse($conn, $sql);
OCIExecute($rows);
echo "<table border='0' cellpadding='2' cellspacing='0' bgcolor='#000000'><tr bgcolor='#AAAAAA'><td><u>SPR#</u></td><td><u>Submitted by</u></td><td><u>Resolution?</u></td><td><u>Workaround?</u></td></tr>";
while (OCIFetchInto ($rows, $values)){
$spr = $values[0];
$sub_by = $values[1];
$prob_res = $values[11];
$workaround = $values[12];
$guestsql = "SELECT * FROM spr_guests";
$guestrow = OCIParse($conn, $guestsql);
OCIExecute($guestrow);
echo "<tr bgcolor='#CCCCCC'><td><a href='admin_verify_view.php?spr=$spr'>$spr</a></td><td><a href='mailto:";
while(OCIFetchInto($guestrow, $guestvalues))
{
$email = $guestvalues[2];
echo $email;
}
echo "'>$sub_by</a></td><td align='center'>";
if($prob_res != "")
{
echo "yes";
}
else
{
echo "no";
}
echo "</td><td align='center'>";
if($workaround != "")
{
echo "yes";
}
else
{
echo "no";
}
echo "</td>";
echo "</tr>";
}
