onclick display insert form

wizardry · May 17, 2011

how do i get this insert form to display for the results record id 1 once and record id 2 once instead of looping though all of foreign keys for record 1. this is in refferance to the code for sub query insert form on click.

for example: i have 10 records for record id 1 then the last record for 1 id is 10 that should show the insert form. instead of having all 10 records showing the form.

here is an example: www.only1wizard.com/UntitledDocument.pdf

thanks in advance for your help!

<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>';
?>

Sign In

onclick display insert form

Recommended Posts

wizardry

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information