$aujourdhui = date("d/m/Y"); $montab = explode ( "/" , $aujourdhui ) ; $mmois = $montab[1]; $mannee = $montab[2]; $aujourdhui = $mannee . $mmois; $reqZ= "SELECT ID_CPT FROM CTPB WHERE DATE = '$aujourdhui' AND URL LIKE '$lienvpub%'"; $resultZ = mysql_query($reqZ); $cptZ = mysql_num_rows($resultZ); $rowZ = mysql_fetch_array($resultZ); $id_cpt = $rowZ['ID_CPT']; if ($cptZ == 0) { $req2 = "INSERT INTO CTPB (DATE,URL,COMPTEUR) VALUES ('$aujourdhui','$lienvpub','1')"; mysql_query($req2); } else { $req2 = "UPDATE CTPB SET COMPTEUR = COMPTEUR + 1 WHERE ID_CPT = '$id_cpt'"; mysql_query($req2); } ?> $aujourdhui = date("d/m/Y"); $montab = explode ( "/" , $aujourdhui ) ; $mmois = $montab[1]; $mannee = $montab[2]; $aujourdhui = $mannee . $mmois; $reqZ= "SELECT ID_CPT FROM CTPB WHERE DATE = '$aujourdhui' AND URL LIKE '$lienvpub%'"; $resultZ = mysql_query($reqZ); $cptZ = mysql_num_rows($resultZ); $rowZ = mysql_fetch_array($resultZ); $id_cpt = $rowZ['ID_CPT']; if ($cptZ == 0) { $req2 = "INSERT INTO CTPB (DATE,URL,COMPTEUR) VALUES ('$aujourdhui','$lienvpub','1')"; mysql_query($req2); } else { $req2 = "UPDATE CTPB SET COMPTEUR = COMPTEUR + 1 WHERE ID_CPT = '$id_cpt'"; mysql_query($req2); } ?> $aujourdhui = date("d/m/Y"); $montab = explode ( "/" , $aujourdhui ) ; $mmois = $montab[1]; $mannee = $montab[2]; $aujourdhui = $mannee . $mmois; $reqZ= "SELECT ID_CPT FROM CTPB WHERE DATE = '$aujourdhui' AND URL LIKE '$lienvpub%'"; $resultZ = mysql_query($reqZ); $cptZ = mysql_num_rows($resultZ); $rowZ = mysql_fetch_array($resultZ); $id_cpt = $rowZ['ID_CPT']; if ($cptZ == 0) { $req2 = "INSERT INTO CTPB (DATE,URL,COMPTEUR) VALUES ('$aujourdhui','$lienvpub','1')"; mysql_query($req2); } else { $req2 = "UPDATE CTPB SET COMPTEUR = COMPTEUR + 1 WHERE ID_CPT = '$id_cpt'"; mysql_query($req2); } ?> |