Add content from a mysql table to an html table(only the first three column)

thomas_dev · April 3, 2013

Hello friends,I've a code which I've added below and i want the contents of the first three columns(Sl no,Usn,Name) to be inserted from a mysql database,and the remaining colums have text fields where the end user will enter the information which should be stored in some other mysql table.I was successfull in inserting from mysql to html table but i had troubles dealing with other colums ..I had to create multiple tables and join them which resulted in two tables of different height and the overall look and feel was not good..even had trouble dealing with css and javascript support .So i just want to know if is there a way to insert data from my database to the first three columns without effecting the other colums and also by retaining the js nd css support.I've also attached a small screenshot of how the table looks.(Sorry for poor english )

my code:-

<!-- Row Highlight Javascript -->
<script type="text/javascript">
	window.onload=function(){
	var tfrow = document.getElementById('tfhover').rows.length;
	var tbRow=[];
	for (var i=1;i<tfrow;i++) {
		tbRow[i]=document.getElementById('tfhover').rows[i];
		tbRow[i].onmouseover = function(){
		  this.style.backgroundColor = '#f3f8aa';
		};
		tbRow[i].onmouseout = function() {
		  this.style.backgroundColor = '#ffffff';
		};
	}
};
</script>

<style type="text/css">
table.tftable {font-size:12px;color:#333333;width:100%;border-width: 1px;border-color: #a9a9a9;border-collapse: collapse;}
table.tftable th {font-size:12px;background-color:#b8b8b8;border-width: 1px;padding: 8px;border-style: solid;border-color: #a9a9a9;text-align:center;}
table.tftable tr {background-color:#ffffff;}
table.tftable td {font-size:12px;border-width: 1px;padding: 8px;border-style: solid;border-color: #a9a9a9;}
table.input {text-align:center;}
</style>

<table id="tfhover" class="tftable" border="1">
<tr>
<th rowspan = "2"> Sl No</th>
<th rowspan = "2"> USN</th>
<th rowspan = "2"> Name</th>
<th colspan = "1">  Subj Code </th>
<th colspan = "1">  Subj Code </th>
<th colspan = "1">  Subj Code </th>
<th colspan = "1">  Subj Code </th>
<th colspan = "1">  Subj Code </th>
<th colspan = "1">  Subj Code </th>
<th colspan = "1">  Subj Code </th>
<th colspan = "1">  Subj Code </th>
</tr>
<tr align = "center">
<th> IA Marks </th>
<th> IA Marks </th>
<th> IA Marks </th>
<th> IA Marks </th>
<th> IA Marks </th>
<th> IA Marks </th>
<th> IA Marks </th>
<th> IA Marks </th>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "s1i" size = "2" /> </td>
<td> <input type = "number" name = "s1e" size = "2" /> </td>
<td> <input type = "number" name = "s2i" size = "2" /> </td>
<td> <input type = "number" name = "s2e" size = "2" /> </td>
<td> <input type = "number" name = "s3i" size = "2" /> </td>
<td> <input type = "number" name = "s3e" size = "2" /> </td>
<td> <input type = "number" name = "s4i" size = "2" /> </td>
<td> <input type = "number" name = "s4e" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>
<tr>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> I'm not editable </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
<td> <input type = "number" name = "ia1" size = "2" /> </td>
</tr>

my database table :-

+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(3)      | NO   | PRI | NULL    | auto_increment |
| usn   | varchar(15) | YES  |     | NULL    |                |
| name  | char(50)    | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+

thomas_dev · April 4, 2013

Added the first three columns from the database..Is there any possible ways to store the remaing data which the user enters.Here is the code so far..

<?php
$con = mysql_connect("localhost","tom","");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
//select Database

mysql_select_db("sms", $con);

$result = mysql_query("SELECT * FROM dept_info", $con) or die(mysql_error());

echo "<table border='1'>";
echo '<tr> <th>Sl No</th> <th>USN</th> <th>Name</th><th>code1</th><th>code 2</th> <th>code 3</th> <th>code 4</th> <th>code 5</th> 
                <th>code 6</th> <th>code 7</th> <th>code 8</th></tr>';

while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>";
    echo $row['id'];
    echo "</td><td>";
    echo $row['usn'];
    echo "</td><td>";
    echo $row['name'];
   // echo "</td></tr>";
    echo '<td> <input type = "number" name = "s1i" size = "2" /> </td>';
    echo '<td> <input type = "number" name = "s1i" size = "2" /> </td>';
    echo '<td> <input type = "number" name = "s1i" size = "2" /> </td>';
    echo '<td> <input type = "number" name = "s1i" size = "2" /> </td>';
    echo '<td> <input type = "number" name = "s1i" size = "2" /> </td>';
    echo '<td> <input type = "number" name = "s1i" size = "2" /> </td>';
    echo '<td> <input type = "number" name = "s1i" size = "2" /> </td>';
    echo '<td> <input type = "number" name = "s1i" size = "2" /> </td></tr>';
}
?>

attached a screeshot below for a clear picture..

Edited April 4, 2013 by thomas_dev

Barand · April 4, 2013

You cannot process the data when all the fields have the same name.

while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>";
    echo $row['id'];
    echo "</td><td>";
    echo $row['usn'];
    echo "</td><td>";
    echo $row['name'];
    echo "</td>";
    for ($i=1; $i <= 8; $i++) {
        echo "<td> <input type='text' name='sl[{$row['id']}][$i]' size='2' /> </td>" ;
    }
    echo '</tr>';
}

Edited April 4, 2013 by Barand

thomas_dev · April 4, 2013

You cannot process the data when all the fields have the same name.

while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>";
    echo $row['id'];
    echo "</td><td>";
    echo $row['usn'];
    echo "</td><td>";
    echo $row['name'];
    echo "</td>";
    for ($i=1; $i <= 8; $i++) {
        echo "<td> <input type='text' name='sl[{$row['id']}][$i]' size='2' /> </td>" ;
    }
    echo '</tr>';
}

Hello sir,First of all thank you for spending your valuable time to help me.Th code is working fine..in the

name='sl[{$row['id']}][$i]'

part can i change the $row[ 'id' ] to $row[ 'usn' ]..???and now am i able to store all the values in the fields to a table inside my database?

Barand · April 4, 2013

... can i change the $row[ 'id' ] to $row[ 'usn' ]..???and now am i able to store all the values in the fields to a table inside my database?

only if usn column is unique for each row

Edited April 4, 2013 by Barand

thomas_dev · April 4, 2013

only if usn column is unique for each row

Yes usn is unique for each student..Can u direct me to a good tutorial where i can read about storing the entered values(values from code 1 - code 8\)by the user to a database??

Edited April 4, 2013 by thomas_dev

Barand · April 4, 2013

You would write a separate record to the table for each code field that has a value. Each record would contain the usn and a code value.

thomas_dev · April 6, 2013

can you give me a small clue as to how I can insert the input data to mysql db??..just a clue..the inserting part..pls.

Barand · April 6, 2013

Your POST array will contain something like this

Array
(
    [s1] => Array
        (
            [usn1] => Array
                (
                    [1] => 1
                    [2] => 21
                    [3] => 25
                    [4] => 
                    [5] => 
                    [6] => 
                    [7] => 
                    [8] => 
                )

            [usn2] => Array
                (
                    [1] => 21
                    [2] => 22
                    [3] => 25
                    [4] => 37
                    [5] => 
                    [6] => 
                    [7] => 
                    [8] => 
                )

        )

)

So you want to end up with a query that looks like this

INSERT INTO mytable (usn, slcode) VALUES
('usn1', 01),
('usn1', 21),
('usn1', 25),
('usn2', 21),
('usn2', 22),
('usn2', 25),
('usn2', 37)

thomas_dev · April 6, 2013

thank you sir..I'll try that and get back to you..

thomas_dev · April 6, 2013

sir in your insert statement you're telling me to insert each value by myself or did I mistook your code?? I want those input values to be automatically inserted to the dbase upon clicking submit by the end user.. I've added a submit button and linked it to another php code.. only problem is that it is not storing the data properly.. where am I missing.Thanks for your patience so far.

Barand · April 6, 2013

sir in your insert statement you're telling me to insert each value by myself or did I mistook your code??

What I gave you was an example of the type of query you need.You will need to write the code to construct such a query from the array data and execute it when the form is posted.

Like this

$insertData = array();
foreach ($_POST['sl'] as $usn => $codes) {
    foreach ($codes as $sl) {
        $insertData[] = sprintf("('%s', %d)", mysqli_real_escape_string($usn), intval($sl));
    }
}
$query = "INSERT INTO mytable (usn, slcode) VALUES\n" . join(",\n", $insertData);

Edited April 6, 2013 by Barand

thomas_dev · April 10, 2013

What I gave you was an example of the type of query you need.You will need to write the code to construct such a query from the array data and execute it when the form is posted.

Like this
$insertData = array();
foreach ($_POST['sl'] as $usn => $codes) {
    foreach ($codes as $sl) {
        $insertData[] = sprintf("('%s', %d)", mysqli_real_escape_string($usn), intval($sl));
    }
}
$query = "INSERT INTO mytable (usn, slcode) VALUES\n" . join(",\n", $insertData);

Sir, sorry for my lack of knowledge in php..I think I totally messed up everything..I'm unable to store the values to dbase..my three codes and screenshots are as shown below.I'm new to php sir.But at this point I desperately need your help.

//workingcode.php
<?php
$con = mysql_connect("localhost","tom","");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
//select Database

mysql_select_db("sms", $con);

$result = mysql_query("SELECT * FROM dept_info", $con) or die(mysql_error());

echo "<table border='1'>";
echo '<tr> <th>Sl No</th> <th>USN</th> <th>Name</th><th>code1</th><th>code 2</th> <th>code 3</th> <th>code 4</th> <th>code 5</th> 
                <th>code 6</th> <th>code 7</th> <th>code 8</th></tr>';

while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>";
    echo $row['id'];
    echo "</td><td>";
    echo $row['usn'];
    echo "</td><td>";
    echo $row['name'];
    echo "</td>";
    for ($i=1; $i <= 8; $i++) {
        echo "<td> <input type='text' name='sl[{$row['usn']}][$i]' size='2' /> </td>" ;
    }
    echo '</tr>';
}

