<?php
$BT_login            =addslashes(@$_POST['BT_login']);
$BT_pass            =addslashes(@$_POST['BT_pass']);
$BT_passconf        =addslashes(@$_POST['BT_passconf']);
$BT_mail            =addslashes(@$_POST['BT_mail']);
$BT_country            =addslashes(@$_POST['BT_country']);
$BT_zip                =addslashes(@$_POST['BT_zip']);
$BT_place            =addslashes(@$_POST['BT_place']);
$BT_sex                =addslashes(@$_POST['BT_sex']);
$BT_birth            =addslashes(@$_POST['BT_birth']);
/*####################################*/
$DLL_date            =addslashes(date('d-m-Y'));
$DLL_hour            =addslashes(date('H:i:s'));
$DLL_time            =addslashes(time());
/*####################################*/
$VAR_auth            =addslashes(sha1(rand(1,9999).time()));
function VerifierAdresseMail($adresse)
{
   $Syntaxe='#^[\w.-]+@[\w.-]+\.[a-zA-Z]{2,5}$#';
   if(preg_match($Syntaxe,$adresse))
      return true;
   else
     return false;
}
    
/*####################################*/
 
$Authcaps='~[a-z9\-+]~';
if(preg_match($Authcaps,$BT_login, $matched))
{ //#SI LE PSEUDO NE CONTIENT QUE LES CARACTERES AUTORISES
    $DLL_pseudo=@mysql_query ("SELECT 'var:login' FROM members WHERE 'var:login'='$BT_login' " ) or die (mysql_error());
    if(mysql_num_rows($DLL_pseudo)>=1)
    { //#SI LE PSEUDO EXISTE DEJA DANS LA DATABASE
    echo "A";
    }
    else
        { //#SI LE PSEUDO N'EXISTE PAS DANS LA DATABASE
        if(empty($BT_login) and empty($BT_pass) and empty($BT_passconf) and $BT_pass=$BT_passconf and empty($BT_mail) and empty($BT_country) and empty($BT_zip) and empty($BT_place) and empty($BT_sex) and empty($BT_birth))
        { //#SI IL MANQUE DES CHAMPS
        echo "Erreur : Veuillez remplir tous les champs";
        }
        else
        {
         if(VerifierAdresseMail($BT_mail))
         { //#SI L'ADRESSE EMAIL EST VALIDE
          if(strlen($BT_login)>3)
          { 
$EXE_signup1= "INSERT INTO `members` ('', '$BT_login', '$BT_pass', '$VAR_auth', '$BT_sex', '$BT_mail', '$BT_country', '$BT_zip', '$BT_place', '$DLL_date', '$DLL_hour', '$DLL_time') ";
            mysql_query($EXE_signup1,$dbG) 
            or die("<br>".mysql_error());
            echo "Bravo";
                
                //
                //
                //# FIN DE L'INSCRIPTION DU MEMBRE DANS LA BASE DE DONNEES
             }
            }
            else { echo "A";/* ADRESSE EMAIL INVALIDE */ }
          }
    }
 }
else { echo "C"; /* PSEUDO CONTIENT CARACTERE NON AUTHORISE */ }

REQUETE : INSERT INTO `members` ('var:id', 'var:login', 'var:password', 'var:auth', 'var:sex', 'var:mail', 'var:country', 'var:zip', 'var:city', 'var:date', 'var:hour', 'var:time') VALUES ('3331714542', 'test', 'test', '4486eea55a76bf77bf2723ba3189d62761192680', 'Homme', xxxxxx@hotmail.fr', 'FR', '31100', 'Toulouse', '18-04-2007', '23:18:17', '1176931097') 
 
Erreur de syntaxe près de ''var:id', 'var:login', 'var:password', 'var:auth', 'var:sex', 'v' à la ligne 1