I want to just add my name to the database "directory", in table "person", and the appropriate values of 'name' and 'email' (both textboxes on the same page... just didn't include here) in the "email" and "name" varchars.
Buuuut, I need those values to be variables, not set. I'll do some homework tomorrow and see if I can't come up with something. Meanwhile, do you have a solution?
$sql = "INSERT INTO person (name, email) VALUES ('".$_POST['name']."', '".$_POST['email']."')";
mysql_query($sql) or die(mysql_error());
So it produces VALUES like 'steve', 'foo@bar.com' and not steve, foo@bar.com. Without the single quotes mysql will treat them as column names (hence the error). And you don't want the or die bit on the end of the $sql = string, just on the mysql_query() call.