Mysql query 2

[PhoenixDown]

I havent done php in a while so could someone tell me why this isn't working

include 'config.php';

$dbi = mysql_connect ("$server", "$user", "$pass&quot or die ("Error connecting."
mysql_select_db ("$db&quot or die ("Error selecting database."

$result = mysql_query("update news set views='".($views+1)."' where id='".$id."')", $dbi);

i printed it to the browser and the query looked okay, i just dont know whats wrong.

 

[sleipnir214]

What does mysql_error() report? Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[PhoenixDown]

It says: "You have an error in your SQL syntax near ')' at line 1"

 

[skiflyer]

and 'lo and behold... look at your query, and you have a superflous )

that string comes out to

update news set views='4' where id='110')

Personally, I always like to do something like
$query = "string stuff and all the appending";

mysql_query($sql, $dbi);

so That if there's a problem with the SQL I can just dump it somewhere and look at it.

-Rob

 

[PhoenixDown]

Cool, thanks!