[Villezzai]

Thanks for the help ;)))))))

[Lucifer Morningstar]

Replace it with:

PHP Code


<?php 
$date = date('Y-m-d H:i:s',time()); 


Make sure the row has the proper type (timestamp).

[Villezzai]

Replace it with:

PHP Code


<?php 
$date = date('Y-m-d H:i:s',time()); 


Make sure the row has the proper type (timestamp).

Hmm, still doesn't work. No errors or anything, the data just won't show up on phpMyAdmin.

[Vana]

PHP Code


<?php 
INSERT INTO table_users (username, password, email, fullname, gender, level, avatar, admin_access, views, date_registered) VALUES ('', '$username', '".hashPassword($password)."', '$email', '$firstname $lastname', '$gender', '0', 'default.png', '0', '$date') 


Well that query is messed up. You have everything shifted to the right as you insert '' into the `username` column and continue from there. You're also missing a value for the `views` column.

Should be something like:

PHP Code


<?php 
INSERT INTO table_users (username, password, email, fullname, gender, level, avatar, admin_access, views, date_registered) VALUES ('$username', '".hashPassword($password)."', '$email', '$firstname $lastname', '$gender', 0, 'default.png', 0, 0, '$date') 


Not sure what your column types are so the integers might need to be changed to strings.