Script Error

Anon

Why would I be getting this error with register_globals turned off.

Notice: Undefined variable: jason in c:\inetpub\wwwroot\beachbreeders\test.php on line 25

Here is my code:

Form Page:
<FORM ACTION="test.php" METHOD="POST">
<input type="text" name="jason">
<input type="Submit" value="Submit">
</form>

Code Page (test.php)
<?php
$which_db="beachbreeders";
if(!$link = mysql_connect("localhost", "sa", "password"))
die("No Connect to DB");
if(!mysql_select_db($which_db,$link))
die("No Select DB");
$query = "INSERT into tblBreeder (Name) VALUES (\"$jason\")";
$result = mysql_query($query,$link);
?>

Anon

Because with register_globals off your form submitted variables are not in the global scope. You need to refer to your variable $jason as $_POST['jason'].

or $HTTP_POST_VARS['jason'] if you have PHP < 4.1.0

Anon

Do I do this in the insert statement or before I try to insert it into the database.

Anon

When I do this:
$query = "INSERT into tblBreeder (Name) VALUES ($_POST['jason'])";

I get this error:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in c:\inetpub\wwwroot\beachbreeders\test.php on line 26

Please forgive me, I am a beginner.

Thanks

Anon

lose the quotes:
$query = "INSERT into tblBreeder (Name) VALUES ('$_POST[jason]')";

Anon

I think I got it I had to add this.

$jason = $_POST['jason'];

then in my SQL statement I did this
$query = "INSERT into tblBreeder (Name) VALUES (\"$jason\")";

I tried the way you showed and I got an error.