|
New to the CF scene
Join Date: Dec 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
Help needed to show hide table rows
Hi
Fairly new to this and am having a problem combining javascript with php. I have a basic database table set up as in the picture below.
I wanted to click the show and hide buttons in order to show/hide all the information below the top row for each record. I thought if I gave all the rows the same id the code I had would do this but it only hides the first of the rows (as in the picture below).
the code I am using is
Code:
<html>
<script language="JavaScript">
function fncShow(ctrl)
{
document.getElementById(ctrl).style.display = '';
}
function fncHide(ctrl)
{
document.getElementById(ctrl).style.display = 'none';
}
</script>
<?php
$username="root";
$password="cherry";
$database="staffdatabase";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM staffinformation WHERE Team= 'Juventus'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
<table border="1" cellspacing="1" cellpadding="1">
<tr>
<td><font face="Arial, Helvetica, sans-serif"></font></td>
<td><font face="Arial, Helvetica, sans-serif">Name</font></td>
<td><font face="Arial, Helvetica, sans-serif">Date Of Birth</font></td>
<td><font face="Arial, Helvetica, sans-serif">ID</font></td>
<td><font face="Arial, Helvetica, sans-serif">Login</font></td>
</tr>
<?php
$i=0;
while ($i < $num) {
$f1=mysql_result($result,$i,"Number");
$f2=mysql_result($result,$i,"UsableName");
$f3=mysql_result($result,$i,"staffID");
$f4=mysql_result($result,$i,"Position");
$f5=mysql_result($result,$i,"DateOfBirth");
?>
<tr>
<td>[<a href="JavaScript:fncShow('tr<?php echo $i;?>');">Show</a>] [<a href="JavaScript:fncHide('tr<?php echo $i;?>');">Hide</a>]</td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
</tr>
<tr id="tr<?php echo $i;?>">
<td><font face="Arial, Helvetica, sans-serif"></font></td>
<td><font face="Arial, Helvetica, sans-serif">Address</font></td>
<td><font face="Arial, Helvetica, sans-serif">Home Phone</font></td>
<td><font face="Arial, Helvetica, sans-serif">Mobile</font></td>
<td><font face="Arial, Helvetica, sans-serif">E-mail</font></td>
</tr>
<tr id="tr<?php echo $i;?>">
<td><font face="Arial, Helvetica, sans-serif"></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f8; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f9; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f10; ?></font></td>
</tr>
<tr id="tr<?php echo $i;?>">
<td><font face="Arial, Helvetica, sans-serif"></font></td>
<td><font face="Arial, Helvetica, sans-serif">Registration</font></td>
<td><font face="Arial, Helvetica, sans-serif">National Insurance</font></td>
<td><font face="Arial, Helvetica, sans-serif">Date Entered</font></td>
<td><font face="Arial, Helvetica, sans-serif">Personal Login</font></td>
</tr>
<tr id="tr<?php echo $i;?>">
<td><font face="Arial, Helvetica, sans-serif"></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f8; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f9; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f10; ?></font></td>
</tr>
<?php
$i++;
}
?>
</html>
Any help would be greatly appreciated, and could salvage what is left of Christmas!!!!!
|
|