Code : Tout sélectionner
Parse error: parse error, unexpected T_ELSE in /home/www/hakazizi/www/Traffic-Exchange/surf.php on line 64Code : Tout sélectionner
elseCode : Tout sélectionner
Parse error: parse error, unexpected T_ELSE in /home/www/hakazizi/www/Traffic-Exchange/surf.php on line 64Code : Tout sélectionner
else
// USE THIS QUERY TO PICK POINT WEIGHTED URLS
$weight=2;
$query = "SELECT url_table.website, url_table.userid, url_table.active, points.userid, points.points FROM url_table INNER JOIN points on url_table.userid=points.userid where url_table.active='y' and points.points >0 and url_table.userid !=".$id." ORDER BY ROUND(ROUND((RAND()/$weight), $weight)*points)";
}
// $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// $row = mysql_fetch_object($result);
// $result = mysql_data_seek ( $query, mysql_num_rows($query)-1 );
// $row= mysql_fetch_object( $result );
// $result = mysql_feild_seek(rand(0,mysql_num_rows($query))-1);
// $row=mysql_fetch_object($result);
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
if( mysql_data_seek ( $result, mysql_num_rows($result)-1 ) );
{
$row = mysql_fetch_object($result);
}
else
a partir du elseelse
echo "invalid data seek";
$_SESSION['random_url'] = $row->website;
$_SESSION['random_urlid'] = $row->userid;
// get user points
$query = "SELECT count(*) AS check_rows FROM url_points WHERE urlid='".$_SESSION['random_urlid']."' AND pointdate='".date("Ymd")."'";
//run the query and get the number of affected rows
$result = mysql_query( $query );
while ( $data = mysql_fetch_assoc( $result ) );
{
$affected_rows = $data['check_rows'];
}
//if there's exactly one result, the user is validated. Otherwise, he's invalid
if($affected_rows > 0) {
$sql="UPDATE url_points SET points=points+1 WHERE urlid='".$_SESSION['random_urlid']."'";
$result = mysql_query( $sql );
if ( $result != false )
{
} else {
echo mysql_error();
}
} else {
$sql="INSERT INTO url_points (urlid, points, pointdate) VALUES (".$_SESSION['random_urlid'].", 1, '".date("Ymd")."')";
$result = mysql_query( $sql );
if ( $result != false )
{
} else {
echo mysql_error();
}
}
// subtract point from random url
$sql="UPDATE points SET points=points-1 WHERE userid=".$row->userid;
$result = mysql_query( $sql );
// add points to user
$sql="UPDATE points SET points=points + ". $_SESSION['point_inc'] ." WHERE userid=".$id;
$result = mysql_query( $sql );
$query = "select userid,points from points where userid=".$id."";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_object($result);
// display points
?>en fait en le rajoutant cela m'as enlever une erreur ligne 60 et elle a ete deplacer en ligne 64 je ne m'en sort plus...Regarde cette ligne :Il y a un ";" en fin de ligne qui n'a rien à faire là.if( mysql_data_seek ( $result, mysql_num_rows($result)-1 ) );
Code : Tout sélectionner
Warning: mysql_data_seek() [function.mysql-data-seek]: Offset -1 is invalid for MySQL result index 6 (or the query data is unbuffered) in /home/www/hakazizi/www/Traffic-Exchange/surf.php on line 60
invalid data seek