inserting information to a table in my db from a form

[notaloser]

i want to insert the values that are typed into a few inputs to become rows in my database, although im not sure where to start. ive connected to my database, now what.

[sk83rboy]

you need to execute sql querys. It all depends on how you want to layout everything. Heres how to create a row with a variable that you obtain from a form:

<?php

//after connecting to DB

mysql_query("INSERT INTO myTableName VALUES ('$form1', '$form2', '$form3')");

//make sure you change myTableName to the table you want to add in.
//Also make sure $form1, etc are the right variables for your forms

?>

[notaloser]

it doesnt seem to work... it wont save...

im doing this for a register script and i have the table name users, with the colums as user_name, user_pass, user_email, and aim_aol.

i changed what you gave me so its

<?PHP

mysql_connect("localhost","USER","PASS");

mysql_query("INSERT INTO users VALUES ('$user_name', '$user_pass', '$user_email', '$aim_aol')"); 

?>

and the name of each input is what it is in the column (user_name in the column in my db is user_name in the input name)

whats wrong?

[sk83rboy]

<?php

//Change value to your database name

$Database = "the database name";


$DBconnect = mysql_connect("localhost", "USER", "PASS"); 

mysql_select_db($Database,$DBconnect);

mysql_query("INSERT INTO users VALUES ('$user_name', '$user_pass', '$user_email', '$aim_aol')");

print "Success";

?>

It should print success if it worked