how do i loop through all of the records for this subquery with the <div> being the main container for all of the records for that id. for instance when i have 10 records and i click on show records it displays all 10 records as to what it is doing now is displaying 1 record.
thanks in advance for your help.
<?php require_once('Connections/Del_Comments.php'); ?><?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue;}}if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO ascomments (Id, Memo, `Date`) VALUES (%s, %s, now())", GetSQLValueString($_POST['Id'], "int"), GetSQLValueString($_POST['Memo'], "text")); mysql_select_db($database_Del_Comments, $Del_Comments); $Result1 = mysql_query($insertSQL, $Del_Comments) or die(mysql_error());$Cfk = mysql_insert_id();$UId = '2'; $insertSQL = sprintf("INSERT INTO asmanystatusupdate (Id, SFk, CFk, CFk0, UIdFk0, UIdFk1, Dates) VALUES (%s, %s, '$Cfk', '$Cfk', '$UId', '$UId', now())", GetSQLValueString($_POST['Id'], "int"), GetSQLValueString($_POST['SFk'], "int")); mysql_select_db($database_Del_Comments, $Del_Comments); $Result1 = mysql_query($insertSQL, $Del_Comments) or die(mysql_error());}mysql_select_db($database_Del_Comments, $Del_Comments);$query_Recordset1 = "SELECT * FROM ahcomments";$Recordset1 = mysql_query($query_Recordset1, $Del_Comments) or die(mysql_error());$row_Recordset1 = mysql_fetch_assoc($Recordset1);$totalRows_Recordset1 = mysql_num_rows($Recordset1);?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>Untitled Document</title><script type="text/javascript"><!-- function toggle_visibility(id) { var e = document.getElementById(id); if(e.style.display == 'block') e.style.display = 'none'; else e.style.display = 'block'; }//--></script></head><body><?php//c.sfk={$row['sfk']}mysql_select_db($database_Del_Comments, $Del_Comments);$result = sprintf("SELECT a.Id, a.Type, a.Dates, a.UIdFk as UIdFk, b.Id as Did, b.comment as Comment, b.dates as Day, b.sfk as Sfk ,aes_decrypt(e.ProfileName, '$Ukey') as Name,substr(i.Path, 4) as PathFROM asstatusupdate as a left join asstatusdata as b on a.id = b.sfk right join ASWebInfo as eon e.Uidfk = a.uidfkright join ASManyAlbums as fon f.UserId=a.uidfkright join ASAlbums as gon f.AlbumId=g.Idright join ASTitle as hon g.Id=h.AlbumIdright join ASData as ion h.Id=i.TitleIdwhere a.uidfk in (select friendid from asfriends where uidfk0='1') and i.DefaultProfilePic='Y' order by dates desc;");$statusUpdate = mysql_query($result, $Del_Comments) or die(mysql_error());$category_id = '';echo '<table align="center" width="40%" border="3" cellpadding="0" cellspacing="0">'; while($row = mysql_fetch_array($statusUpdate)) { if ($row['Id'] != $category_id) { $category_id = $row['Id']; // grab table variables $Type = $row['Type']; $Dates = $row['Dates']; $Comment = $row['Comment']; $Name = $row['Name']; $Path = $row['Path']; $FriendId = $row['UIdFk']; $SFK = $row['Sfk']; echo '<tr>'; echo ' <td align="center">', $Name, '<br><a href="source/source.php?FriendId=',$FriendId,'"><img src="',$Path,'" height="120" width="120" align="middle" border="3" /></a></td>'; echo ' <td align="center"> ',$Dates,'<br><br>',$Type,'<br/>',$Comment,'</td>'; echo ' <td>',$category_id,'</td>'; echo ' <td>',$SFK,'</td>'; echo '</tr>'; } // end of ifmysql_select_db($database_Del_Comments, $Del_Comments); $comments= sprintf("SELECT c.sfk as sfk1, c.UIdFk0, d.Memo as Memo, d.Date as Dates1, e.ProfileName, substr(i.Path, 4) as Path FROM asmanystatusupdate as c left join ascomments as d on d.id = c.cfk right join ASWebInfo as e on e.Uidfk = c.uidfk0 right join ASManyAlbums as f on f.UserId=c.uidfk0 right join ASAlbums as g on f.AlbumId=g.Id right join ASTitle as h on g.Id=h.AlbumId right join ASData as i on h.Id=i.TitleId where c.sfk={$row['Sfk']} AND c.uidfk0 in (select friendid from asfriends where uidfk0='1') and i.DefaultProfilePic='Y' order by dates desc; ");$statusComments = mysql_query($comments, $Del_Comments) or die(mysql_error()); while($user_row = mysql_fetch_array($statusComments)){ // test the query //if($row['sfk'] == $user_row['sfk']) { $Dates1 = $user_row['Dates1']; $Memo = $user_row['Memo']; $Name1 = $user_row['Name']; $Path1 = $user_row['Path']; $FriendId1 = $user_row['UIdFk0']; $SFK1 = $user_row['sfk1']; //row and cell for "outer" while echo '<tr>'; echo '<td colspan="4" style="padding-left:1em;">'; // display table echo '<a href="#0'."$SFK1".'" onclick="toggle_visibility(\'foo1'."$SFK1".'\');" ;return false\" style=\"position:relative\">Click here to show records</a>'; // to show comment records echo '<div id="foo1'."$SFK1".'"style="position:relative;display:none">'; // to show comment records echo '<table align="center" width="60%" border="3" cellpadding="0" cellspacing="0">'; echo '<tr>'; echo ' <td align="center">',$Name1,'<br/><a href="source/source.php?FriendId=',$FriendId1,'"><img src="',$Path1,'" height="120" width="120" align="middle" border="3" /></a></td>'; echo ' <td align="center" width="40%"> ',$Dates1,'<br/><br/><br/>',$Memo,'</td>'; echo ' <td>' ,$category_id, '</td>'; echo ' <td>',$SFK1,'</td>'; echo '</tr>'; echo '</table>'; echo '</div>'; // for comment results show query //end row and cell for outer while //echo '</td>'; //echo '</tr>'; echo '<form action="$editFormAction" method="post" name="form1" id="form1">'; echo '<a href="#'."$SFK1".'" onclick="toggle_visibility(\'foo'."$SFK1".'\');" ;return false\" style=\"position:relative\">Click here to toggle visibility of element #foo</a>'; echo '<div id="foo'."$SFK1".'"style="position:relative;display:none">';echo '<table align="center">'; echo '<tr valign="baseline">'; echo '<td nowrap="nowrap" align="right">Memo:</td>'; echo '<td><input type="text" name="Memo" value="" size="32" /></td>'; echo '</tr>'; echo '<tr valign="baseline">'; echo '<td nowrap="nowrap" align="right"> </td>'; echo ' <td nowrap="nowrap" align="right"> </td>'; echo ' </tr>'; echo '<tr valign="baseline">'; echo ' <td nowrap="nowrap" align="right"> SFK:' ."$SFK1". '</td>'; echo ' <td><input type="submit" value="Insert record" /></td>'; echo ' </tr>'; echo ' </table>'; echo '<input type="hidden" name="Id" value="" />'; echo '<input type="hidden" name="Id" value="" />'; echo ' <input type="hidden" name="SFk" value="' ."$SFK1". '" />'; echo ' <input type="hidden" name="MM_insert" value="form1" />'; echo '</form>';echo '</div>'; } // end of if } // end of while loop}// end of main loopecho '</table>';?></body></html>