echo '
<form action = "insert.php" method = "post">
<div align="bottom">
<input type = "submit" align = "BOTTOM" value = "Proceed">
</div>
</form>
';
?>

I've linked this to an insert.php file as shown below..

<html>
<head>
<title>Marks Entry Results</title>
</head>
<body>
<h1>Student Marks Entry Results</h1>

<?php


        $insertData = array();
foreach ($_POST['sl'] as $usn => $codes) {
    foreach ($codes as $sl) {
        $insertData[] = sprintf("('%s', %d)", mysqli_real_escape_string($usn), intval($sl));
    }
}
@ $db = new mysqli('localhost', 'tom', '', 'sms');
if (mysqli_connect_errno()) {
echo 'Error: Could not connect to database.';
exit;
}

$query = "INSERT INTO mytable (usn, code1) VALUES\n" . join(",\n", $insertData);
$result = $db->query($query);
if ($result) {
echo $db->affected_rows." Marks inserted into database.";
} else {
echo "An error has occurred. Not added.";
}
$db->close();
?>
</body>
</html>
//The description of the table which i made for this is
/*mysql> desc mytable;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| usn   | varchar(50) | NO   | PRI | NULL    |       |
| code1 | int(2)      | YES  |     | NULL    |       |
| code2 | int(2)      | YES  |     | NULL    |       |
| code3 | int(2)      | YES  |     | NULL    |       |
| code4 | int(2)      | YES  |     | NULL    |       |
| code5 | int(2)      | YES  |     | NULL    |       |
| code6 | int(2)      | YES  |     | NULL    |       |
| code7 | int(2)      | YES  |     | NULL    |       |
| code8 | int(2)      | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
*/

