There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Web Design & Development
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Internet & Networking > Web Design & Development >
Solved: Newbie Mysql query


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
skyhigh007's Avatar
Senior Member with 387 posts.
 
Join Date: Jun 2004
03-Mar-2008, 05:14 PM #1
Solved: Newbie Mysql query
Hi

I'm trying to create an Newsletter sign up function using php and mysql.
My question is how do you add the E-mail address into your database table called Customers with a field called cust_Email inside the table?

Thank you
cristobal03's Avatar
Distinguished Member with 2,991 posts.
 
Join Date: Aug 2005
Experience: Advanced
03-Mar-2008, 07:32 PM #2
The proper INSERT SQL syntax for MySQL is
INSERT INTO `Customers` (cust_Email) VALUES(your email string);
Notice that has nothing to do with the implementation of the form. You'll have to apply the syntax to whatever routine you use to grab the form contents and open the connection.

chris.
skyhigh007's Avatar
Senior Member with 387 posts.
 
Join Date: Jun 2004
03-Mar-2008, 09:55 PM #3
Ohh Thank you
cristobal03's Avatar
Distinguished Member with 2,991 posts.
 
Join Date: Aug 2005
Experience: Advanced
04-Mar-2008, 12:07 AM #4
No problem

If that sorted your issue, you can mark this thread "Solved" using the Thread Tools at the top of the page.

chris.
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 01:56 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.