Pesquisar na Comunidade

Eu tenho uma tabela em html que tá realizando o select de duas outras tabelas uma professor e a outra frases, criei uma outra tabela no musql para gravar os dados do formulario html tipo radio. O que preciso é gravar na tabela voto o voto desse radio, no professor e frase sequente. Segue o codigo: <form action="cadastrar.php" method="post"> <table width="100%" border="1"> <tr> <td width="5%" class="frases" >PROFESSOR(A)</td> <?php //consulta sql $query = mysql_query("SELECT * FROM frases ORDER BY id") or die(mysql_error()); //faz um looping e cria um array com os campos da consulta while($array = mysql_fetch_array($query)) { //mostra na tela o nome e a data de nascimento echo '<td width="23%" class="frases">'.$array['texto'].' </td> '; } ?> </tr> <?php //consulta sql $query = mysql_query("SELECT * FROM professor ORDER BY id") or die(mysql_error()); //faz um looping e cria um array com os campos da consulta while($array = mysql_fetch_array($query)) { ?> <tr> <?php echo'<td class="frases"><strong>'.$array['nome'].'</strong> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> <td> 1<input name="criterio" type="radio" value="1" /> 2<input name="criterio" type="radio" value="2" /> 3<input name="criterio" type="radio" value="3" /> 4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td> </td>'; } ?> </table>