ivyleong Posted January 5, 2009 Share Posted January 5, 2009 Hi, i am doing a thesis to enhance a database under my University server. I need to change the static table after the search page to a dynamic one where users can view data by sorting any column they like by click on the column name. I have no idea on it, anyone can help me? Thanks. The original coding is too complex and make me, a starter blur on it, hopefully you can understand it and please help me and tell me where should i correct it.. Thanks, cheers <? $cat=$_POST['cat']; $subcat=$_POST['subcat']; $subcat3=$_POST['subcat3']; $quer="MF"; $quer2="MP"; $quer3="Others"; $query="SELECT * FROM `$subcat3`"; //MySQL query $numresults = mysql_query ($query) or die ( "<center>Couldn't execute query<center>" ); //$row= mysql_fetch_array ($numresults); if ($subcat== $quer) { echo "<center><h1> <i>" . $subcat3 ."</i> </center></h1>"; //display results in tabular format echo " <table width=774 align=center height=69 border=1 bordercolor=#000000> <tr bordercolor=1 bgcolor=#0099FF> <td width=148><div align=center class=style7><strong><span class=style2>Sample_ID</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>Taxcode</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>SL</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>TL</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>BD</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>WT</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>Sex</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>Mat</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>Time</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>Gear</span></strong></div></td> </tr>"; while ($row= mysql_fetch_array ($numresults)){ //loop until all records from the table are selected echo "<tr bordercolor=1>"; echo "<td>". $row[ 'SAMPLE_ID' ] ."</td>"; echo "<td>". $row[ 'TAXCODE' ] ."</td>"; echo "<td>". $row[ 'SL' ] ."</td>"; echo "<td>". $row[ 'TL' ] ."</td>"; echo "<td>". $row[ 'BD' ] ."</td>"; echo "<td>". $row[ 'WT' ] ."</td>"; echo "<td>". $row[ 'SEX' ] ."</td>"; echo "<td>". $row[ 'MAT' ] ."</td>"; echo "<td>". $row[ 'TIME' ] ."</td>"; echo "<td>". $row[ 'GEAR' ] ."</td>"; echo "</tr>";} echo "</table>"; echo "<center><h3>Click on the link to view as Excel file: <a href='excel/". $subcat3 .".xls'>". $subcat3 ."</a></h3>"; //Link to Excel file echo "<center><input type=button value='Search another record' onClick=goToURL()></center>";} if ($subcat== $quer2) // If category selected from page "search3.php" is the same as the values given { echo "<center><h1> <i>" . $subcat3 ."</i> </center></h1>"; //display results in tabular format echo " <table width=774 align=center height=69 border=1 bordercolor=#000000> <tr bordercolor=1 bgcolor=#0099FF> <td width=148><div align=center class=style7><strong><span class=style2>Sample_ID</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>Taxcode</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>NO</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>CL</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>WT</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>SEX</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>MAT(gm)</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>Gear</span></strong></div></td> </tr>"; while ($row= mysql_fetch_array ($numresults)){ //loop until all records from the table are selected echo "<tr bordercolor=1>"; echo "<td>". $row[ 'SAMPLE_ID' ] ."</td>"; echo "<td>". $row[ 'TAXCODE' ] ."</td>"; echo "<td>". $row[ 'NO' ] ."</td>"; echo "<td>". $row[ 'CL' ] ."</td>"; echo "<td>". $row[ 'WT' ] ."</td>"; echo "<td>". $row[ 'SEX' ] ."</td>"; echo "<td>". $row[ 'MAT' ] ."</td>"; echo "<td>". $row[ 'GEAR' ] ."</td>"; echo "</tr>";} echo "</table>"; echo "<center><h3>Click on the link to view as Excel file: <a href='excel/". $subcat3 .".xls'>". $subcat3 ."</a></h3>"; //Link to Excel file echo "<center><input type=button value='Search another record' onClick=goToURL()></center>";} if ($subcat== $quer3)// If category selected from page "search3.php" is the same as the values given { echo "<center><h1><i>" . $subcat3 ."</i> </center></h1>"; //display results in tabular format echo " <table width=774 align=center height=69 border=1 bordercolor=#000000> <tr bordercolor=1 bgcolor=#0099FF> <td width=148<div align=center class=style7><strong><span class=style2>Date</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>Month</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>Time</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>Taxcode</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>Sample_ID</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>SL</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>TL</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>BD</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>WT</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>Sex</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>MAT</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>Gear</span></strong></div></td> <td width=148<div align=center class=style7><strong><span class=style2>Record</span></strong></div></td> <td width=148><div align=center class=style7><strong><span class=style2>CL</span></strong></div></td> </tr>"; while ($row= mysql_fetch_array ($numresults)){ //loop until all records from the table are selected echo "<tr bordercolor=1>"; echo "<td>". $row[ 'DATE' ] ."</td>"; echo "<td>". $row[ 'MONTH' ] ."</td>"; echo "<td>". $row[ 'TIME' ] ."</td>"; echo "<td>". $row[ 'TAXCODE' ] ."</td>"; echo "<td>". $row[ 'SAMPLE_ID' ] ."</td>"; echo "<td>". $row[ 'SL' ] ."</td>"; echo "<td>". $row[ 'TL' ] ."</td>"; echo "<td>". $row[ 'BD' ] ."</td>"; echo "<td>". $row[ 'WT' ] ."</td>"; echo "<td>". $row[ 'SEX' ] ."</td>"; echo "<td>". $row[ 'MAT' ] ."</td>"; echo "<td>". $row[ 'GEAR' ] ."</td>"; echo "<td>". $row[ 'Record' ] ."</td>"; echo "<td>". $row[ 'CL' ] ."</td>"; echo "</tr>";} echo "</table>"; echo "<center><h3>Click on the link to view as Excel file: <a href='excel/". $subcat3 .".xls'>". $subcat3 ."</a></h3>"; //Link to Excel file echo "<center><input type=button value='Search another record' onClick=goToURL()></center>";} ?> Quote Link to comment Share on other sites More sharing options...
vbnullchar Posted January 5, 2009 Share Posted January 5, 2009 you can use php+mysql or just javascript alone.. google around theres alot of javascripts that can do table sorting Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.