We help IT Professionals succeed at work.
Get Started
div loop onclick show recordsets results
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.
thanks in advance for your help.
<?php require_once('Connections/Del_Comments.php'); ?>
<?php
if (!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 Path
FROM
asstatusupdate as a
left join asstatusdata as b
on a.id = b.sfk
right join ASWebInfo as e
on e.Uidfk = a.uidfk
right join ASManyAlbums as f
on f.UserId=a.uidfk
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 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 if
mysql_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 loop
echo '</table>';
?>
</body>
</html>
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE