cancellazione record mysql

[bstefano79]

function lista(){
 $query2="SELECT * FROM question ORDER BY Id_question";
 $result2=mysql_query($query2);
 $x=mysql_num_rows($result2);
 for($y=0; $y<$x; $y++){
 $resto=$y%2;
 if($resto==0){
 $resultL=mysql_fetch_array($result2);
 echo "<tr><td><input name=\"elimina[]\" type=\"checkbox\" value=\"$resultL[Id_question]\" /> </td><td>$resultL[Id_question]<td>$resultL[1]</td><td>$resultL[2]</td></tr>";
 }else{
 $resultL=mysql_fetch_array($result2);
 echo "<tr style=background:#EDE9FF><td><input name=\"elimina[]\" type=\"checkbox\" value=\"$resultL[Id_question]\" /></td><td>$resultL[Id_question]</td><td>$resultL[1]</td><td>$resultL[2]</td></tr>";
 }

 }
 } 

questa funzione è un po' contorta, va semplificata io farei così

function lista(){
 $query2="SELECT * FROM question ORDER BY Id_question";
 $result2=mysql_query($query2);
 $i=0;
while($resultL=mysql_fetch_array($result2))
{
     $style="";
     if($i==0)
     {
         $i=1;
     }
     else
    {
           $style="style=\"background:#EDE9FF\"";
           $i=0;
    }
    echo "<tr $style><td><input name=\"elimina[]\" type=\"checkbox\" value=\"$resultL[Id_question]\" /></td><td>$resultL[Id_question]</td><td>$resultL[1]</td><td>$resultL[2]</td></tr>";
}