How to save data from the top column and line example I have description (row) + date (column) + value (column) = same row column.
<form name="frmitementrada" id="frmitementrada">
<table width="89%" style="font-size:12px;" id="tabela1">
<tr id="1" style="background-color: #4171a1; color:#ffffff; font-weight: bold; font-family:Arial, Helvetica, sans-serif;">
<td width="20%">DIA</td>
<td ><?php $d1 = date('Y-m-d') ;
$data = new DateTime($d1, new DateTimeZone('Europe/Lisbon'));
echo $data->format('l');
?></td>
<td width="9%" style="display: none; text-align: center;">TERÇA</td>
<td style="display: none; text-align: center;">QUARTA</td>
<td style="display: none; text-align: center;">QUINTA</td>
<td style="display: none; text-align: center;">SEXTA</td>
<td style="display: none; text-align: center;">SABADO</td>
<td style="display: none; text-align: center;">DOMINGO</td>
<td width="10%" style="display: none; text-align: center;">SEGUNDA</td>
<td width="9%" rowspan="2">TOTAL PREIODO</td>
</tr>
<tr id="1" style="background-color: #4171a1; color:#ffffff; font-weight: bold; font-family:Arial, Helvetica, sans-serif;
font-size:12px;">
<td width="20%" >DATA</td>
<td><?php
echo $d1 = date('d-m-Y', strtotime("+5 days")) ;
//$data = new DateTime($d1, new DateTimeZone('Europe/Lisbon'));
//echo $data->format('l');
?>
</td>
<td width="9%" style="display: none; text-align: center;"><?php
echo $d2 = date('d-m-Y', strtotime("+5 days")) ;
//$data = new DateTime($d1, new DateTimeZone('Europe/Lisbon'));
//echo $data->format('l');
?></td>
<td width="8%" style="display: none; text-align: center;"><?php
echo $d3 = date('d-m-Y', strtotime("+5 days")) ;
//$data = new DateTime($d1, new DateTimeZone('Europe/Lisbon'));
//echo $data->format('l');
?></td>
<td width="8%" style="display: none; text-align: center;"><?php
echo $d4 = date('d-m-Y', strtotime("+5 days")) ;
//$data = new DateTime($d1, new DateTimeZone('Europe/Lisbon'));
//echo $data->format('l');
?></td>
<td width="8%" style="display: none; text-align: center;"><?php
echo $d5 = date('d-m-Y', strtotime("+5 days")) ;
//$data = new DateTime($d1, new DateTimeZone('Europe/Lisbon'));
//echo $data->format('l');
?></td>
<td width="8%" style="display: none; text-align: center;"><?php
echo $d6 = date('d-m-Y', strtotime("+5 days")) ;
//$data = new DateTime($d1, new DateTimeZone('Europe/Lisbon'));
//echo $data->format('l');
?></td>
<td width="10%" style="display: none; text-align: center;"><?php
echo $d7 = date('d-m-Y', strtotime("+5 days")) ;
//$data = new DateTime($d1, new DateTimeZone('Europe/Lisbon'));
//echo $data->format('l');
?></td>
<td width="10%" style="display: none; text-align: center;"><?php
echo $d8 = date('d-m-Y', strtotime("+5 days")) ;
//$data = new DateTime($d1, new DateTimeZone('Europe/Lisbon'));
//echo $data->format('l');
?></td>
</tr>
<tr id="2" bgcolor="#dee0e1" >
<td height="31"><label> <input type="text" name="" value="Exemplo almoço" id="descricao1" class="txt"/>
</label></td>
<!-- Linha A-->
<td ><INPUT id="a1" class="txt" TYPE="text" SIZE="3" NAME="a1" onkeyup="multiplicala(), multiplicatotal()" value="0">
</td>
<td style="display: none;"><INPUT id="a2" class="txt" TYPE="text" onkeyup="multiplicala(), multiplicatotal()" SIZE="3" NAME="a2" value="0" ></td>
<td style="display: none;"><INPUT id="a3" class="txt" TYPE="text" onkeyup="multiplicala(), multiplicatotal()" SIZE="3" NAME="a3" value="0" ></td>
<td style="display: none;"><INPUT id="a4" class="txt" TYPE="text" onkeyup="multiplicala(), multiplicatotal()" SIZE="3" NAME="a4" value="0" ></td>
<td width="8%" style="display: none;"><INPUT id="a5" class="txt" TYPE="text" onkeyup="multiplicala(), multiplicatotal()" SIZE="3" NAME="a5" value="0" ></td>
<td width="8%" style="display: none;"><INPUT id="a6" class="txt" TYPE="text" onkeyup="multiplicala(), multiplicatotal()" SIZE="3" NAME="a6" value="0" ></td>
<td width="10%" style="display: none;"><INPUT id="a7" class="txt" TYPE="text" onkeyup="multiplicala(), multiplicatotal()" SIZE="3" NAME="a7" value="0" ></td>
<td width="10%" style="display: none;"><INPUT id="a8" class="txt" TYPE="text" onkeyup="multiplicala(), multiplicatotal()" SIZE="3" NAME="a8" value="0" ></td>
<!-- PArte aparece o calculo da linha la-->
<td align="right" ><span> R$</span><INPUT TYPE="text" SIZE="3" NAME="total_la" value="0" disabled></td>
</tr>
<tr id="3" style="display: none;" >
<!-- Linha B-->
<td><label> <input type="text" name="" value="Descrição" id="" class="txt"/>
</label></td>
<td><INPUT id="b1" class="txt" TYPE="text" SIZE="3" NAME="b1" onkeyup="multiplicalb(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="b2" class="txt" TYPE="text" SIZE="3" NAME="b2" onkeyup="multiplicalb(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="b3" class="txt" TYPE="text" SIZE="3" NAME="b3" onkeyup="multiplicalb(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="b4" class="txt" TYPE="text" SIZE="3" NAME="b4" onkeyup="multiplicalb(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="b5" class="txt" TYPE="text" SIZE="3" NAME="b5" onkeyup="multiplicalb(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="b6" class="txt" TYPE="text" SIZE="3" NAME="b6" onkeyup="multiplicalb(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="b7" class="txt" TYPE="text" SIZE="3" NAME="b7" onkeyup="multiplicalb(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="b8" class="txt" TYPE="text" SIZE="3" NAME="b8" onkeyup="multiplicalb(), multiplicatotal()" value="0"></td>
<td align="right" ><span> R$</span><INPUT TYPE="text" SIZE="3" NAME="total_lb" value="0" disabled></td>
</tr>
<tr id="4" bgcolor="#dee0e1" style="display: none;" >
<!-- Linha C-->
<td><label> <input type="text" name="" value="Descrição" id="" class="txt"/>
</label></td>
<td><INPUT id="c1" class="txt" TYPE="text" SIZE="3" NAME="c1" onkeyup="multiplicalc(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="c2" class="txt" TYPE="text" SIZE="3" NAME="c2" onkeyup="multiplicalc(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="c3" class="txt" TYPE="text" SIZE="3" NAME="c3" onkeyup="multiplicalc(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="c4" class="txt" TYPE="text" SIZE="3" NAME="c4" onkeyup="multiplicalc(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="c5" class="txt" TYPE="text" SIZE="3" NAME="c5" onkeyup="multiplicalc(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="c6" class="txt" TYPE="text" SIZE="3" NAME="c6" onkeyup="multiplicalc() , multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="c7" class="txt" TYPE="text" SIZE="3" NAME="c7" onkeyup="multiplicalc() , multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="c8" class="txt" TYPE="text" SIZE="3" NAME="c8" onkeyup="multiplicalc(), multiplicatotal()" value="0"></td>
<td align="right" ><span> R$</span><INPUT TYPE="text" SIZE="3" NAME="total_lc" value="0" disabled></td>
</tr>
<tr id="5" style="display: none;" >
<!-- Linha D-->
<td><label> <input type="text" name="" value="Descrição" id="" class="txt"/>
</label></td>
<td><INPUT id="d1" class="txt" TYPE="text" SIZE="3" NAME="d1" onkeyup="multiplicald(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="d2" class="txt" TYPE="text" SIZE="3" NAME="d2" onkeyup="multiplicald(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="d3" class="txt" TYPE="text" SIZE="3" NAME="d3" onkeyup="multiplicald(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="d4" class="txt" TYPE="text" SIZE="3" NAME="d4" onkeyup="multiplicald(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="d5" class="txt" TYPE="text" SIZE="3" NAME="d5" onkeyup="multiplicald(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="d6" class="txt" TYPE="text" SIZE="3" NAME="d6" onkeyup="multiplicald(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="d7" class="txt" TYPE="text" SIZE="3" NAME="d7" onkeyup="multiplicald(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="d8" class="txt" TYPE="text" SIZE="3" NAME="d8" onkeyup="multiplicald(), multiplicatotal()" value="0"></td>
<td align="right" ><span> R$</span><INPUT TYPE="text" SIZE="3" NAME="total_ld" value="0" disabled></td>
</tr>
<tr id="6" bgcolor="#dee0e1" style="display: none;" >
<!-- Linha E-->
<td><label> <input type="text" name="" value="Descrição" id="" class="txt"/>
</label></td>
<td><INPUT id="e1" class="txt" TYPE="text" SIZE="3" NAME="e1" onkeyup="multiplicale(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="e2" class="txt" TYPE="text" SIZE="3" NAME="e2" onkeyup="multiplicale(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="e3" class="txt" TYPE="text" SIZE="3" NAME="e3" onkeyup="multiplicale(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="e4" class="txt" TYPE="text" SIZE="3" NAME="e4" onkeyup="multiplicale(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="e5" class="txt" TYPE="text" SIZE="3" NAME="e5" onkeyup="multiplicale(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="e6" class="txt" TYPE="text" SIZE="3" NAME="e6" onkeyup="multiplicale(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="e7" class="txt" TYPE="text" SIZE="3" NAME="e7" onkeyup="multiplicale(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="e8" class="txt" TYPE="text" SIZE="3" NAME="e8" onkeyup="multiplicale(), multiplicatotal()" value="0"></td>
<td align="right" ><span> R$</span><INPUT TYPE="text" SIZE="3" NAME="total_le" value="0" disabled></td>
</tr>
<tr id="7" style="display: none;" >
<!-- Linha F-->
<td><label> <input type="text" name="" value="Descrição" id="" class="txt"/>
</label></td>
<td><INPUT id="f1" class="txt" TYPE="text" SIZE="3" NAME="f1" onkeyup="multiplicalf(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="f2" class="txt" TYPE="text" SIZE="3" NAME="f2" onkeyup="multiplicalf(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="f3" class="txt" TYPE="text" SIZE="3" NAME="f3" onkeyup="multiplicalf(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="f4" class="txt" TYPE="text" SIZE="3" NAME="f4" onkeyup="multiplicalf(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="f5" class="txt" TYPE="text" SIZE="3" NAME="f5" onkeyup="multiplicalf(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="f6" class="txt" TYPE="text" SIZE="3" NAME="f6" onkeyup="multiplicalf(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="f7" class="txt" TYPE="text" SIZE="3" NAME="f7" onkeyup="multiplicalf(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="f8" class="txt" TYPE="text" SIZE="3" NAME="f8" onkeyup="multiplicalf(), multiplicatotal()" value="0"></td>
<td align="right" ><span> R$</span><INPUT TYPE="text" SIZE="3" NAME="total_lf" value="0" disabled></td>
</tr>
<tr id="8" bgcolor="#dee0e1" style="display: none;" >
<!-- Linha G-->
<td><label> <input type="text" name="" value="Descrição" id="" class="txt"/>
</label></td>
<td><INPUT id="g1" class="txt" TYPE="text" SIZE="3" NAME="g1" onkeyup="multiplicalg(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="g2" class="txt" TYPE="text" SIZE="3" NAME="g2" onkeyup="multiplicalg(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="g3" class="txt" TYPE="text" SIZE="3" NAME="g3" onkeyup="multiplicalg(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="g4" class="txt" TYPE="text" SIZE="3" NAME="g4" onkeyup="multiplicalg(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="g5" class="txt" TYPE="text" SIZE="3" NAME="g5" onkeyup="multiplicalg(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="g6" class="txt" TYPE="text" SIZE="3" NAME="g6" onkeyup="multiplicalg(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="g7" class="txt" TYPE="text" SIZE="3" NAME="g7" onkeyup="multiplicalg(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="g8" class="txt" TYPE="text" SIZE="3" NAME="g8" onkeyup="multiplicalg(), multiplicatotal()" value="0"></td>
<td align="right"><span> R$</span><INPUT TYPE="text" SIZE="3" NAME="total_lg" value="0" disabled></td>
</tr>
<tr id="9" style="display: none;" >
<!-- Linha H-->
<td ><label> <input type="text" name="" value="Descrição" id="" class="txt"/>
</label></td>
<td ><INPUT id="h1" class="txt" TYPE="text" SIZE="3" NAME="h1" onkeyup="multiplicalh(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="h2" class="txt" TYPE="text" SIZE="3" NAME="h2" onkeyup="multiplicalh(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="h3" class="txt" TYPE="text" SIZE="3" NAME="h3" onkeyup="multiplicalh(), multiplicatotal()" value="0"></td>
<td style="display: none;"><INPUT id="h4" class="txt" TYPE="text" SIZE="3" NAME="h4" onkeyup="multiplicalh(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="h5" class="txt" TYPE="text" SIZE="3" NAME="h5" onkeyup="multiplicalh(), multiplicatotal()" value="0"></td>
<td width="8%" style="display: none;"><INPUT id="h6" class="txt" TYPE="text" SIZE="3" NAME="h6" onkeyup="multiplicalh(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="h7" class="txt" TYPE="text" SIZE="3" NAME="h7" onkeyup="multiplicalh(), multiplicatotal()" value="0"></td>
<td width="10%" style="display: none;"><INPUT id="h8" class="txt" TYPE="text" SIZE="3" NAME="h8" onkeyup="multiplicalh(), multiplicatotal()" value="0"></td>
<td align="right" ><span> R$</span><INPUT TYPE="text" SIZE="3" NAME="total_lh" value="0" disabled></td>
</tr>
</table>
<tr>
<table width="89%" >
<td width="685" class="sub"><input type="button" class="btnrel" onClick="decrementarlinha()" value="Diminuir Linha">
<input type="button" class="btnrel" onClick="incrementarlinha()" value="Aumentar Linha">
<input type="button" class="btnrel" onClick="decrementarcoluna()" value="Diminuir Coluna">
<input type="button" class="btnrel" onClick="incrementarcoluna()" value="Aumentar Coluna"></td>
<td width="61" class="sub">TOTAL:</td>
<td width="72" bgcolor="#dee0e1" align="right" class="sub"><span> R$</span><INPUT TYPE="text" SIZE="3" NAME="total" value="0" disabled></td>
</tr>
</table>
<input type="submit" value="Cadastrar" class="btn" >
</form>
<p> </p>
<?php
if(@$_GET['go'] == 'cadastrar2'){
//primeira linha
$valorLinhaA1 = $_POST['a1'];//dados coluna a1 linha1
$datacol1 = $d1; //dados data da coluna 1
$descricao1 = $_POST['descricao1']; // dados descrição da prmeira linha
//segunda linha
$valorLinhaB1 = $_POST['b1'];//dados coluna b1 linha1
$datacol1 = $d1; //dados data da coluna 1
$descricao2 = $_POST['descricao2']; // dados descrição da prmeira linha
mysql_query(" insert into adiantamentorelatorio (descrição, data, valor)
values ('$valorLinhaA1', $datacol1 ,'$descricao2');
");
echo "<script>alert('Viagem cadastrado com sucesso.');</script>";
}
?>