hide/show columns

vuksy · #1 (**permalink**) 09-25-09, 04:59 AM

hi

i'm a biology student and very new to coding

i'm trying to make a website that will categorize and index documentaries (from usenet and p2p)non profit project

managed to make a table like this one frequency decoder ~ table sort (revisited) demo in dreamweaver

and now i'm trying to make checkboxes that will hide/show the columns , but it's hard cause it's a dynamic table plus i'm using the script from above

could someone help me with this ?

wirehopper · #2 (**permalink**) 09-25-09, 06:24 AM

Please post your code.

vuksy · #3 (**permalink**) 09-25-09, 06:40 AM

well this is the code

HTML Code:

<?php require_once('Connections/connection.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;
}
}
mysql_select_db($database_connection, $connection);
$query_Recordset1 = "SELECT Title, Category, Series, Episode, `Year`, Resolution, `Video Bitrate`, `Video Codec` FROM documentaries";
$Recordset1 = mysql_query($query_Recordset1, $connection) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
	<head>
    
    <script type="text/javascript" src="tablesort.<acronym title="JavaScript">js</acronym>"></script>
<script type="text/javascript">function hideShow("Title", "checkboxTitle"){
    if(document.getElementById("checkboxTitle").checked == true){ show("Title");}
    else{ hide("Title");}
    }

    function hide("Title"){
    document.getElementById("Recordset1").hideColumn(parseInt("Title"));
    document.getElementById("Recordset1").refreshView();
    };
    function show("Title"){
    document.getElementById("Recordset1").showColumn(parseInt("Title"));
    document.getElementById("Recordset1").refreshView();
    }; 
    var table = document.getElementByID("Recordset1");

table.rows[index]


    
    </script>
	<title>Main Table</title>
    
    <link href="StyleSheets.css" rel="stylesheet" type="text/css">
	</head>

	<body>
    <?php include("includes/header.php"); ?>
      <div align="center"><br>
        <span class="tip"></br>
        <br></br>
        Hold down shift to sort by multiple columns </span><br></br>
        <script fdTableSort.jsWrapper("Recordset1"); ></script>
      </div>
      <input type="checkbox" name="checkboxTitle" id="checkboxTitle" onclick ="hideShow('Title', 'checkboxTitle')">
      <table id="Recordset1" name="Recordset1">
        <tr>
          <th class="sortable" >Title</th>
          <th class="sortable" >Category</th>
          <th class="sortable" >Series</th>
          <th class="sortable" >Episode</th>
          <th class="sortable" >Year</th>
          <th class="sortable" >Resolution</th>
          <th class="sortable" >Video Bitrate</th>
          <th class="sortable" >Video Codec</th>
       </tr>
        <?php do { ?>
          <tr > 
            <td><?php echo $row_Recordset1['Title']; ?></td>
            <td><?php echo $row_Recordset1['Category']; ?></td>
            <td><?php echo $row_Recordset1['Series']; ?></td>
            <td><?php echo $row_Recordset1['Episode']; ?></td>
            <td><?php echo $row_Recordset1['Year']; ?></td>
            <td><?php echo $row_Recordset1['Resolution']; ?></td>
            <td><?php echo $row_Recordset1['Video Bitrate']; ?></td>
            <td><?php echo $row_Recordset1['Video Codec']; ?></td>
          </tr>
          <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
      </table>
<?php include("includes/footer.php"); ?>
</body>
     
</html>
<?php
mysql_free_result($Recordset1);
?>

and i've atached all my site files cause others have tried to help me with this but said they cant unless they have all the files

i hope you can look at these files with a virtual server , cause i think you'll need the php for this as well