I'm trying to delete a some records from a table with checkboxes and then i
have this code:
<html>
<title>Lista de Filmes (DivX)</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<body bgcolor="#DEE3E7">
<form action="action1.php" method="POST" name="form_action1">
<?
$ligacao=mysql_connect("localhost","nac31915","alanis") or die
(mysql_error());
$sql="SELECT titulo,cds,id FROM divx ORDER BY titulo";
$result=mysql_db_query("DB_nac31915",$sql);
if ($ligacao)
{
if ($result)
{
if($HTTP_COOKIE_VARS["cookie1"] && $HTTP_COOKIE_VARS["cookie2"])
{
include('menuadmin.php');
include('menuadmin2.php');
}
else
{
include('menuguest.php');
include('menuguest2.php');
}
?>
<table width="50%" align=center bordercolor="#000000" border=1>
<tr><td align=center bgcolor="#98AAB1" width="5%">...</td><td
align=center bgcolor="#98AAB1" width="90%"><font color="#000000"
face="Courier New, Courier, mono"><strong>T�tulo</strong></font></td><td
align=center bgcolor="#98AAB1" width="10%"><font color="#000000"
face="Courier New, Courier, mono"><strong>Cds</strong></font></td>
</tr>
<?
$i=0;
while ($reg=mysql_fetch_array($result))
{
$titulo=$reg["titulo"];
$cds=$reg["cds"];
$id_cd=$reg["id"];
echo"
<tr><td><input type=checkbox name=del[".$i."]
value=$id_cd></td><td>$titulo</td><td align=center>$cds</td></tr>
";
$i++;
}
echo "</table>";
if($HTTP_COOKIE_VARS["cookie1"] && $HTTP_COOKIE_VARS["cookie2"])
{
include('menuadmin2.php');
include('menuadmin.php');
}
else
{
include('menuguest2.php');
include('menuguest.php');
}
}
else
{
echo "N�o h� registos";
}
}
//mysql_free_result($result);
mysql_close();
?>
</form>
</body>
</html>
that calls action1.php:
<?
$ligacao=mysql_connect("localhost","nac31915","alanis") or die
(mysql_error());
if ($ligacao)
{
if ($botao=='Eliminar')
{
for ($i = 0; $i < count($del); $i++)
{
if ($del[$i]!=0)
{
echo "entrou";
echo $sql="DELETE FROM divx where id=".$del[$i]."";
mysql_db_query("DB_nac31915",$sql);
}
}
}
}
mysql_close();
include('listall.php');
?>
but i can't manage it to dele te records... i don't know what i'm doing
wrong and i'm killing my head to find it : |
can any one help me?
thanks...
ps: here comes the 4 files that listall.php calls
menuadmin2.php:
<?
echo"
<table width=\"50%\" height=\"5\" border=\"0\" align=\"center\"
bordercolor=\"#000000\">
<tr><td align=\"right\"><input width=\"30%\" type=Submit name=botao
value=\"Eliminar\"><input width=\"30%\" type=Submit name=botao
value=\"Editar\"></td>
</table>
";
?>
menuadmin.php:
<p align="center">
<a href="divxmenu.php">-Voltar-</a>
<a href="menulista.php">-Ver Lista-</a>
<a href="adddivxtemp.php">-Adicionar Novo-</a>
<a href="pesqdivx.php">-Pesquisar-</a>
<?
$sql="SELECT COUNT(*) as cont FROM divx WHERE (NOW() - INTERVAL 15 DAY) <=
data";
$cont=mysql_db_query("DB_nac31915",$sql) or die (mysql_error());
if (mysql_result($cont,0,0)!=0)
?><a href="novidades.php">-Novidades-</a>
<a href="menu.php">-Home-</a>
</p>
menuguest.php:
<p align="center">
<a href="pesqdivx.php">-Pesquisar-</a>
<?
$sql="SELECT COUNT(*) as cont FROM divx WHERE (NOW() - INTERVAL 15 DAY) <=
data";
$cont=mysql_db_query("DB_nac31915",$sql) or die (mysql_error());
if (mysql_result($cont,0,0)!=0)
?><a href="novidades.php">-Novidades-</a>
<a href="listall.php">-Home-</a>
</p>
menuguest2.php:
<?
echo"
<table width=\"50%\" height=\"5\" border=\"0\" align=\"center\"
bordercolor=\"#000000\">
<tr><td align=\"right\"><input width=\"30%\" type=Submit name=botao
value=\"Eliminar\"><input width=\"30%\" type=Submit name=botao
value=\"Editar\"></td>
</table>
";
?>
Thanks :)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
