Email sign up box?

Is that "Goods Cams" or "Good Scams" ?

##--[ FIND ]--##



##--[ REPLACE WITH ]--##


You dont need to edit the REPLACE WITH code, the first four variables of the PHP code are "pointers" for that code.

Must admit, that has crossed my mind aswell

changed the { five lines up for ;

now get

Could not insert new data : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'addresses (email, name) VALUES ('aca@hotmail.com', 'g')' at line 1

Thanks for your help

Its Good scams, I like to abuse the supermarkets when i can with scams, legitimate I may add

cheers

Hmm, Syntax error:


##--[ FIND ]--##




##--[ REPLACE WITH ]--##

getting there it just says

Could not insert new data : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'addresses (email, name) VALUES ('aca@hotmail.com', 'G')' at line 1


Is it maybe the code i used in SQL rather than PHP bit?

Thanks in advance

Nah mate, its me being a muppet and not checking my syntax before making a post.


##--[ FIND IN LINE ]--##


##--[ REPLACE IN LINE WITH ]--##



^^ or what ever you have named your DB, but make sure it has no spaces in it, spaces should be replaced by an underscore character.

Can't quite see where you mean this is what I have now, Thanks

<?PHP

$db_host = 'localhost';
$db_user = 'th';
$db_name = 'STR';
$db_pass = 'a7';

$db = mysql_connect("$db_host", "$db_user", "$db_pass")
or die ("Error connecting to database.");

$connect = mysql_select_db("$db_name", $db)
or die ("Couldn't select the database.");


$email = $_POST['email'];
$name = $_POST['name'];

if(!empty($email) && (!empty($name))) {

$query = mysql_query("INSERT INTO email addresses (email, name) VALUES ('$email', '$name')")
or die ("Could not insert new data : " . mysql_error());

echo ("THANKS FOR YOUR SUBMISSION !");

}

?>

Replace your code with the following:



Note the line:

and that the table name now contains an underscore instead of white space. You will need to change your table name accoringly in your DB as well.

WOW it works, thank you very very much

how do i get the HTML table to be small table as part of an existing web page rather than one page in itself?

Thanks

Paste:



Where ever you want the email form to appear on your page, so just add it to your HTML page somewhere.

Sorry it took so long to get it to work, if I had checked my syntax the first time [ which I should have ] it would have been working a lot quicker,

Thanks Tchuki for all your help

Hi,

Reviving an oldie I guess...

I came across this thread which is very helpful. This helped me start to learn php, so it's a little at a time.

This code works for me but I do have a couple questions if someone here may be able to help.

If an email is not submitted or it is not proper, and someone clicks the submit button, the thank you page still shows up, it is blank (without the thank you). I am trying to figure out how to get that page to state there is an error and to please try again.

If anyone can offer some help, it would be appreciated.

Thank you,
Tony M