Mysql value not updating?

[fert]

[code]
           $cn=@mysql_connect("","","") or die(mysql_error());
@mysql_select_db("",$cn) or die(mysql_error());
$result=@mysql_query("SELECT num FROM views",$cn) or die(mysql_error());
while($row=mysql_fetch_array($result))
{
$num=$row[num];
}
$num++;
$result=@mysql_query("UPDATE views SET num='$num' WHERE num!='$num'",$cn) or die(mysql_error());
echo "There have been $num views of this page";
[/code]
When i go back to the page that this is on the value is always 1.
what can i do to fix this?

[akitchin]

what's in num in your database?  is there one entry for each page view?

[fert]

num is the number of views

[AndyB]

[code]$result=@mysql_query("UPDATE views SET num='$num' WHERE num!='$num''",$cn) or die(mysql_error());[/code]

There's an error in that compounded statement. ... num!='$num' ' = unmatched quotes.  The query is failing.

When testing, don't use the @ error suppression.

[fert]

I tried that, but it still doesn't work  :(