Jump to content


Photo

Trying to insert a variable into table.


  • Please log in to reply
4 replies to this topic

#1 Phree

Phree
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 06 April 2006 - 06:42 PM

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:

$mms_phone_info = $_SERVER['HTTP_USER_AGENT'];
$query = "INSERT INTO phone VALUES ('$mms_phone_info','')";

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:

$query = "UPDATE users SET phonedetails = ".$mms_phone_info."WHERE phonepwd='{$_GET['username']}'";

But it just doesn't work.

I have something similar to update the number of uploads that gets incremented upon each new post:

$query = "UPDATE users SET nuploads=nuploads+1, ".
                     "lastupload=NOW() WHERE phonepwd='{$_GET['username']}'";
    $result = mysql_query($query);

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 :)


#2 jworisek

jworisek
  • Members
  • PipPipPip
  • Advanced Member
  • 112 posts

Posted 06 April 2006 - 07:25 PM

[!--quoteo(post=362319:date=Apr 6 2006, 12:42 PM:name=Phree)--][div class=\'quotetop\']QUOTE(Phree @ Apr 6 2006, 12:42 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
$query = "UPDATE users SET phonedetails = ".$mms_phone_info."WHERE phonepwd='{$_GET['username']}'";
[/quote]

Is it just a typo that you have ".$mms_phone_info."WHERE with no space? if there isn't it will read it all as one word. Try :

$query = "UPDATE users SET phonedetails = '$mms_phone_info' WHERE phonepwd='{$_GET['username']}'";


#3 Phree

Phree
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 06 April 2006 - 07:35 PM

jworisek! You are a STAR!! I tried the syntax you posted and it worked first time :)

Thank-you <so> much! This has been one of those problems where you feel you're never going to get it sorted...You send the image, check the database and just expect it not to have worked. BIG smiles when I just checked it now and it's worked!

Thanks again...Top posting!

#4 jworisek

jworisek
  • Members
  • PipPipPip
  • Advanced Member
  • 112 posts

Posted 06 April 2006 - 07:48 PM

Believe me, I have stared at my fair share of queries and racked my brain only to find I had a typo ;)

#5 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 06 April 2006 - 09:18 PM

Try and get into the habit of using mysql_error() when things start acting strange -- it will prevent many a headache.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users