Form input creates new row but no data?

Anon

I'm new at this.

I'm trying to build the most basic app, but have already run into a major problem.

I have a simple form with the following snippet:

<td>First</td>
<td><input type=text name=first maxlength=30 size=30><br></td>
</tr>
<td>Last</td>
<td><input type-text name=first maxlength=30 size=30><br></td>
</tr>

the script that is supposed to insert this into the MySQL database is like the following snippet:
$query = "INSERT INTO sample (first,last) VALUES ('$first' , '$last')";
$result = mysql_query($query);

This adds a new row but does not pass the form elements on to the database. the columns are empty. I do not get any error messages. Is my syntax wrong?

Thank You
Brian

Anon

If your register_globals is off, then you need to use either $HTTP_POST_VARS['first'] (and 'last') or $_POST['first']. (replace POST with GET if your form is using GET method)

Diego

Anon

Ah, i turned register_globals On and it seems to be working now. Thank You very much!!!

Anon

You should read the release announcement for PHP 4.1.0 to know why it was turned off. It has to do with security.

Diego

Anon

thanks for the heads up. this box is running on a closed LAN not connected to the outside.

Anon

Ok, i see whats up with the register_globals now. I was using an older PHP book with that predates the change in the default register_globals setting.

I guess I'll have to get up to speed on the new stuff and turn that back off!

thanks again.

Anon

so i would use?:

$query = "INSERT INTO sample (first,last) VALUES ($_POST['first','last']);