gnzsolyo, es verdad, no puse el codigo, sorry
aquí esta:
Código PHP:
Ver originalif(isset($_POST['select']))
{
$seleccion=$_POST['select'];
foreach($seleccion as $indice => $valor)
{
$seleccionar = mysql_query("SELECT * FROM playing_today WHERE personalID=".$valor.""); if (!$seleccionar) {
die("Fallo en la seleccion de registro en la Base de Datos playing_today: " . mysql_error()); }
$shtml="<table>";
$shtml.="<tr>";
$shtml.="<td>PlayerName</td><td>PrevOwed</td><td>CourtRental</td><td>PalaRental</td><td>Beberage</td><td>Lesson</td><td>PalaSale</td><td>Balls</td><td>Overgrip</td><td>Food</td><td>Other</td><td>Total</td><td>Paid</td><td>CurrOwed</td>";
$shtml.="</tr>";
$shtml.="<tr>";
$shtml.="<td>".$fila['first_name']." ".$fila['last_name']."</td><td>".$fila['prev_owed']."</td><td>".$fila['court_price']."</td><td>".$fila['pala_rental_price']."</td><td>".$fila['beberage_price']."</td><td>".$fila['lesson_price']."</td><td>".$fila['pala_sale_price']."</td><td>".$fila['balls_price']."</td><td>".$fila['overgrip_price']."</td><td>".$fila['food_price']."</td><td>".$fila['other']."</td><td>".$fila['total']."</td><td>".$fila['paid']."</td><td>".$fila['curr_owned']."</td>";
$shtml.="</tr>";
$shtml.="</table>";
$fp=fopen("fichero.xls","a");
$insertar = "INSERT INTO load_players (first_name, last_name, prev_owed) VALUES ('".$fila['first_name']."', '".$fila['last_name']."', '".$fila['curr_owned']."')";
$borrar = "DELETE FROM playing_today WHERE personalID=".$valor." ";
}
}
}
gracias por contestar