taking text from input and creating new row

[notaloser]

here is the script i am using:

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

$sql = 'INSERT INTO users';
$sql .= 'VALUES ( $user_name, $user_pass, $user_email, $aim_aol )'

but all it does is refresh the page, it doesnt make a new row or anything.

this is for a register page...
if anyone knows how to do one... speak up!!!

[jek]

Try this:

$sql = mysql_query( "INSERT INTO `users` ( `user_name` , `user_pass` , `user_email` , `aim_aol`) VALUES ( '$user_name', '$user_pass', '$user_email', '$aim_aol') ")or die("SELECT Error: ".mysql_error());

[notaloser]

no it didnt work, it gave me a "SELECT Error: No Database Selected" when i refreshed. and when i took it out the die, it didnt save.

im just wondering, but is this the way to go about a register script?

[jek]

Ummm... Try reading this thread instead:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10251184&highlight=register+script

[notaloser]

i really dont think that is going to work because i use more information and when i tried that, i got some errors that i couldnt fix