rectifier pour la couleur merci.
c'est ca la base de donnée pour les clics?? j'y connais vraiment pas grand chose...
<?php
if($act=='addvisit')
{
if(!mysql_query("CREATE TABLE task$code (
fnum int(10) unsigned NOT NULL auto_increment,
fip char(20) default NULL,
fid int(10),
fdate date default NULL,
ftime time default NULL,
PRIMARY KEY (fnum)
) TYPE=MyISAM;")) {echo"Ce code existe déjà"; exit;}
$sql=mysql_query("INSERT INTO tasks(fcode,fsize,furl,fsitename,fnote,fvisits,fname,flog,fpass,startdate,enddate,prise,fpaytype,ftype) VALUES($code,$size,'$url','$sitename','$note',0,'$name','$login','$password','$sdate','$edate',$prise,'$paytype','$type')") or die(mysql_error());
if(mysql_affected_rows()) echo"Nouvelle campagne ajoutée avec succès !";
}
?>
<form name="addvisit" method="post" action="">
<table border="0" width="100%" align="center" bgcolor="#f5f5f5">
<tr valign="top">
<td colspan="2"><font color="#FFFFFF"><b><font face="Arial, Helvetica, sans-serif">
<h2> AJOUTER UNE NOUVELLE CAMPAGNE DE PTC</h2>
</font></b></font></td>
</tr>
<tr valign="top">
<td width="53%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Code :</font></td>
<td width="47%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<?
if(!mysql_num_rows(mysql_query("SELECT fn AS cod FROM tasks ORDER BY fn DESC"))) $cod=1;
else{
@ extract(mysql_fetch_array(mysql_query("SELECT fn AS cod FROM tasks ORDER BY fn DESC"))); $cod=$cod+1;}
echo"<input type=\"text\" name=\"code\" value=\"$cod\">
<font size=\"1\">(ne pas modifier)</font></font>";
?></td>
</tr>
<tr valign="top">
<td width="53%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Taille de la campagne :</font></td>
<td width="47%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="size" value="<? if($act=add) echo "$ftaille";?>">
</font></td>
</tr>
<tr valign="top">
<td width="53%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Lien à cliquer :</font></td>
<td width="47%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="url" <? if ($act=='add') echo"value=\"$furl\"";?>>
</font></td>
</tr>
<tr valign="top">
<td width="53%"><font size="2" face="\Verdana, Arial, Helvetica, sans-serif">Nom du site :</font></td>
<td width="47%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="sitename" <? if ($act=='add') echo"value=\"$fsitename\"";?>>
</font></td>
</tr>
<tr valign="top">
<td width="53%">
<font size="2" face="Verdana, Arial, Helvetica, sans-serif">Code HTML de la bannière : <br>
sous la forme
</font><font color="#FF0000"><b><font size="1"><font color="#000066"><img src="http://www.site.com/banner.gif" /></font></b><br> </td>
<td width="47%"><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="53%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Nom de l'annonceur :</font></td>
<td width="47%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="name" <? if ($act=='add') echo"value=\"$fname\"";?>>
</font></td>
</tr>
<tr valign="top">
<td width="53%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Login :</font></td>
<td width="47%"> <font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="login">
</font></td>
</tr>
<tr valign="top">
<td width="53%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Mot de passe :</font></td>
<td width="47%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="password">
</font></td>
</tr>
<tr valign="top">
<td width="53%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Gain par visite :</font></td>
<td width="47%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="prise" size="4">
<input type="radio" name="paytype" value="points" checked>
<font size="1">POINTS</font>
<input type="radio" name="paytype" value="euro">
<font size="1">EURO</font></font>
</td>
</tr>
<tr valign="top">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Type de PTC</font></td><td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="radio" name="type" value="compteur" checked>
Triple-Clic
<input type="radio" name="type" value="timer">Timer</font>
</td>
</tr>
<tr valign="top">
<td colspan="2">
<div align="center"><font size="4"> </font></div>
</td>
</tr>
<tr valign="top">
<td colspan="2">
<div align="center">
<input type="hidden" name="tp" value="newptc">
<input type="hidden" name="act" value="addvisit">
<input type="submit" name="Submit" value="Ajouter la campagne">
</div>
</td>
</tr>
</table>
<div align="center"></div>
</form>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><h2>CAMPAGNES DE PTC ACTIVES</h2></font></b></td>
</tr>
<tr>
<td>
<table width=100% border=1 cellspacing=0>
<tr>
<td>
<div align="center"><i>N°</i></div>
</td>
<td>
<div align="center"><i>Code</i></div>
</td>
<td>
<div align="center"><i>Taille de la campagne</i></div>
</td>
<td>
<div align="center"><i>Lien à cliquer</i></div>
</td>
<td>
<div align="center"><i>Clics effectués</i></div>
</td>
<td>
<div align="center"><i>Login</i></div>
</td>
<td>
<div align="center"><i>Mot de passe</i></div>
</td>
<td><i>Gain</i></td>
<td>
<div align="center"><i>Voir/Editer</i></div>
</td>
</tr>
<?
$sql=mysql_query("SELECT * FROM tasks ORDER BY fn");
$rows=mysql_num_rows($sql);
for($i=0;$i<$rows;$i++)
{
mysql_data_seek($sql,$i);
$arr=mysql_fetch_array($sql);
extract($arr);
echo"
<tr><td>$fn</td><td>$fcode</td><td>$fsize</td><td>$furl</td><td>$fvisits</td><td>$flog</td><td>$fpass</td><td>$prise $fpaytype</td><td><a href=viewvisitcamp.php?fn=$fn target=blank>Voir/Editer</a></td></tr>
";
}
?>
</table>
</td>
</tr>
</table>