simple script won't work...

if (!$user || !$pass)
{
echo "You have not filled out all the fields. Please hit back on your browser.<br>";
exit;

}

$user = addslashes($user);
$pass = addslashes($pass);

$db = mysql_connect("localhost", "djoseph", "*****");

if (!$db)
{
`echo "Houston, we have a problem...";
exit;
}

mysql_select_db("iedge");

insert into players values '".$user."', '".$pass."')";

it says parse error on line 42!? I think thats below the script itself! What have I done wrong?

All help is mucb appreciated! 🙂

What's up with this line:

insert into players values '".$user."', '".$pass."')";

If this is actually in your script, it's causing problems. It lacks a beginning double quote (among other things). Comment it out and try again.

Also, this line looks a little off:

`echo "Houston, we have a problem...";

Note single quote before echo statement.

Dave

===========================================
http://badblue.com/helpphp.htm
Free small footprint web server for Windows

PHP, file-sharing, Access/Excel transcoding

Thanks for your input, i m taking this out of a book, with some alterations.

I should have mentioned these variables are from a form, with user and pass being the two fields.

if (!$user || !$pass)
{
echo "You have not filled out all the fields. Please hit back on your browser.<br>";
exit;

}

$user = addslashes($user);
$pass = addslashes($pass);

$db = mysql_connect("localhost", "djoseph", "paradise");

if (!$db)
{
echo "Houston, we have a problem...";
exit;
}

mysql_select_db("iedge");

"insert into players values ('".$user."', '".$pass."')";

The insert statment is to insert those values into the players table. Is that what I would use? Thanks again for your time.

I have removed the quote and changed the insert line around. But it still doesnt seem to work.

The variables are from a form input. The new script looks like this, i m trying to insert the values into the players table.

if (!$user || !$pass)
{
echo "You have not filled out all the fields. Please hit back on your browser.<br>";
exit;

}

$user = addslashes($user);
$pass = addslashes($pass);

$db = mysql_connect("localhost", "djoseph", "paradise");

if (!$db)
{
echo "Houston, we have a problem...";
exit;
}

mysql_select_db("iedge");

$query = "insert into players values ('".$user."', '".$pass."')";

$result = mysql_query($query)

why not try this..

$query = "INSERT INTO players (user,pass) VALUES ('$user','$pass')";

Thank you all for the help the script works fine now!