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.
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?
$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."');";
(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.