Hi,
In script below the insert query work fine, the delete have problem, thanks for any help...
Code: Select all
<?
$link = mysql_connect($_HOST, $_USER, $_PASSWORD);
mysql_select_db($_DBNAME);
if(isset($_POST['send']) && $_POST['send']!='' && $_SESSION['usr1name']!='')
{
$query = "SELECT email FROM users where id=".$_SESSION['usr1name'];
$result= mysql_query($query);
$lins = mysql_fetch_array($result, MYSQL_ASSOC);
$querys="delete from mails where userid=".$_SESSION['usr1name'];
$results= mysql_query($querys);
for($i=0;$i<=(int)$_POST['valuescount'];$i++)
{
if($_POST['categ'][$i]!='')
{
$query="insert into mails values(".$_POST['categ'][$i].",'".$lins['email']."',0)";
$result= mysql_query($query);
}
}
}
?>
<form name="newsletter" method="post" action="newsletters.php">
<?
$getsubcats=array();
$getsubcats[0]='0';
if(isset($_POST['send2']) && $_POST['send2']!='')
{
$k=0;
for($i=0;$i<=(int)$_POST['valuescount'];$i++)
{
if($_POST['categ'][$i]!='')
{
$getsubcats[$k]=$_POST['categ'][$i];
$k++;
}
}//end for
} $j=0;//echo "<br>catslcatslalla===>".$getsubcats[0];
for($p=0;$getsubcats[$p]!='';$p++)
{//echo "catslcatslalla";
$query = "SELECT * FROM catesendry where pid=".$getsubcats[$p];
echo "<tr><td colspan=\"2\"><b>".getCatesendryName($getsubcats[$p])."</b></td></tr>";
$result= mysql_query($query);
//echo mysql_error();
$t=0;
while ($lin = mysql_fetch_array($result, MYSQL_ASSOC))
{
$id=$lin['id'];
$cats=hasMail($id);
echo"<tr>";
echo" <td width=\"50%\">
<input type=\"checkbox\" name=\"categ[]\" value=\"".$lin['id']."\" ";
if($cats!=0)
echo "checked";
echo" /> ".$lin['name'];
if($cats!=0)
echo "($cats)";
echo" </td>";
$j++;
if($lin = mysql_fetch_array($result, MYSQL_ASSOC))
{
$id=$lin['id'];
$cats=hasMail($id);
echo" <td width=\"50%\">
<input type=\"checkbox\" name=\"categ[]\" value=\"".$lin['id']."\" ";
if($cats!=0)
echo "checked";
echo" /> ".$lin['name'];
if($cats!=0)
echo "($cats)";
echo" </td>";
$j++;
}
else
{
echo" <td width=\"50%\">
</td>";
} echo"</tr>";
$t++;
}//end while
if($t==0)
echo "<tr><td colspan=\"2\">??? ???????? ????????????? ???? ????????? ????</td></tr>";
}
?>
<input type="hidden" name="valuescount" value="<? echo $j; ?>" />
<input type="submit" name="send" value="save" />
<input type="submit" name="send2" value="next"/>
</form>
<?
}
?>pickle | Please use [php], [code] and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: