syntax error - What did I miss?

[tjverge]

<?php
$username = $_POST['username'];
$password = $_POST['password'];
$userid = $_POST['userid'];
$api = $_POST['api'];

mysql_connect('x', 'x', 'x');
mysql_select_db ("evepay");

$query="insert into users (id, username, password, userid, api) values ('NULL', '".$username."', '".$password."', '".$userid.'", '".$api."')";
mysql_query($query) or die ('Error updating database');
echo "You are now signed up with: " .$username. ;
?>

 

When the script runs it brings back "Parse error: syntax error, unexpected '"' in signup.php" any ideas as to what I missed?

[Pikachu2000]

You're confusing yourself with a bunch of unnecessary string concatenation. You can echo/use variables directly when they're used in a double-quoted string.

 

$query="insert into users (id, username, password, userid, api) values ('NULL', '$username', '$password', '$userid', '$api')";
mysql_query($query) or die ('Error updating database');
echo "You are now signed up with: $username.";

[tjverge]

got it thanks