onclick display insert form

201 100+

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.

thanks in advance for your help!

Expand|Select|Wrap|Line Numbers

 
<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">&nbsp;</td>';

     echo ' <td nowrap="nowrap" align="right">&nbsp;</td>';

   echo ' </tr>';

    echo '<tr valign="baseline">';

     echo ' <td nowrap="nowrap" align="right">&nbsp;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>';

?>

Attached Files

Untitled Document.pdf.zip (1.99 MB, 120 views)

May 17 '11 #1

Subscribe Post Reply

2215

Bharat383

just make form in one <div> . give id for this <div> with style= display:none;

after make event onclick make code ;;

document.getElementByid("div_id").style.display="b lock";

May 17 '12 #2

by: Nick | last post by:

Hi, I am tring to display a form that does not show in either the task bar or when the user alt-tabs. The form is running full screen and is set to have no border. Nick

C# / C Sharp

Windows Service which will display a Form

by: Mr Utkal Ranjan Pradhan | last post by:

Hi Friends I want to develop a windows service application, which will open a port on the machine and constantly it will listen from that port. And when any data comes to that port I want to...

Visual Basic .NET

Using a .dll to display a form

by: Bernie Yaeger | last post by:

I have developed a .dll to display a form that controls a simple routine. Oddly, you can't use messagebox.show unless you do one of two things: either use an imports system.windows.forms or...

Visual Basic .NET

How to display second form?

by: Brett Romero | last post by:

My application start like this: frmMaster MainForm = new frmMaster(); System.Windows.Forms.Application.Run(MainForm); The flow is that MainForm shows then a SecondForm shows after the user...

C# / C Sharp

problem in display a form normally

by: yasker | last post by:

Hi, I got a problem in display a sub form. My app contains two form: main and sub. I want sub form display before main form, to provide some information to it. I use a NotifyIcon to activity...

C# / C Sharp

Display a form inside another form - Windows application.

by: Paul | last post by:

Is it possible to display a form inside another form? What component should I use?

Visual Basic .NET

Display Dynamic form on a click event of a Button

by: ak1dnar | last post by:

I need to display a form dynamically. First i load the page and at that time Login button will display. Nothing else. If some clicks the Login button, then only I want to display the Form. So...

PHP

Display a form in dialog mode by press any keys in the keybaord

by: Zaher Rabah | last post by:

How can I display a form in dialog mode by press any keys in the keybaord in access 2003. This form is used as calculater "For fast calculate" This is the idea.

Microsoft Access / VBA

close the splash and display next form

by: menyki | last post by:

am designing a software. in the software i want the splash to display for sometime, say 1 minute then it will close and the main form will come up. i included timer control in the splash form i...

.NET Framework

creating insert form n connecting it to database using asp.net

by: mandrekar salim | last post by:

hi guys , i'm using visual studio 2005. now i've to create a insert form which shud be connected to database(mssql). can any one tell me how to do dat. as i'm new to visual studio i dnt knw it.

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

onclick display insert form

Similar topics