MySQL INSERT INTO

Bravo81 · 06-12-2008, 10:07 PM

Hi all,

First of im new anf it took me ages to fine the dam register page!

Ok my problem, I am trying to do a registration page.

All is going well untill it goes to put the data into the Database.

Here my code:

Code:

mysql_query("INSERT INTO `users` (username, password, email, activecode, activated, tut, status)
VALUES ($reg_username, $randompassword, $email, $code, 0, 0, Alive)") or die ('Error Registering');

It isnt working, it dies.

The fields I am inserting into arent the only fields in the Table.
Will this stop it? Just inserting into the defined fields and leaving the rest blank would be great letting them default.

If not I will do it the hard way.

Thanks for any posts, help and advice.

Dean.