Help w/insert into MySQL

[Anon]

Trying to get code listed below to get past a (silly) parse error on the last line. An extra set of eyes would be appreciated...

Input is being received from a form; excuse the code...first iteration.

<?php

Variable declarations

$database = "";
$hostname = "localhost";
$username = "";
$password = "";
$table = "";

$key = $memberID;
$fnam = $firstname;
$mnam = $maidenname;
$lnam = $lastname;
$addr = $address;
$citynam = $city;
$statenam = $state;
$zipcode = $zip;
$phon1 = $phone1;
$phon2 = $phone2;
$phon3 = $phone3;
$mail1 = $email1;
$mail2 = $email2;
$submit = $SubmitForm;

#Establish connection to the MySQL DB
$dbh=mysql_connect($hostname,$username,$password) or die ("Could not connect to the server!");

#mysql_db_query($database, $sql);

Insert record into MySQL DB

$sql="INSERT INTO $table (memberID, firstname, maidenname, lastname, updated, address, city, state, zip, phone1, phone2, phone3, email1, email2) VALUES ('$key', '$fnam', '$mnam', '2002-03-23 21:20:37', '$addr', '$city', '$stat', '$zipcode', '$phon1', '$phon2', '$phon3', '$mail1', '$mail2');

if(!$res=mysql_query($sql, $dbh))
{
echo mysql_error();
exit();
}
?>

[Anon]

There is no need for all that (following) stuff.

$key = $memberID;
$fnam = $firstname;
$mnam = $maidenname;
$lnam = $lastname;
$addr = $address;
$citynam = $city;
$statenam = $state;
$zipcode = $zip;
$phon1 = $phone1;
$phon2 = $phone2;
$phon3 = $phone3;
$mail1 = $email1;
$mail2 = $email2;
$submit = $SubmitForm;

If you make a form with the php extention (ie, form.php), it will pass on the vars, so all you have to do is in the insert statement, use the name of the input boxes on the form.

On my form, i've got an input box with the name of 'email' and i've got two option boxes with the names of 'active' and the values of '1' or '0'. When the user submits, it submits to the following mail.php

<?
$db = mysql_connect("localhost","user","pass");
mysql_select_db("database_name", $db);

$sql = "INSERT INTO dx_email (email, active) VALUES ('$email', '$active') ";

$result = mysql_query($sql, $db);

if (! $result)
{
echo "Page0r is0r Fub0r - cont0r <a href=mailto:[e-mail]>Me0r</a>";
exit();
}

 echo "Thank's mate";

?>

Im currently trying to make it so that if the email excists, it changes to an update statement rather than an insert, but it's 4 in the morn, so i'll try and do it tomo.

Paul Silver
[e-mail]
www.U-MUPPET.co.uk

[[deleted]]

You need to close your quote on the $sql variable assignment :

$sql="INSERT INTO $table (memberID, firstname, maidenname, lastname, updated, address, city, state, zip, phone1, phone2, phone3, email1, email2) VALUES ('$key', '$fnam', '$mnam', '2002-03-23 21:20:37', '$addr', '$city', '$stat', '$zipcode', '$phon1', '$phon2', '$phon3', '$mail1', '$mail2')";

Matt Wade
codewalkers.com

[Anon]

Sorry folks. Realized that there was not an "(" in front of the SELECT statement, as well as the "#" I forget to take out that was in front of

mysql_db_query($database, $sql);

Man I feel dumb.