am i anywhere near..or did I completely lost it?? :suicide: :cry:

Edited April 10, 2013 by thomas_dev

thomas_dev · April 10, 2013

I've used mysql in first and mysqli in second..I'll change that..will this code be okay..

<html>
<head>
<title>Marks Entry Results</title>
</head>
<body>
<h1>Student Marks Entry Results</h1>

<?php


        $insertData = array();
foreach ($_POST['sl'] as $usn => $codes) {
    foreach ($codes as $sl) {
        $insertData[] = sprintf("('%s', %d)", mysqli_real_escape_string($usn), intval($sl));
    }
}
$con = mysql_connect("localhost","tom","");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
//select Database

mysql_select_db("sms", $con);

$query = mysql_query("INSERT INTO mytable (usn, code1) VALUES\n" . join(",\n", $insertData));
$result = $db->query($query);
if ($result) {
echo $db->affected_rows." Marks inserted into database.";
} else {
echo "An error has occurred. Not added.";
}
$db->close();
?>
</body>
</html>

and a minor change to workingcode.php

<?php
$con = mysql_connect("localhost","tom","");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
//select Database

mysql_select_db("sms", $con);

$result = mysql_query("SELECT * FROM dept_info", $con) or die(mysql_error());

echo "<table border='1'>";
echo '<tr> <th>Sl No</th> <th>USN</th> <th>Name</th><th>code1</th><th>code 2</th> <th>code 3</th> <th>code 4</th> <th>code 5</th> 
                <th>code 6</th> <th>code 7</th> <th>code 8</th></tr>';

echo '<form action = "insert.php" method = "post">';
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>";
    echo $row['id'];
    echo "</td><td>";
    echo $row['usn'];
    echo "</td><td>";
    echo $row['name'];
    echo "</td>";
    for ($i=1; $i <= 8; $i++) {
        echo "<td> <input type='text' name='sl[{$row['usn']}][$i]' size='2' /> </td>" ;
    }
    echo '</tr>';
}

echo '
<div align="bottom">
<input type = "submit" align = "BOTTOM" value = "Proceed">
</div>
</form>
';
?>

Edited April 10, 2013 by thomas_dev

thomas_dev · April 10, 2013

again updating my inert.php code..Sorry for spamming..I'm not able to edit it..thats why.

 <html>
<head>
<title>Marks Entry Results</title>
</head>
<body>
<h1>Student Marks Entry Results</h1>

    <?php


        $insertData = array();
foreach ($_POST['sl'] as $usn => $codes) {
    foreach ($codes as $sl) {
        $insertData[] = sprintf("('%s', %d)", mysqli_real_escape_string($usn), intval($sl));
    }
}
$con = mysql_connect("localhost","tom","");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
//select Database

mysql_select_db("sms", $con);

$query = mysql_query("INSERT INTO mytable (usn, code1) VALUES\n" . join(",\n", $insertData));
$result = mysql_query($query);
if ($result) {
echo mysql_affected_rows()." Marks inserted into database.";
} else {
echo "An error has occurred. Not added.";
}
mysql_close();
?>
</body>
</html>
//The description of the table which i made for this is
/*mysql> desc mytable;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| usn   | varchar(50) | NO   | PRI | NULL    |       |
| code1 | int(2)      | YES  |     | NULL    |       |
| code2 | int(2)      | YES  |     | NULL    |       |
| code3 | int(2)      | YES  |     | NULL    |       |
| code4 | int(2)      | YES  |     | NULL    |       |
| code5 | int(2)      | YES  |     | NULL    |       |
| code6 | int(2)      | YES  |     | NULL    |       |
| code7 | int(2)      | YES  |     | NULL    |       |
| code8 | int(2)      | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
*/

thomas_dev · April 10, 2013

There have been a good improvement....data is being inserted to the database....but there is something wrong with the query....data is not being added as i expected it to be....the screenshots will explain the rest of the story...updated code is also listed.

<?php
$con = mysql_connect("localhost","tom","");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
//select Database

mysql_select_db("sms", $con);

$result = mysql_query("SELECT * FROM dept_info", $con) or die(mysql_error());

echo "<table border='1'>";
echo '<tr> <th>Sl No</th> <th>USN</th> <th>Name</th><th>code1</th><th>code 2</th> <th>code 3</th> <th>code 4</th> <th>code 5</th> 
                <th>code 6</th> <th>code 7</th> <th>code 8</th></tr>';

