Parse Error

[ofSHIZ]

I get a parse error when trying to use this code

<?php
include 'db.php'


$sql = mysql_query("INSERT INTO users (username, password) 
        VALUES('username', 'password')")  

        or die (mysql_error());
echo 'Everything Worked';

?>

Error =
Parse error: parse error in inset.php on line 5

Thanks for help

[BeastRider]

<?php
include 'db.php';

I think you need a semi colon.

[ofSHIZ]

it says the parse error is on line five.. were would i put the semi colon.. before include?
other then that does my code look right?

[BeastRider]

You put the semi colon at the end of the include line, like I demonstrated.

You get a parse error on line 5 because

line 1 = <?php
line 2 = include 'db.php';
line 3 = all blank
line 4 = all blank
line 5 = $sql = mysql_query("INSERT INTO users (username, password)

You get a line 5 parse error because it isn't until line 5 that the interpreter runs into a variable name and realizes you screwed up earlier.

[ofSHIZ]

ok.. so my new code is this

<?php
include(db.php);


$sql = mysql_query("INSERT INTO users_login (username, password) 
        VALUES('username', 'password'")  

        or die (mysql_error());
echo Ok, Everything worked;

?>

On the page before i insert in the text boxes what I want to be the username and password.. it goes to this page and doesnt do anything.. there are no errors.. and it doesnt echo Ok, Everything worked and it doesnt insert it into my database..

[tsinka]

Hi,

you don't use the variables, try this:

include 'db.php'


$sql = mysql_query("INSERT INTO users (username, password) 
        VALUES('$username', '$password')")  

        or die (mysql_error());
echo 'Everything Worked';