views:

32

answers:

0

hello, I'm new to programming jquery, I'm trying to make a table from a query in an Oracle database. The code to create the table is something like this:

<form method="get" name="SC" >
<table id="tabla1" width="1129" height="32" id="tabla"   border="3" align="center" bordercolor="#FFFFFF"> 
<thead>
  <tr>
    <th width="77" height="22" class="Estilo4">&nbsp;</td>
    <th width="319" class="Estilo4"><div align="center"><strong>Materia</strong></div></th>
    <th width="65" class="Estilo4"><div align="center"><strong>Creditos</strong></div></th>
    <th width="65" class="Estilo4"><div align="center"><strong>Capacidad</strong></div></th>
    <th width="65" class="Estilo4"><div align="center"><strong>Grupo</strong></div></th>
    <th width="94" class="Estilo4"><div align="center"><strong>Lunes</strong></div></th>
    <th width="94" class="Estilo4"><div align="center"><strong>Martes</strong></div></th>
    <th width="94" class="Estilo4"><div align="center"><strong>Miercoles</strong></div></th>
    <th width="94" class="Estilo4"><div align="center"><strong>Jueves</strong></div></th>
    <th width="94"   class="Estilo4"><div align="center"><strong>Viernes</strong></div></th>
  </tr>
</thead>
<tbody>
<?php      


 include('adodb/adodb.inc.php');    
$conn = &ADONewConnection('oracle');    

    if(!$conn->PConnect('tallerbd','system','abcd')) 
    {
       echo "Error en la conexión ..";
       exit;

    }

 $recordSet = &$conn->Execute("SELECT M.NOM_CTO, M.CREDITOS,HG.CAPACIDAD,HG.GPO_REAL, HG.H_LUN, HG.H_MAT, HG.H_MIE, HG.H_JUE, HG.H_VIE FROM MATERIAS M, HIST_GRUPOS HG WHERE M.ID=HG.MAT_ID AND M.ACTIVA='S'");

while (!$recordSet->EOF) { 
$V1=$recordSet->fields[0];
$V2=$recordSet->fields[1];
$V3=$recordSet->fields[2];
$V4=$recordSet->fields[3];
$V5=$recordSet->fields[4];
$V6=$recordSet->fields[5];
$V7=$recordSet->fields[6];
$V8=$recordSet->fields[7];
$V9=$recordSet->fields[8];

echo("<tr><td><input type='checkbox' value=$V4 id='check' name=$V4></td>
<td>$V1</td>
<td>$V2</td>
<td >$V3</td>
<td id='grupo' value='$V4'>$V4</td>
<td>$V5</td>
<td>$V6</td>
<td>$V7</td>
<td>$V8</td>
<td>$V9</td></tr>");
 $recordSet->MoveNext(); 
}//del while

//echo("</tbody>");
//echo(" </table>");

 ?> 
 </tbody>
</table>

I want is that when you click on a row will do a search in the database and if certain conditions are met to clear the line of the column and insert another.

Then if you want to delete the selection in another board to do another query and delete the row from the second table and reinsert the first

I do not speak English very well forgive me if I do not understand me very well I hope someone can help me I've searched but can not find something to help me