try the query like this:

mysql_query("INSERT INTO  members (email, uname, fname, lname, city, state,
 phone,
address)VALUES('$email','$uname','$fname','$lname','$city','$state','
$phone','$address'") or DIE("ERROR : ".mysql_errno() ."
<b>".mysql_error()."</b>");

But, honestly I think you're missing few spaces to surround ')VALUE(', hey,
it thinks it's a funciton or something.



Sincerely, 

 Maxim Maletsky
 Founder, Chief Developer
 PHPBeginner.com (Where PHP Begins)
 [EMAIL PROTECTED]
 www.phpbeginner.com



-----Original Message-----
From: Greg Kelly [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 12:59 PM
To: [EMAIL PROTECTED]
Subject: [PHP] New uses please help mysql query problem


I am having a problem inserting users info info into the mysql database.
When I check mysql log it shows the query I tried to run. But when I go
check the mysql database the info doesn't appear, I checked the permissions
on the user I have setup and he has all the proper rights. If anyone have
any suggestions .. please help..

mysql_query("INSERT INTO  members (email, uname, fname, lname, city, state,
 phone,
address)VALUES('$email','$uname','$fname','$lname','$city','$state','
$phone','$address'");



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to