General Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Programming > General Programming Help
Reload this Page

INSERT INTO (single record) ... ?

Discuss INSERT INTO (single record) ... ? in the General Programming Help forum on Dev Articles.
INSERT INTO (single record) ... ? General Programming Help forum discussing Perl, Python, Scripting and/or any languages that do not fit into any of the categories above.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old September 1st, 2003, 10:12 PM
scrubbler scrubbler is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2003
Posts: 4 scrubbler User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
INSERT INTO (single record) ... ?
trying to hack my way throught this stuff (bear with me). How do I insert a single variable into a mySQL row... I have some tutorials that have tought me to create new records for a row, but I don't know how to add a single variable into a column. (column exists in my db .. name is text_1) ...thanx for your help

example:
PHP Code:
 mysql_query("INSERT INTO users('text_1') VALUES('"$HTTP_POST_VARS[text_1]"')"; 


I get a parse error ...
Reply With Quote
  #2  
Old September 2nd, 2003, 04:12 AM
laidbak laidbak is offline
you know how we do
Dev Articles Novice (500 - 999 posts)
  
Join Date: Jun 2002
Location: In Tha IE -- San Bernardino COUNTY
Posts: 788 laidbak User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 4 m 2 sec
Reputation Power: 7
Send a message via ICQ to laidbak Send a message via AIM to laidbak Send a message via MSN to laidbak Send a message via Yahoo to laidbak
It would be best for you to separate the sql statement into it's own variable for clarity... these tend to get sort of long.
PHP Code:
 $sql = "INSERT INTO users (text_1) VALUES ('{$_POST['text_1']}');";
mysql_query($sql); 
__________________
__________________________________________________ _
Wil Moore III, MCP | Integrations Specialist | Senior Consultant
Are You Listed...? | DigitallySmooth Inc.
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Programming > General Programming Help > INSERT INTO (single record) ... ?

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway.