Insert date into the database

[Attila]

WOW....My blinders are on I use to be able to do some of this...take 4 months off forget everything...It is commig back slowly but can someone get me on the right track again?

here is what I got.

<? 
$link = mysql_connect("localhost", "user", "pass");
mysql_select_db("database", $link);
mysql_query ("INSERT INTO table_member 
('memberid', 'name', 'password', 'email') 
VALUES ('', '$logon', PASSWORD('$password'), '$email')");
echo "Thank you for Registering.";

?>

The insert string is one long string I just dropped alot of variables out and wanted to make it easier to read instead of scrolling 100ft to the right. SOooo

What is wrong with my insert? It will not insert a thing.

Thank you
😕

[gwchamb]

WOW....My blinders are on I use to be able to do some of this...take 4 months off forget everything...It is commig back slowly but can someone get me on the right track again?

<? 
$link = mysql_connect("localhost", "user", "pass");
mysql_select_db("database", $link);
mysql_query ("INSERT INTO table_member 
('memberid', 'name', 'password', 'email') 
VALUES ('', '$logon', PASSWORD('$password'), '$email')");
echo "Thank you for Registering.";
?>

[/B]

I know nothing about MySQL, but you might want to try removing the single quotes from your table names. It makes Oracle look for a sub-query.

[rIkLuNd]

Try this, but then your id field must be auto incrementing!

<? 
$link = mysql_connect("localhost", "user", "pass");
mysql_select_db("database", $link);
mysql_query ("INSERT INTO table_member 
(name, password,email) 
VALUES ('$logon', PASSWORD('$password'), '$email')");
echo "Thank you for Registering.";

?>