MySQL database connection

SpaceshipSpaceship
Watch

Balkee867

Established Member
Impact
0
Ok, I have a registration area on my site, and when people sign up their information goes to my admin section. Since The script I am using doesn't use the "First Name" and "Last Name" fields, I added them to my database and I am trying to send them to my admin section, but it says "cannot execute query 3". Here is the code I am using for query 3:

$ip = $_SERVER['REMOTE_ADDR'];
$query = "INSERT INTO $userstable (username,password,email,vcode,address,city,state, zip,ip,firstname,lastname,)
VALUES ('$_POST[username]','$_POST[password]','$_POST','$_POST[address]','$_POST[city]','$_POST[state]','$_POST[zip]','$ip','$_POST[FirstName]','$_POST[LastName]')";
$resultB = mysql_query($query,$connection) or die ("Coundn't execute query3.");


What am i doing wrong?
 
0
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
AfternicAfternic
...which is just what I said :)
 
0
•••
Yup, thanks a lot guys, it's fixed.
 
0
•••
Appraise.net

We're social

Escrow.com
Spaceship
Rexus Domain
CryptoExchange.com
Domain Recover
CatchDoms
DomainEasy — Zero Commission
DomDB
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back