echo '<form action = "insert.php" method = "post">';
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>";
    echo $row['id'];
    echo "</td><td>";
    echo $row['usn'];
    echo "</td><td>";
    echo $row['name'];
    echo "</td>";
    for ($i=1; $i <= 8; $i++) {
        echo "<td> <input type='text' name='sl[{$row['usn']}][$i]' size='2' /> </td>" ;
    }
    echo '</tr>';
}

echo '
<div align="bottom">
<input type = "submit" align = "BOTTOM" value = "Proceed">
</div>
</form>
';
?>

 <html>
<head>
<title>Marks Entry Results</title>
</head>
<body>
<h1>Student Marks Entry Results</h1>

    <?php


        $insertData = array();
foreach ($_POST['sl'] as $usn => $codes) {
    foreach ($codes as $sl) {
        $insertData[] = sprintf("('%s', %d)", mysqli_real_escape_string($usn), intval($sl));
    }
}
$con = mysql_connect("localhost","tom","");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
//select Database

mysql_select_db("sms", $con);

$query = "INSERT INTO dept_info (usn, code1) VALUES\n" . join(",\n", $insertData);
echo $query;
$result = mysql_query($query);
if ($result) {
echo mysql_affected_rows()." Marks inserted into database.";
} else {
echo "An error has occurred. Not added.";
}
mysql_close();
?>
</body>
</html>

please help with the query so that tha expected results are obtained.Screenshot is split into two...but both are one image.

Barand · April 10, 2013

You are supposed to be writing the codes to a separate table, not to eight columns in the same table (which only had 3 columns according to your earlier post). Each code is written to a separate row along with the usn as a foreign key. (Data normalization !)

the new table would be

CREATE TABLE user_codes (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
usn VARCHAR(12),
slcode INT
)

(table name is up to you, of course

Edited April 10, 2013 by Barand

thomas_dev · April 10, 2013

I totally respect the concept of data normalization.. Since I'm very less experienced with this I want to avoid the complexity of using different tables. Isn't there a way that I can add the data to an existing table only?.. In my project I've an idea of fetching everything from a single table.. Does that sound like a bad idea?.. Will surely accept the suggestions offered here.

thomas_dev · April 10, 2013

created a new table. But i''m unable to get the intended result ..the situation is like this ....each student consist of his own unique USN number say 4gh08cs052(a sample)....when an admin logs in he is presented with the table that I've shown in the screenshots,where he can input all the marks of a particular student in respective subjects which is represented as columns from code1 - code8 where each code represent a subject.As soon as the admin clicks the submit button the appropriate entered value should be stored in the database which has the same structure as the frontend table.i.e guess a student has scored 15,20,13,25,24,22,21 marks in his subjects..it should be entered in the html table and stored in the dbase as usn=4gh08cs052, code1=15, code2=20,code3=13,code4=25,code5=24,code6=24,code7=22,code8=21..hope you got an idea.(my english is pathetic..hope you'll somehow understand it). IN SHORT, I WANT TO STORE THE MARKS OF ALL THE STUDENTS IN THE DATABASE GIVING EACH STUDENT A ROW TO ACCOMODATE HIS DATA.

:psychic:

thomas_dev · April 10, 2013

here is the o/p with the new table,which is not how i wanted it to be.

mysql> select * from users_code;
+-----+------+--------+
| id | usn | slcode |
+-----+------+--------+
|   1 |      |     12 |
|   2 |      |     13 |
|   3 |      |     15 |
|   4 |      |     17 |
|   5 |      |     21 |
|   6 |      |     23 |
|   7 |      |     24 |
|   8 |      |     25 |
|   9 |      |      0 |
| 10 |      |      0 |
| 11 |      |      0 |
| 12 |      |      0 |
| 13 |      |      0 |
| 14 |      |      0 |
continues....

when an echo $query was done it showed..

Student Marks Entry Results
INSERT INTO users_code (usn, slcode) VALUES ('', 12), ('', 13), ('', 15), ('', 17), ('', 21), ('', 23), ('', 24), ('', 25), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0), ('', 0)120 Marks inserted into database.

Barand · April 10, 2013

Sounds like a terrible idea to use a relational database just to store a spreadsheet, so glad you are serious considering normalizing the data. You will need a small change

RELATIONSHIPS
+-----------+         +------------+         +-----------+
| student   |         |  result    |         | subject   |
+-----------|         +------------+         +-----------+
|  id       |         |  id        |   +---- |  id       |
|  usn      | -------<|  usn       |   |     |  subjname |
|  name     |         |  subjID    |>--+     +-----------+
+-----------+         |  score     |
                      +------------+

As the 1 - 8 is significant it looks as though we need to another column to that table to store the subject id (1 - and make names a bit more meaningful, and add a date column to so you can use it next time too

CREATE TABLE user_results (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
usn VARCHAR(12),
subjID INT,
score INT,
date DATE
)

For some reason you are not picking up the posted USN key. I'll look at you code and come back with a revised version

Barand · April 10, 2013

try

// need connection to use real_escape_string
// NOTE I used mysqli but you are using mysql
$con = mysql_connect("localhost","tom","");
if (!$con) {
    die('Could not connect: ' . mysql_error());
}
//select Database
mysql_select_db("sms", $con);
$insertData = array();
foreach ($_POST['sl'] as $usn => $codes) {
    foreach ($codes as as $subj=>$sl) {
        $insertData[] = sprintf("('%s', %d, %d, CURDATE())", 
            mysql_real_escape_string($usn), intval($subj), intval($sl));
    }
}

$query = "INSERT INTO user_results (usn, subjID, score, date) VALUES\n" . join(",\n", $insertData);
echo $query;

thomas_dev · April 10, 2013

actually I had different plans to implement....but I'm struggling at the initial steps itself.

below I'll show my databse structure..but don't scold me for it's structure ..or for adding everything in a single table..I had in my mind to play with making USN as primary key since it is unique.in 4gh08cs052 4 has a meaning (i don't know,i shall tell later),gh stands for college code ,08 for 2008 batch students and cs for computer science 052 the roll number of the student.With this in mind i created a database which holds almost everythind and using which one can access all data..first I wanted to play small so that i get to know how I can play with the bigger table.my table structure was like this

