Hi, new user here suffering from a serious headache. I have been trying to figure this out for days. I've scoured the net trying to figure out the answer and I finally need to ask for some help. I run a website where users can upload media directly from a mobile/cell phone and the media appears straight on the website...When a user signs up, they are given a unique code which is entered into the database along with all their registration details. Then when they send their media, I have a query that matches up the unique code and pulls their username out and credits them with that post. I am now trying to add the HTTP_USER_AGENT to the database but I just cannot seem to figure out the correct syntax. Here's what I have: [code]$mms_phone_info = $_SERVER['HTTP_USER_AGENT']; $query = "INSERT INTO phone VALUES ('$mms_phone_info','')";[/code] This works great - it puts the $mms_phone_info in the table 'phone'. But what I really want to do, is UPDATE the field called "phonedetails" in the table "users". I have tried heaps of variations of this: [code] $query = "UPDATE users SET phonedetails = ".$mms_phone_info."WHERE phonepwd='{$_GET['username']}'";[/code] But it just doesn't work. I have something similar to update the number of uploads that gets incremented upon each new post: [code] $query = "UPDATE users SET nuploads=nuploads+1, ". "lastupload=NOW() WHERE phonepwd='{$_GET['username']}'"; $result = mysql_query($query); [/code] and that works perfectly. I'd appreciate ANY help anyone can give me - I'm at my wits end! Apologies for the first post essay! Thanks :)