Rebonjour,

Voici le code qui me pose problème : à l'issue du script, il cherche le lien contenu dans le champ 'url' de la table 'blocks' alors que je voudrais qu'il cherche le lien contenu dans le champ 'title' d'une autre table 'users'. Quelqu'un saurait il m'aider pour corriger ce pb ? Merci bcp par avance ! Etienne

<?php

include ("config.php");
$block_id=$_REQUEST['block_id'];
if ($block_id=='') {
die();

}
$BID=$_REQUEST['BID'];
if ($BID=='') {
$BID=1;
}

$sql = "SELECT url, user_id from blocks where block_id='$block_id' AND banner_id='$BID' ";
$result = @mysql_query($sql);
$row = @mysql_fetch_array($result);

// basic click count.

$sql = "UPDATE users SET click_count = click_count + 1 where ID='".$row[user_id]."' ";

$result = @mysql_query($sql);


// echo "$BID - $date : $result : $x :$sql";
if (ADVANCED_CLICK_COUNT=='YES') {

$date = gmdate(Y)."-".gmdate(m)."-".gmdate(d);
$sql = "UPDATE clicks set clicks = clicks + 1 where banner_id='$BID' AND `date`='$date' AND `block_id`='".$block_id."'";
$result = mysql_query($sql) ;
$x = @mysql_affected_rows();

if (!$x) {

$sql = "INSERT into clicks (`banner_id`, `date`, `clicks`, `block_id`, `user_id`) VALUES('$BID', '$date', '1', '$block_id', '".$row[user_id]."') ";
$result = @mysql_query($sql) ;
}


}

//

$sql = "UPDATE blocks SET click_count = click_count + 1 where block_id='".$block_id."' AND banner_id='$BID' ";
//echo $sql;
$result = mysql_query($sql);

header ("Location: ".$row[url]);

?>