hi, what have i done wrong

[Evan_Morgan]

ive looked all through my book trying to fathom what i have missed or done wrong. Here is the code

<?
setcookie( "visit", "", time()+86400, "/", "bigwagercasino.com", "0" );

include ('dbconnect.php');

$advert = $GET['advert'];
$member = $GET['member'];

if($advert = '1')
{
$link = "http://www.clickXchange.com/fr.phtml?act=1207331.4";
}

if( ! isset( $visit )
{
mysql_query("UPDATE members WHERE id='$member' SET unique=unique++ AND SET raw=raw++");
header( "Location: $link" );
}
else
{
mysql_query("UPDATE members WHERE id='$member' raw=raw++");
header( "Location: $link" );
}

?>

And here i get a parse error for line 15

Any ideas?

Evan

[drew010]

if( ! isset( $visit )
should be
if( ! isset( $visit ) )

[Evan_Morgan]

i knew it would be something silly 🙁

[Evan_Morgan]

it doesnt update to the database either, is there anything wrong with the sql querys?

Evan

[drew010]

mysql_query("UPDATE members WHERE id='$member' raw=raw++");

that sql query looks like it probably fails.

try
UPDATE members SET raw = raw + 1 WHERE id = '$member'

[drew010]

oops also
mysql_query("UPDATE members WHERE id='$member' SET unique=unique++ AND SET raw=raw++");

should be
UPDATE members SET unique = unique + 1, raw = raw + 1 WHERE id = '$member'