Voila le problème une fois le formulaire rempli est lorsque l’on clic sur « Add campaign"» rien de ne passe l’ajout a la BDD ne se fait pas et je n’est pas d’erreur Mysql ou même « BUG » ne s’affiche pas !!! je suis sur que la réponse est toute proche et toute conne mais la je vois pas donc je viens vers vous en espérant que vos yeux aide les miens a trouvé une erreur !!!
Merci d’avance ++
Le code de la page =>
<?
if($act=='addcash')
{
$sql=mysql_query("INSERT INTO cashback(fmail, fname, fsitename, fnote, fsize, furl, flogin, fpassword, fstartdate, fenddate, fprise, fpaytype, squest, sansw) VALUES('$email', '$name', '$sitename', '$note', $size, '$url', '$login', '$password','$sdate', '$edate', $prise, '$paytype', '$squest', '$sansw')")or die(mysql_error());
if(mysql_affected_rows())echo"Cash Back CAMPAIGN ADDED SUCCESFULLY!";
else echo"BUG”;
}
?>
<form method="post" action="">
<table width="100%" border="0" background="../images/fon.gif.gif" height="535">
<tr valign="top">
<td colspan="2" bgcolor="#006666"><b><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">ADD
NEW Cash BackCAMPAIGN</font></b></td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">campaign
size:</font></td>
<td width="75%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="size" size="40">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">campaign
URL:</font></td>
<td width="75%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="url" size="40" value="<?if($act=='add') echo $furl?>">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Site
name:</font></td>
<td width="75%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="sitename" size="40" value="<?if($act=='add') echo $fsitename?>">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Site
description:</font></td>
<td width="75%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<textarea name="note" cols="40" rows="4"><?if($act=='add') echo $fnote?>
</textarea>
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Secret
question:</font></td>
<td width="75%"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="text" name="squest" size="40" value="<?if($act=='add') echo $HTTP_POST_VARS[sq]?>">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Secret
answer:</font></td>
<td width="75%"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="text" name="sansw" size="40" value="<?if($act=='add') echo $sa?>">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Advertiser's
name:</font></td>
<td width="75%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="name" size="40" value="<?if($act=='add') echo $fname?>">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Advertiser's
e-mail:</font></td>
<td width="75%"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="text" name="email" size="40" value="<?if($act=='add') echo $femail?>">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Advertiser's
login:</font></td>
<td width="75%"> <font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="login" size="40">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Advertiser's
password:</font></td>
<td width="75%"> <font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="password" size="40">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Campaign
start date:</font></td>
<td width="75%"> <font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="sdate" size="40">
</font></td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Campaign
end date:</font></td>
<td width="75%">
<input type="text" name="edate" size="40"> </td>
</tr>
<tr valign="top">
<td width="25%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Pay
for :</font></td>
<td width="75%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="prise" size="5">
<input type="radio" name="paytype" value="points" checked>
<font size="1">POINTS</font>
<input type="radio" name="paytype" value="usd">
<font size="1">USD</font> </font>
<input type="radio" name="paytype" value="%">
<font size="1">%</font> </font> </td>
</tr>
<tr valign="top">
<td colspan="2">
<div align="center">
<input type="hidden" name="tp" value="newcashback">
<input type="hidden" name="act" value="addcash" >
<input type="submit" name="Submit" value="Add campaign">
</div> </td>
</tr>
</table>
</form>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#006666"><b><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">ACTIVE
Cash Back CAMPAIGNS LIST</font></b></td>
</tr>
<tr>
<td>
<table width=100% border=1 bordercolor=cccccc cellspacing=0>
<tr>
<td>
<div align="center"><i><font face="Verdana, Arial, Helvetica, sans-serif" size="2">#</font></i></div>
</td>
<td>
<div align="center"><i><font face="Verdana, Arial, Helvetica, sans-serif" size="2">e-mail</font></i></div>
</td>
<td>
<div align="center"><i><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Campaign
size</font></i></div>
</td>
<td>
<div align="center"><i><font face="Verdana, Arial, Helvetica, sans-serif" size="2">URL</font></i></div>
</td>
<td>
<div align="center"><i><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Delivered
signups</font></i></div>
</td>
<td>
<div align="center"><i><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Login</font></i></div>
</td>
<td>
<div align="center"><i><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Password</font></i></div>
</td>
<td><i><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Price</font></i></td>
<td>
<div align="center"><i>View</i></div>
</td>
</tr>
<?
$sql=mysql_query("SELECT * FROM cashback ORDER BY fnum");
$rows=mysql_num_rows($sql);
for($i=0;$i<$rows;$i++)
{
mysql_data_seek($sql,$i);
$arr=mysql_fetch_array($sql);
extract($arr);
$sq=mysql_query("SELECT * FROM cashtask WHERE tasknum=$fnum");
$cash=mysql_num_rows($sq);
echo"
<tr><td>$fnum</td><td>$fmail</td><td>$fsize</td><td>$furl</td><td>$cash</td><td>$flogin</td><td>$fpassword</td><td>$fprise $fpaytype</td><td><a href=viewcbcamp.php?fnum=$fnum target=blank>view</a></td></tr>
";
}
?>
</table>
</td>
</tr>
</table>Lorsque je réalise un ajout en manuel (directement a partir de la BDD avec cette meme requête ca fonctionne bien : Donc lerreur ne viens pas de la requête
INSERT INTO cashback(fmail, fname, fsitename, fnote, fsize, furl, flogin, fpassword, fstartdate, fenddate, fprise, fpaytype, squest, sansw) VALUES('$email', '$name', '$sitename', '$note', $size, '$url', '$login', '$password','$sdate', '$edate', $prise, '$paytype', '$squest', '$sansw')
