hi,
i have a php script tht displays data from 4 different mysql tables in a table format. i want to export it to an excel sheet on click of a button.i really dunno how to do tht can someone pls.
the code for the page which displays the data and the tables is attached with this post.
<?php
//storing page to use during redirection after login
$frompage = "estimation";
$salescrmmain='id="current"';
//$frompage1 = "contact";
include("loginchk.php");
$user = $_SESSION['username_ses'];
$query = "SELECT permission FROM employees WHERE EmpName='$user'";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$perm=$row['permission'];;
}
//$perm="admin";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html >
<head>
<title>Employ Me - Creating Feature List Estimation</title>
<link href="images/styles.css" rel="stylesheet" type="text/css" />
</head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="js/menu.css">
<script src="images/calendar2.js"></script>
<script type="text/javascript">
function extractNumber(obj, decimalPlaces, allowNegative)
{
var temp = obj.value;
// avoid changing things if already formatted correctly
var reg0Str = '[0-9]*';
if (decimalPlaces > 0) {
reg0Str += '\\.?[0-9]{0,' + decimalPlaces + '}';
} else if (decimalPlaces < 0) {
reg0Str += '\\.?[0-9]*';
}
reg0Str = allowNegative ? '^-?' + reg0Str : '^' + reg0Str;
reg0Str = reg0Str + '$';
var reg0 = new RegExp(reg0Str);
if (reg0.test(temp)) return true;
// first replace all non numbers
var reg1Str = '[^0-9' + (decimalPlaces != 0 ? '.' : '') + (allowNegative ? '-' : '') + ']';
var reg1 = new RegExp(reg1Str, 'g');
temp = temp.replace(reg1, '');
if (allowNegative) {
// replace extra negative
var hasNegative = temp.length > 0 && temp.charAt(0) == '-';
var reg2 = /-/g;
temp = temp.replace(reg2, '');
if (hasNegative) temp = '-' + temp;
}
if (decimalPlaces != 0) {
var reg3 = /\./g;
var reg3Array = reg3.exec(temp);
if (reg3Array != null) {
// keep only first occurrence of .
// and the number of places specified by decimalPlaces or the entire string if decimalPlaces < 0
var reg3Right = temp.substring(reg3Array.index + reg3Array[0].length);
reg3Right = reg3Right.replace(reg3, '');
reg3Right = decimalPlaces > 0 ? reg3Right.substring(0, decimalPlaces) : reg3Right;
temp = temp.substring(0,reg3Array.index) + '.' + reg3Right;
}
}
obj.value = temp;
}
function blockNonNumbers(obj, e, allowDecimal, allowNegative)
{
var key;
var isCtrl = false;
var keychar;
var reg;
if(window.event) {
key = e.keyCode;
isCtrl = window.event.ctrlKey
}
else if(e.which) {
key = e.which;
isCtrl = e.ctrlKey;
}
if (isNaN(key)) return true;
keychar = String.fromCharCode(key);
// check for backspace or delete, or if Ctrl was pressed
if (key == 8 || isCtrl)
{
return true;
}
reg = /\d/;
var isFirstN = allowNegative ? keychar == '-' && obj.value.indexOf('-') == -1 : false;
var isFirstD = allowDecimal ? keychar == '.' && obj.value.indexOf('.') == -1 : false;
return isFirstN || isFirstD || reg.test(keychar);
}
function add1(cost,hours,tot_cost){
//alert(hours);
var inp=cost.length;
var count=(cost.charAt(inp-1));
var new_hr= hours+count;
var cost =document.getElementById(cost).value;
var hours= document.getElementById(new_hr).value;
var total_cost= (cost + hours);
document.getElementById(tot_cost).value = total_cost;
}
function add(inputname,x) {
//alert(inputname);
var inp=inputname.length;
var count=(inputname.charAt(inp-1));
var sum = 0;
var valid = true;
//alert(count);
for(i =0; i < count; i++)
{
var n =x+i;
var k= parseInt(document.getElementById(n).value);
sum = (sum+k);
}
if(valid) {
document.getElementById(inputname+"_add").value = sum;
}
else{
alert("Please enter numbers only");
}
}
/*function add1(inputname,x) {
//alert(x);
var sum = 0;
var valid = true;
var inputs = document.getElementsByName(x);
for(i =0; i < inputs.length; i++) {
if( inputs*.value.match( /^[0]*(\d+)$/)) {
sum += parseInt(RegExp.$1);
}
else {valid=false;}
}
if(valid) {
document.getElementById(inputname).value = sum;
}
else{
alert("Please enter numbers only");
}
}*/
function multiply(cost,hours,tot_cost){
var inp=cost.length;
var count=(cost.charAt(inp-1));
var new_hr= hours+count;
var cost =document.getElementById(cost).value;
var hours= document.getElementById(new_hr).value;
var total_cost= (cost * hours);
document.getElementById(tot_cost).value = total_cost;
}
</script>
<style type="text/css">
<!--
.style1 {color: #000000}
-->
</style>
<body leftmargin="2" topmargin="0" marginheight="2" marginwidth="0">
<?php
if (isset($_POST['submit1']) && $_POST['select1'] !='0' ){
$proj_selected=$_POST['select1'];
$visible='style="visibility:visible"';
}
else
{
$visible='style=" visibility:hidden"';
}
?>
<table width="100%" height="50%" border="0" cellpadding="0" cellspacing="0" bgcolor="#F6F7F2">
<!-- First Row -->
<tr>
<td><?php include("header.php"); ?></td>
</tr>
<!-- First Row End -->
<tr>
<!-- Second Row End -->
<td height="425" valign="top" bgcolor="f6f7f2" >
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><span class="bigfnt">
Create Feature List Estimation </span></td>
</tr>
</table>
<table width="97%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#D0CDAE" >
<tr>
<td align="center"><br />
<?php
if($msg!="")
{ ?> <span class="smallmsg"><? echo $msg; } ?></span>
<div>
<div>
<form name="form1" action="<?php $_SERVER['PHP_SELF'] ?>" method="post">
<span class="menufnt">Select Project:</span><select name="select1" id="select1" class="menufnt" id="txtcust">
<option value="0" >-Select-</option>
<? $sql=mysql_query("select distinct(projName),pid from feat_proj");
while($sql_rs=mysql_fetch_object($sql))
{?>
<option value="<?=$sql_rs->pid?>" >
<?=$sql_rs->projName?>
</option>
<? } ?>
</select >
<input type="submit" name="submit1" id="submit1" value="submit" />
</form></div>
<table width="81%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td scope="col"> </td>
</tr>
</table>
</div>
<div id="form_tbl" <?php echo $visible;?> >
<form name="feat_est" method="post" action="feat_estipro.php">
<table width="81%" height="233" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#D0CDAE">
<tr>
<td>
<input type="hidden" name="permission" id="permission" value="<?php echo $perm; ?>">
<?php
$c=0;
echo "<table border='1' align='center'>";
echo "<tr> <th>Module Name</th> <th>Section Name</th> <th>Project Manager</th> <th>Designer</th> <th>Developer</th> </tr>";
$res = "SELECT * FROM feat_estimation where pId='$proj_selected' ";
$result = mysql_query($res) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result))
{
$pm_total_hr=$row['pm_tot_hr'];
$des_total_hr=$row['des_tot_hr'];
$dev_total_hr=$row['dev_tot_hr'];
$pm_cost=$row['pm_cost'];
$des_cost=$row['des_cost'];
$dev_cost=$row['dev_cost'];
$pm_total_cost=$row['pm_tot_cost'];
$des_total_cost=$row['des_tot_cost'];
$dev_total_cost=$row['dev_tot_cost'];
}
$query = "SELECT * FROM feat_proj fp,feat_mod fm,feat_sec fs where fp.pId='$proj_selected' AND fp.pid=fm.pId And fp.pId=fs.pid And fm.mId=fs.mId";
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result))
{
echo "<tr><td class='fields'>";
echo $row['modName'];
echo"</td><td class='fields'>";
echo $row['secName'];
echo"</td><td>";?>
<input type="hidden" name="projId" value="<?php echo $row['pId'];?>">
<input type="text" name="<?php echo 'pm'.$c ;?>"id="<?php echo 'pm'.$c;?>" <?php if ($perm!='pm' ){?>
disabled="disabled"<?php } ?> value="<?php echo $row['pm_hr'];?>" onBlur="extractNumber(this,0,false);add1(this.id,'pm_tot','pm_tot');" onKeyPress=
"return blockNonNumbers(this,event, false,false);" onKeyUp="extractNumber(this,0,false);" size="20" maxlength="2"/>
<?php echo"</td><td>";?>
<input type="text" name="<?php echo 'des'.$c ;?>" id="<?php echo 'des'.$c ;?>" <?php if ($perm!='des' ){?>
disabled="disabled"<?php } ?> value="<?php echo $row['des_hr'];?>" onBlur="extractNumber(this,0,false);"
onKeyPress="return blockNonNumbers(this, event, false, false);"
onKeyUp="extractNumber(this,0,false);" size="20" maxlength="2"/>
<?php echo"</td><td>";?>
<input type="text" name="<?php echo 'dev'.$c ;?>" id="<?php echo 'dev'.$c ;?>" <?php if ($perm!='dev' ){?>
disabled="disabled"<?php } ?> value="<?php echo $row['dev_hr'];?>" onBlur="extractNumber(this,0,false);" onKeyPress="return blockNonNumbers(this, event, false,
false);" onKeyUp="extractNumber(this,0,false);" size="20" maxlength="2"/>
<?php echo "</td></tr>";
$c++;
}
echo "<tr><td>";
echo "";
echo"</td><td>";
echo "";
echo"</td><td>";?>
<input type=button value="Add" name="<?php echo 'pm_tot'.$c ;?>" onClick="add(this.name,'pm')">
<?php echo"</td><td>";?>
<input type=button value="Add" name="<?php echo 'des_tot'.$c ;?>" onClick="add(this.name,'des')">
<?php echo"</td><td>";?>
<input type=button value="Add" name="<?php echo 'dev_tot'.$c ;?>" onClick="add(this.name,'dev')">
<?php echo "</td></tr>";
echo "<tr><td>";
echo "";
echo"</td><td>";
echo "<span class='fields'>Total Hours</span>";
echo"</td><td>";?>
<input type="text" name="<?php echo 'pm_tot'.$c ;?>" id="<?php echo 'pm_tot'.$c.'_add' ;?>"
value="<?php echo $pm_total_hr;?>" <?php if ($perm!='pm' ){?>
disabled="disabled"<?php } ?> readonly />
<?php echo"</td><td>";?>
<input type="text" name="<?php echo 'des_tot'.$c ;?>" id="<?php echo 'des_tot'.$c.'_add' ;?>"
value="<?php echo $des_total_hr;?>" <?php if ($perm!='des' ){?>
disabled="disabled"<?php } ?> readonly />
<?php echo"</td><td>";?>
<input type="text" name="<?php echo 'dev_tot'.$c ;?>" id="<?php echo 'dev_tot'.$c.'_add' ;?>"
value="<?php echo $dev_total_hr;?>" <?php if ($perm!='dev' ){ ?>
disabled="disabled"<?php } ?> readonly />
<?php echo "</td></tr>";
echo "<tr><td>";
echo "";
echo"</td><td>";
echo "<span class='fields'>Cost/hr</span>";
echo"</td><td>";?>$
<input type="text" name="<?php echo 'pm_cost'.$c ;?>" id="<?php echo 'pm_cost'.$c ;?>"
<?php if ($perm!='admin'){?>disabled="disabled"<?php } ?> value="<?php echo $pm_cost;?>"
onBlur="extractNumber(this,2,false);multiply(this.id,'pm_tot','pm_tot_cost');"
onKeyPress="return blockNonNumbers(this, event, true, false);" onKeyUp="extractNumber(this,2,false);"
size="20" maxlength="6"/>
<?php echo"</td><td>";?>$
<input type="text" name="<?php echo 'des_cost'.$c ;?>" id="<?php echo 'des_cost'.$c ;?>"
<?php if ($perm!='admin'){?>disabled="disabled"<?php } ?> value="<?php echo $des_cost;?>"
onBlur="extractNumber(this,2,false);multiply(this.id,'des_tot','des_tot_cost');"
onKeyPress="return blockNonNumbers(this, event, true, false);" onKeyUp="extractNumber(this,2,false);"
size="20" maxlength="6"/>
<?php echo"</td><td>";?>$
<input type="text" name="<?php echo 'dev_cost'.$c ;?>" id="<?php echo 'dev_cost'.$c ;?>"
<?php if ($perm!='admin'){?>disabled="disabled"<?php } ?> value="<?php echo $dev_cost;?>"
onBlur="extractNumber(this,2,false);multiply(this.id,'dev_tot','dev_tot_cost');"
onKeyPress="return blockNonNumbers(this, event, true, false);" onKeyUp="extractNumber(this,2,false);"
size="20" maxlength="6"/>
<?php echo "</td></tr>";
echo "<tr><td>";
echo "";
echo"</td><td>";
echo "<span class='fields'>Total Cost</span>";
echo"</td><td>";?>$
<input type="text" name="pm_tot_cost" id="pm_tot_cost" <?php if ($perm!='admin' ){?>
disabled="disabled"<?php } ?> readonly value="<?php echo $pm_total_cost;?>" />
<?php echo"</td><td>";?>$
<input type="text" name="des_tot_cost" id="des_tot_cost" <?php if ($perm!='admin' ){?>
disabled="disabled"<?php } ?> readonly value="<?php echo $des_total_cost;?>" />
<?php echo"</td><td>";?>$
<input type="text" name="dev_tot_cost" id="dev_tot_cost" <?php if ($perm!='admin' ){?>
disabled="disabled"<?php } ?> readonly value="<?php echo $dev_total_cost;?>" />
<?php echo "</td></tr>";
echo "</table>";
//echo $c;
?>
</td>
</tr>
<tr><td align="center"><input type="submit" name="submit2" value="submit" /><input type="hidden" name="count" value="<?php echo $c;?>"></td></tr>
</table>
</form>
</div>
</table></td></tr></table>
</td>
</tr>
<tr>
<td height="15" valign="top" bgcolor="f6f7f2"><?php include("footer.php") ?></td>
</tr>
</table>
</body>
</html>
-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 06, 2009 at 06:32 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `v2soft_employeme_test`
--
-- --------------------------------------------------------
--
-- Table structure for table `feat_estimation`
--
CREATE TABLE `feat_estimation` (
`EstId` int(11) NOT NULL auto_increment,
`pId` int(11) NOT NULL,
`pm_tot_hr` int(11) NOT NULL default '0',
`des_tot_hr` int(11) NOT NULL default '0',
`dev_tot_hr` int(11) NOT NULL default '0',
`pm_cost` int(11) NOT NULL default '1',
`des_cost` int(11) NOT NULL default '1',
`dev_cost` int(11) NOT NULL default '1',
`pm_tot_cost` int(11) NOT NULL default '0',
`des_tot_cost` int(11) NOT NULL default '0',
`dev_tot_cost` int(11) NOT NULL default '0',
PRIMARY KEY (`EstId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `feat_estimation`
--
INSERT INTO `feat_estimation` (`EstId`, `pId`, `pm_tot_hr`, `des_tot_hr`, `dev_tot_hr`, `pm_cost`, `des_cost`, `dev_cost`, `pm_tot_cost`, `des_tot_cost`, `dev_tot_cost`) VALUES
(1, 2, 22, 6, 9, 2, 3, 4, 12, 45, 96),
(4, 13, 4, 0, 0, 1, 1, 1, 0, 0, 0),
(5, 22, 5, 0, 0, 1, 1, 1, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `feat_mod`
--
CREATE TABLE `feat_mod` (
`mId` int(11) NOT NULL auto_increment,
`pId` int(11) NOT NULL,
`modName` longtext NOT NULL,
PRIMARY KEY (`mId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;
--
-- Dumping data for table `feat_mod`
--
INSERT INTO `feat_mod` (`mId`, `pId`, `modName`) VALUES
(1, 1, 'fenner mod 1'),
(4, 2, 'adea mod2'),
(5, 3, 'module1'),
(6, 3, 'module2'),
(9, 5, 'aditi module1'),
(10, 5, 'aditi mod2'),
(11, 5, 'aditi mod3'),
(12, 5, 'aditi mod4'),
(13, 13, 'aol module1'),
(14, 14, 'aol module1'),
(15, 15, 'aol module1'),
(16, 16, 'aol module1'),
(17, 17, 'aol module1'),
(18, 18, 'TestModule3 '),
(19, 19, 'TestModule3 '),
(20, 20, 'TestModule3 '),
(21, 21, 'Mod'),
(22, 22, 'trilogy mod1'),
(23, 22, 'trilogy mod2'),
(24, 23, 'gm1'),
(25, 23, 'gm2'),
(26, 23, 'gm3'),
(27, 23, 'gm4'),
(28, 23, 'gm5'),
(29, 26, 'TestModule1'),
(30, 26, 'TestModule2'),
(31, 26, 'TestModule3 '),
(32, 26, 'TestModule3 4'),
(33, 27, ''),
(34, 28, 'mod1'),
(35, 28, 'mod2'),
(36, 29, 'Test SameModuel');
-- --------------------------------------------------------
--
-- Table structure for table `feat_proj`
--
CREATE TABLE `feat_proj` (
`pId` int(11) NOT NULL auto_increment,
`domain` varchar(50) NOT NULL,
`projName` longtext NOT NULL,
`scope` longtext NOT NULL,
PRIMARY KEY (`pId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
--
-- Dumping data for table `feat_proj`
--
INSERT INTO `feat_proj` (`pId`, `domain`, `projName`, `scope`) VALUES
(1, 'Fenner (India) Limited', 'Fenner India Proj', 'scope of fenner india'),
(2, 'Adea Solutions', 'Adea Proj', 'scope of Adea Solutions scope of Adea Solutions scope of Adea Solutions scope of Adea Solutions scope of Adea Solutions scope of Adea Solutions scope of Adea Solutionsscope of Adea Solutions scope of Adea Solutions'),
(3, 'Birlasoft', 'projname', 'scope'),
(5, 'Aditi', 'Aditi project', 'scope of aditi project scope of aditi project scope of aditi projectscope of aditi project scope of aditi project'),
(13, 'AOL', 'AOL PROJ', 'AOL PROJ'),
(22, 'TRILOGY', 'trilogy', 'trilogy scope'),
(23, 'GM', 'general motors', 'The PHP Development Team would like to announce the immediate availability of PHP 5.2.8. This release addresses a regression introduced by 5.2.7 in regard to the magic_quotes functionality, which was broken by an incorrect fix to the filter extension. All users who have upgraded to 5.2.7 are encouraged to upgrade to this release. Alternatively you can apply a work-around for the bug by changing "filter.default_flags=0" in php.ini.'),
(25, '0', 'ggg', ''),
(26, 'Fenner (India) Limited', 'TestFeatureList', 'TestScope'),
(27, 'Fenner (India) Limited', 'TestProject', ''),
(28, 'Cranes Software', 'cranes', 'hgfhgf'),
(29, 'Fenner (India) Limited', 'TestProject', '');
-- --------------------------------------------------------
--
-- Table structure for table `feat_sec`
--
CREATE TABLE `feat_sec` (
`sId` int(11) NOT NULL auto_increment,
`pId` int(11) NOT NULL,
`mId` int(11) NOT NULL,
`secName` longtext NOT NULL,
`pm_hr` int(3) NOT NULL default '0',
`des_hr` int(3) NOT NULL default '0',
`dev_hr` int(3) NOT NULL default '0',
PRIMARY KEY (`sId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=79 ;
--
-- Dumping data for table `feat_sec`
--
INSERT INTO `feat_sec` (`sId`, `pId`, `mId`, `secName`, `pm_hr`, `des_hr`, `dev_hr`) VALUES
(1, 1, 1, 'fenner mod1 sec1', 0, 0, 0),
(2, 1, 1, 'fenner mod 1 sec2', 0, 0, 0),
(7, 2, 4, 'adea mod2 sec1', 3, 6, 9),
(8, 3, 5, 'sec1.1', 0, 0, 0),
(9, 3, 5, 'sec1.2', 0, 0, 0),
(10, 3, 6, 'sec2.1', 0, 0, 0),
(11, 3, 6, 'sec2.2', 0, 0, 0),
(19, 2, 4, 'adea mod2 sec2', 3, 0, 0),
(22, 5, 9, 'aditi mod1 sec1', 0, 0, 0),
(23, 5, 9, 'aditi mod1 sec2', 0, 0, 0),
(24, 5, 9, 'aditi mod1 sec3', 0, 0, 0),
(26, 5, 10, 'aditi mod2 sec1', 0, 0, 0),
(27, 5, 10, 'aditi mod2 sec2', 0, 0, 0),
(28, 5, 11, 'aditi mod3 sec1', 0, 0, 0),
(29, 5, 12, 'aditi mod4 sec1', 0, 0, 0),
(41, 13, 13, 'aol mod1 section2', 0, 0, 0),
(43, 21, 21, '1', 0, 0, 0),
(44, 21, 21, '2', 0, 0, 0),
(45, 22, 22, 'trilogy mod1 sec1', 1, 0, 0),
(46, 22, 22, 'trilogy mod1sec2', 1, 0, 0),
(47, 22, 22, 'trilogy mod1sec3', 1, 0, 0),
(48, 22, 23, 'trilogy mod2sec1', 1, 0, 0),
(49, 22, 23, 'trilogy mod2sec2', 1, 0, 0),
(50, 5, 12, 'aditi mod4 sec2', 0, 0, 0),
(51, 23, 24, 'gm submodule 1.1', 0, 0, 0),
(52, 23, 24, 'gm submodule1.2', 0, 0, 0),
(53, 23, 25, 'gm submodule 2.1', 0, 0, 0),
(54, 23, 25, 'gm submodule 2.2', 0, 0, 0),
(55, 23, 25, 'gm submodule 2.3', 0, 0, 0),
(56, 23, 26, 'gm submodule 3.1', 0, 0, 0),
(57, 23, 26, 'gm submodule 3.2', 0, 0, 0),
(58, 23, 26, 'gm submodule 3.3', 0, 0, 0),
(59, 23, 26, 'gm submodule 3.4', 0, 0, 0),
(60, 23, 27, 'gm submodule 4.1', 0, 0, 0),
(61, 23, 27, 'gm submodule 4.2', 0, 0, 0),
(62, 23, 27, 'gm submodule 4.3', 0, 0, 0),
(63, 23, 27, 'gm submodule 4.4', 0, 0, 0),
(64, 23, 27, 'gm submodule 4.5', 0, 0, 0),
(65, 23, 28, 'gm submodule 5.1', 0, 0, 0),
(66, 23, 28, 'gm submodule 5.2', 0, 0, 0),
(67, 23, 28, 'gm submodule 5.3', 0, 0, 0),
(68, 23, 28, 'gm submodule 5.4', 0, 0, 0),
(69, 23, 28, 'gm submodule 5.5', 0, 0, 0),
(70, 26, 29, 'TestSubModule1of1', 0, 0, 0),
(71, 26, 29, 'TestSubModule1of2', 0, 0, 0),
(72, 26, 30, 'TestSubModule2of2', 0, 0, 0),
(73, 26, 30, 'TestSubModule2of2', 0, 0, 0),
(75, 28, 34, 'mod1 sec1', 0, 0, 0),
(76, 28, 34, 'mod1 sec2', 0, 0, 0),
(77, 28, 35, 'mod2 sec1', 0, 0, 0),
(78, 28, 35, 'mod1 sec3', 0, 0, 0);
Any help wil be appreciated
thanks in advance
Suk