mysql> desc marks_info;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| id          | int(11)     | NO   | PRI | NULL    | auto_increment |
| usn         | varchar(30) | YES  |     | NULL    |                |
| name        | text        | YES  |     | NULL    |                |
| branch_name | text        | YES  |     | NULL    |                |
| current_sem | varchar(20) | YES  |     | NULL    |                |
| s1s1code    | char(10)    | YES  |     | NULL    |                |
| s1s1ia      | int(2)      | YES  |     | NULL    |                |
| s1s1ex      | int(3)      | YES  |     | NULL    |                |
| s1s1tot     | int(3)      | YES  |     | NULL    |                |
| s1s1res     | text        | YES  |     | NULL    |                |
| s1s2code    | char(10)    | YES  |     | NULL    |                |
| s1s2ia      | int(2)      | YES  |     | NULL    |                |
| s1s2ex      | int(3)      | YES  |     | NULL    |                |
| s1s2tot     | int(3)      | YES  |     | NULL    |                |
| s1s2res     | text        | YES  |     | NULL    |                |
| s1s3code    | char(10)    | YES  |     | NULL    |                |
| s1s3ia      | int(2)      | YES  |     | NULL    |                |
| s1s3ex      | int(3)      | YES  |     | NULL    |                |
| s1s3tot     | int(3)      | YES  |     | NULL    |                |
| s1s3res     | text        | YES  |     | NULL    |                |
| s1s4code    | char(10)    | YES  |     | NULL    |                |
| s1s4ia      | int(2)      | YES  |     | NULL    |                |
| s1s4ex      | int(3)      | YES  |     | NULL    |                |
| s1s4tot     | int(3)      | YES  |     | NULL    |                |
| s1s4res     | text        | YES  |     | NULL    |                |
| s1s5code    | char(10)    | YES  |     | NULL    |                |
| s1s5ia      | int(2)      | YES  |     | NULL    |                |
| s1s5ex      | int(3)      | YES  |     | NULL    |                |
| s1s5tot     | int(3)      | YES  |     | NULL    |                |
| s1s5res     | text        | YES  |     | NULL    |                |
| s1s6code    | char(10)    | YES  |     | NULL    |                |
| s1s6ia      | int(2)      | YES  |     | NULL    |                |
| s1s6ex      | int(3)      | YES  |     | NULL    |                |
| s1s6tot     | int(3)      | YES  |     | NULL    |                |
| s1s6res     | text        | YES  |     | NULL    |                |
| s1s7code    | char(10)    | YES  |     | NULL    |                |
| s1s7ia      | int(2)      | YES  |     | NULL    |                |
| s1s7ex      | int(3)      | YES  |     | NULL    |                |
| s1s7tot     | int(3)      | YES  |     | NULL    |                |
| s1s7res     | text        | YES  |     | NULL    |                |
| s1s8code    | char(10)    | YES  |     | NULL    |                |
| s1s8ia      | int(2)      | YES  |     | NULL    |                |
| s1s8ex      | int(3)      | YES  |     | NULL    |                |
| s1s8tot     | int(3)      | YES  |     | NULL    |                |
| s1s8res     | text        | YES  |     | NULL    |                |
| s2s1code    | char(10)    | YES  |     | NULL    |                |
| s2s1ia      | int(2)      | YES  |     | NULL    |                |
| s2s1ex      | int(3)      | YES  |     | NULL    |                |
| s2s1tot     | int(3)      | YES  |     | NULL    |                |
| s2s1res     | text        | YES  |     | NULL    |                |
| s2s2code    | char(10)    | YES  |     | NULL    |                |
| s2s2ia      | int(2)      | YES  |     | NULL    |                |
| s2s2ex      | int(3)      | YES  |     | NULL    |                |
| s2s2tot     | int(3)      | YES  |     | NULL    |                |
| s2s2res     | text        | YES  |     | NULL    |                |
| s2s3code    | char(10)    | YES  |     | NULL    |                |
| s2s3ia      | int(2)      | YES  |     | NULL    |                |
| s2s3ex      | int(3)      | YES  |     | NULL    |                |
| s2s3tot     | int(3)      | YES  |     | NULL    |                |
| s2s3res     | text        | YES  |     | NULL    |                |
| s2s4code    | char(10)    | YES  |     | NULL    |                |
| s2s4ia      | int(2)      | YES  |     | NULL    |                |
| s2s4ex      | int(3)      | YES  |     | NULL    |                |
| s2s4tot     | int(3)      | YES  |     | NULL    |                |
| s2s4res     | text        | YES  |     | NULL    |                |
| s2s5code    | char(10)    | YES  |     | NULL    |                |
| s2s5ia      | int(2)      | YES  |     | NULL    |                |
| s2s5ex      | int(3)      | YES  |     | NULL    |                |
| s2s5tot     | int(3)      | YES  |     | NULL    |                |
| s2s5res     | text        | YES  |     | NULL    |                |
| s2s6code    | char(10)    | YES  |     | NULL    |                |
| s2s6ia      | int(2)      | YES  |     | NULL    |                |
| s2s6ex      | int(3)      | YES  |     | NULL    |                |
| s2s6tot     | int(3)      | YES  |     | NULL    |                |
| s2s6res     | text        | YES  |     | NULL    |                |
| s2s7code    | char(10)    | YES  |     | NULL    |                |
| s2s7ia      | int(2)      | YES  |     | NULL    |                |
| s2s7ex      | int(3)      | YES  |     | NULL    |                |
| s2s7tot     | int(3)      | YES  |     | NULL    |                |
| s2s7res     | text        | YES  |     | NULL    |                |
| s2s8code    | char(10)    | YES  |     | NULL    |                |
| s2s8ia      | int(2)      | YES  |     | NULL    |                |
| s2s8ex      | int(3)      | YES  |     | NULL    |                |
| s2s8tot     | int(3)      | YES  |     | NULL    |                |
| s2s8res     | text        | YES  |     | NULL    |                |
| s3s1code    | char(10)    | YES  |     | NULL    |                |
| s3s1ia      | int(2)      | YES  |     | NULL    |                |
| s3s1ex      | int(3)      | YES  |     | NULL    |                |
| s3s1tot     | int(3)      | YES  |     | NULL    |                |
| s3s1res     | text        | YES  |     | NULL    |                |
| s3s2code    | char(10)    | YES  |     | NULL    |                |
| s3s2ia      | int(2)      | YES  |     | NULL    |                |
| s3s2ex      | int(3)      | YES  |     | NULL    |                |
| s3s2tot     | int(3)      | YES  |     | NULL    |                |
| s3s2res     | text        | YES  |     | NULL    |                |
| s3s3code    | char(10)    | YES  |     | NULL    |                |
| s3s3ia      | int(2)      | YES  |     | NULL    |                |
| s3s3ex      | int(3)      | YES  |     | NULL    |                |
| s3s3tot     | int(3)      | YES  |     | NULL    |                |
| s3s3res     | text        | YES  |     | NULL    |                |
| s3s4code    | char(10)    | YES  |     | NULL    |                |
| s3s4ia      | int(2)      | YES  |     | NULL    |                |
| s3s4ex      | int(3)      | YES  |     | NULL    |                |
| s3s4tot     | int(3)      | YES  |     | NULL    |                |
| s3s4res     | text        | YES  |     | NULL    |                |
| s3s5code    | char(10)    | YES  |     | NULL    |                |
| s3s5ia      | int(2)      | YES  |     | NULL    |                |
| s3s5ex      | int(3)      | YES  |     | NULL    |                |
| s3s5tot     | int(3)      | YES  |     | NULL    |                |
| s3s5res     | text        | YES  |     | NULL    |                |
| s3s6code    | char(10)    | YES  |     | NULL    |                |
| s3s6ia      | int(2)      | YES  |     | NULL    |                |
| s3s6ex      | int(3)      | YES  |     | NULL    |                |
| s3s6tot     | int(3)      | YES  |     | NULL    |                |
| s3s6res     | text        | YES  |     | NULL    |                |
| s3s7code    | char(10)    | YES  |     | NULL    |                |
| s3s7ia      | int(2)      | YES  |     | NULL    |                |
| s3s7ex      | int(3)      | YES  |     | NULL    |                |
| s3s7tot     | int(3)      | YES  |     | NULL    |                |
| s3s7res     | text        | YES  |     | NULL    |                |
| s3s8code    | char(10)    | YES  |     | NULL    |                |
| s3s8ia      | int(2)      | YES  |     | NULL    |                |
| s3s8ex      | int(3)      | YES  |     | NULL    |                |
| s3s8tot     | int(3)      | YES  |     | NULL    |                |
| s3s8res     | text        | YES  |     | NULL    |                |
| s4s1code    | char(10)    | YES  |     | NULL    |                |
| s4s1ia      | int(2)      | YES  |     | NULL    |                |
| s4s1ex      | int(3)      | YES  |     | NULL    |                |
| s4s1tot     | int(3)      | YES  |     | NULL    |                |
| s4s1res     | text        | YES  |     | NULL    |                |
| s4s2code    | char(10)    | YES  |     | NULL    |                |
| s4s2ia      | int(2)      | YES  |     | NULL    |                |
| s4s2ex      | int(3)      | YES  |     | NULL    |                |
| s4s2tot     | int(3)      | YES  |     | NULL    |                |
| s4s2res     | text        | YES  |     | NULL    |                |
| s4s3code    | char(10)    | YES  |     | NULL    |                |
| s4s3ia      | int(2)      | YES  |     | NULL    |                |
| s4s3ex      | int(3)      | YES  |     | NULL    |                |
| s4s3tot     | int(3)      | YES  |     | NULL    |                |
| s4s3res     | text        | YES  |     | NULL    |                |
| s4s4code    | char(10)    | YES  |     | NULL    |                |
| s4s4ia      | int(2)      | YES  |     | NULL    |                |
| s4s4ex      | int(3)      | YES  |     | NULL    |                |
| s4s4tot     | int(3)      | YES  |     | NULL    |                |
| s4s4res     | text        | YES  |     | NULL    |                |
| s4s5code    | char(10)    | YES  |     | NULL    |                |
| s4s5ia      | int(2)      | YES  |     | NULL    |                |
| s4s5ex      | int(3)      | YES  |     | NULL    |                |
| s4s5tot     | int(3)      | YES  |     | NULL    |                |
| s4s5res     | text        | YES  |     | NULL    |                |
| s4s6code    | char(10)    | YES  |     | NULL    |                |
| s4s6ia      | int(2)      | YES  |     | NULL    |                |
| s4s6ex      | int(3)      | YES  |     | NULL    |                |
| s4s6tot     | int(3)      | YES  |     | NULL    |                |
| s4s6res     | text        | YES  |     | NULL    |                |
| s4s7code    | char(10)    | YES  |     | NULL    |                |
| s4s7ia      | int(2)      | YES  |     | NULL    |                |
| s4s7ex      | int(3)      | YES  |     | NULL    |                |
| s4s7tot     | int(3)      | YES  |     | NULL    |                |
| s4s7res     | text        | YES  |     | NULL    |                |
| s4s8code    | char(10)    | YES  |     | NULL    |                |
| s4s8ia      | int(2)      | YES  |     | NULL    |                |
| s4s8ex      | int(3)      | YES  |     | NULL    |                |
| s4s8tot     | int(3)      | YES  |     | NULL    |                |
| s4s8res     | text        | YES  |     | NULL    |                |
| s5s1code    | char(10)    | YES  |     | NULL    |                |
| s5s1ia      | int(2)      | YES  |     | NULL    |                |
| s5s1ex      | int(3)      | YES  |     | NULL    |                |
| s5s1tot     | int(3)      | YES  |     | NULL    |                |
| s5s1res     | text        | YES  |     | NULL    |                |
| s5s2code    | char(10)    | YES  |     | NULL    |                |
| s5s2ia      | int(2)      | YES  |     | NULL    |                |
| s5s2ex      | int(3)      | YES  |     | NULL    |                |
| s5s2tot     | int(3)      | YES  |     | NULL    |                |
| s5s2res     | text        | YES  |     | NULL    |                |
| s5s3code    | char(10)    | YES  |     | NULL    |                |
| s5s3ia      | int(2)      | YES  |     | NULL    |                |
| s5s3ex      | int(3)      | YES  |     | NULL    |                |
| s5s3tot     | int(3)      | YES  |     | NULL    |                |
| s5s3res     | text        | YES  |     | NULL    |                |
| s5s4code    | char(10)    | YES  |     | NULL    |                |
| s5s4ia      | int(2)      | YES  |     | NULL    |                |
| s5s4ex      | int(3)      | YES  |     | NULL    |                |
| s5s4tot     | int(3)      | YES  |     | NULL    |                |
| s5s4res     | text        | YES  |     | NULL    |                |
| s5s5code    | char(10)    | YES  |     | NULL    |                |
| s5s5ia      | int(2)      | YES  |     | NULL    |                |
| s5s5ex      | int(3)      | YES  |     | NULL    |                |
| s5s5tot     | int(3)      | YES  |     | NULL    |                |
| s5s5res     | text        | YES  |     | NULL    |                |
| s5s6code    | char(10)    | YES  |     | NULL    |                |
| s5s6ia      | int(2)      | YES  |     | NULL    |                |
| s5s6ex      | int(3)      | YES  |     | NULL    |                |
| s5s6tot     | int(3)      | YES  |     | NULL    |                |
| s5s6res     | text        | YES  |     | NULL    |                |
| s5s7code    | char(10)    | YES  |     | NULL    |                |
| s5s7ia      | int(2)      | YES  |     | NULL    |                |
| s5s7ex      | int(3)      | YES  |     | NULL    |                |
| s5s7tot     | int(3)      | YES  |     | NULL    |                |
| s5s7res     | text        | YES  |     | NULL    |                |
| s5s8code    | char(10)    | YES  |     | NULL    |                |
| s5s8ia      | int(2)      | YES  |     | NULL    |                |
| s5s8ex      | int(3)      | YES  |     | NULL    |                |
| s5s8tot     | int(3)      | YES  |     | NULL    |                |
| s5s8res     | text        | YES  |     | NULL    |                |
| s6s1code    | char(10)    | YES  |     | NULL    |                |
| s6s1ia      | int(2)      | YES  |     | NULL    |                |
| s6s1ex      | int(3)      | YES  |     | NULL    |                |
| s6s1tot     | int(3)      | YES  |     | NULL    |                |
| s6s1res     | text        | YES  |     | NULL    |                |
| s6s2code    | char(10)    | YES  |     | NULL    |                |
| s6s2ia      | int(2)      | YES  |     | NULL    |                |
| s6s2ex      | int(3)      | YES  |     | NULL    |                |
| s6s2tot     | int(3)      | YES  |     | NULL    |                |
| s6s2res     | text        | YES  |     | NULL    |                |
| s6s3code    | char(10)    | YES  |     | NULL    |                |
| s6s3ia      | int(2)      | YES  |     | NULL    |                |
| s6s3ex      | int(3)      | YES  |     | NULL    |                |
| s6s3tot     | int(3)      | YES  |     | NULL    |                |
| s6s3res     | text        | YES  |     | NULL    |                |
| s6s4code    | char(10)    | YES  |     | NULL    |                |
| s6s4ia      | int(2)      | YES  |     | NULL    |                |
| s6s4ex      | int(3)      | YES  |     | NULL    |                |
| s6s4tot     | int(3)      | YES  |     | NULL    |                |
| s6s4res     | text        | YES  |     | NULL    |                |
| s6s5code    | char(10)    | YES  |     | NULL    |                |
| s6s5ia      | int(2)      | YES  |     | NULL    |                |
| s6s5ex      | int(3)      | YES  |     | NULL    |                |
| s6s5tot     | int(3)      | YES  |     | NULL    |                |
| s6s5res     | text        | YES  |     | NULL    |                |
| s6s6code    | char(10)    | YES  |     | NULL    |                |
| s6s6ia      | int(2)      | YES  |     | NULL    |                |
| s6s6ex      | int(3)      | YES  |     | NULL    |                |
| s6s6tot     | int(3)      | YES  |     | NULL    |                |
| s6s6res     | text        | YES  |     | NULL    |                |
| s6s7code    | char(10)    | YES  |     | NULL    |                |
| s6s7ia      | int(2)      | YES  |     | NULL    |                |
| s6s7ex      | int(3)      | YES  |     | NULL    |                |
| s6s7tot     | int(3)      | YES  |     | NULL    |                |
| s6s7res     | text        | YES  |     | NULL    |                |
| s6s8code    | char(10)    | YES  |     | NULL    |                |
| s6s8ia      | int(2)      | YES  |     | NULL    |                |
| s6s8ex      | int(3)      | YES  |     | NULL    |                |
| s6s8tot     | int(3)      | YES  |     | NULL    |                |
| s6s8res     | text        | YES  |     | NULL    |                |
| s7s1code    | char(10)    | YES  |     | NULL    |                |
| s7s1ia      | int(2)      | YES  |     | NULL    |                |
| s7s1ex      | int(3)      | YES  |     | NULL    |                |
| s7s1tot     | int(3)      | YES  |     | NULL    |                |
| s7s1res     | text        | YES  |     | NULL    |                |
| s7s2code    | char(10)    | YES  |     | NULL    |                |
| s7s2ia      | int(2)      | YES  |     | NULL    |                |
| s7s2ex      | int(3)      | YES  |     | NULL    |                |
| s7s2tot     | int(3)      | YES  |     | NULL    |                |
| s7s2res     | text        | YES  |     | NULL    |                |
| s7s3code    | char(10)    | YES  |     | NULL    |                |
| s7s3ia      | int(2)      | YES  |     | NULL    |                |
| s7s3ex      | int(3)      | YES  |     | NULL    |                |
| s7s3tot     | int(3)      | YES  |     | NULL    |                |
| s7s3res     | text        | YES  |     | NULL    |                |
| s7s4code    | char(10)    | YES  |     | NULL    |                |
| s7s4ia      | int(2)      | YES  |     | NULL    |                |
| s7s4ex      | int(3)      | YES  |     | NULL    |                |
| s7s4tot     | int(3)      | YES  |     | NULL    |                |
| s7s4res     | text        | YES  |     | NULL    |                |
| s7s5code    | char(10)    | YES  |     | NULL    |                |
| s7s5ia      | int(2)      | YES  |     | NULL    |                |
| s7s5ex      | int(3)      | YES  |     | NULL    |                |
| s7s5tot     | int(3)      | YES  |     | NULL    |                |
| s7s5res     | text        | YES  |     | NULL    |                |
| s7s6code    | char(10)    | YES  |     | NULL    |                |
| s7s6ia      | int(2)      | YES  |     | NULL    |                |
| s7s6ex      | int(3)      | YES  |     | NULL    |                |
| s7s6tot     | int(3)      | YES  |     | NULL    |                |
| s7s6res     | text        | YES  |     | NULL    |                |
| s7s7code    | char(10)    | YES  |     | NULL    |                |
| s7s7ia      | int(2)      | YES  |     | NULL    |                |
| s7s7ex      | int(3)      | YES  |     | NULL    |                |
| s7s7tot     | int(3)      | YES  |     | NULL    |                |
| s7s7res     | text        | YES  |     | NULL    |                |
| s7s8code    | char(10)    | YES  |     | NULL    |                |
| s7s8ia      | int(2)      | YES  |     | NULL    |                |
| s7s8ex      | int(3)      | YES  |     | NULL    |                |
| s7s8tot     | int(3)      | YES  |     | NULL    |                |
| s7s8res     | text        | YES  |     | NULL    |                |
+-------------+-------------+------+-----+---------+----------------+
285 rows in set (0.02 sec)

