ODBC error

[MrMoz]

Hi I'm connecting to an Access 2003 DB with PHP 4 and attmepting to update a table but I get syntax error everytime can anyone explain my code is below.

Thanks in advance.

// Microsoft Access connection string
$conn=new COM("ADODB.Connection") or die("Cannot start ADO");
$conn-> open("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Jet OLEDBatabase Password=***;Data Source=****;");

$conn -> execute("UPDATE Perfumes SET Perfdesc=$perfd WHERE ID=$number LIMIT 1");