Not adding to db

Posted on 16th Feb 2014 07:03 pm by admin

Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get name and email but when I hit submit I get the "or die" message.
Code: $Fname = $_GET['Fname'];
$eMail = $_GET['eMail'];
$submit = $_GET['submit'];

if ($submit == 1)
{

$date = date("Y-m-d");

$sql="INSERT INTO `my_db`.`my_table` (
`usrID` ,
`usrName` ,
`usrEmail` ,
`usrDatereg`
)
VALUES (
NULL , '$Fname', '$eMail', '$date'
)";

$adduser=mysql_query($sql) or die ('Could not add you to mailing list');

$message = "Welcome to the mailing list! ";

}


It's definitely getting all the variables from the form, I tested by printing them as part of the $message variable but it just isn't adding.

Any thoughts?

Your Answer:

Login to answer

Other forums

Check premium expire
Hi,

I am making a simple file hosting site and want to check if users premium subscriptions h

Error in query: Resource id #4??
hey guys, having a minor (i think) problem here that i havent been able to figure out. long story sh

Character Set Setup
Whats the best character set to use if you want every character to work, and also how do you make yo

Php WordPress help
I am writing the following code for making a plugin

<?php
header("Content-Type

Something like an INI editor or a DelimitedText-Editor
Hi all,

Am very, very, very new to PHP and not sure if I should be posting this to a Javascri

BI in Upstream Production operations
Appreciate if you can assist in the following areas:
1) Examples of life before and after BI i

Using loop to count number of entries
I'm writing a program that must ask user to type in numbers. After each entry, the program has to re

Find occurences of unicode characters in string
I need to prohibit filenames with everything but English characters and numbers but regexp and strin

Help Optimizing code
Good Morning,

I wrote a small import function for a website of mine and I know there has to b

need Array help
This is what I have to do.
$teamname[1] = "Red Sox"
$teamname[2] = "Gian