yes ,you see it correctly ..it has 285 rows in it's structure itself..which can accomodate a students usn ,his branch name,his name,his current sem his sem1 subject 1(s1s1code) code,his sem1 subject1 internal marks(<=25)(s1s1ia),sem1 subject1 external marks(<=100)(s1s1ex),sem1 subject 1 total(s1s1tot) and sem1 subject 1 result(pass or fail)(s1s1res).....similarly till sem8 subject 8 result..I mean what if i use only this single table for everything??what is the role of normalization here??Since the USN has all the information I need ,do you think that this is a terribly bad idea to use a structure like this ??my point is that isn't this structure more simple than having multiple table and dealing with the headaches of normalization ..This I wan't to use to store every marks related information of the student of all branch and all sem.Practically the project become very big and the complexity of the project will also be vast..I'm not actually diverting from the main thread..this is the main idea behind all these circus that I'm doing,and this is why I'm a bit hesitant towards creating multiple tables.Whats wrong with the structure??If this all sounds foolish then my extreme apologies.

Oh yeah rgarding replies...I'll check it n get back to you asap.

Barand · April 10, 2013

You might want to look at this

http://forums.phpfreaks.com/page/tutorials/_/data-joins-unions

thomas_dev · April 10, 2013

You might want to look at this

http://forums.phpfreaks.com/page/tutorials/_/data-joins-unions

leads to an empty page...

Sign In

Add content from a mysql table to an html table(only the first three column)

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information