$newpass = "1"; //substr(md5(time()),0,6);
$sql = "INSERT INTO user SET
userid = '$_POST[newid]',
password = '$newpass',
email = '$_POST[newemail]'";
error('Error at insert user info.' . mysql_error());
$sql = "INSERT INTO character SET
chara = '0'";
error('Error at insert character info.' . mysql_error());
Both tables USER and CHARACTER have an auto-increment variable "id," both starting at 1. The code adds in the information into table USER, but not CHARACTER. When I run the code, "pass2" doesn't display, and when I check my character table, it's empty. What's wrong?
Note that both tables are empty to begin with, and after the code is run, table USER has been filled out, but table CHARACTER has not.