There's nothing wrong with my code below but the problem is that i've used 2 reserved keywords as column names - browse and full.
$query = "INSERT INTO fs_stats(ip, addr, browse, vers, refer, OS, os_vers, res, full) VALUES ('".$ipad."', '".$addr."', '".$brwse."', '".$vers."', '".$referer."', '".$os."', '".$vr."', 'JS Disabled', '".$full."');";
My first question is is there any simple change I can make to the line above that will make this code work, secondly if not how would you rename the columns to unreserved names?
(I dont have administrative access and the administrator is on holiday for the next fortnight!)
Database is SQL server2000 and has anonymous user access to the database via PHP and a DSN set up.