how to create multiple users with the table php?
Posted: Fri Aug 07, 2009 8:44 pm
(newbie)
i want to create several users like administrator and moderator at start at the createphptable.php..
tried this but dont work. how to setup to add 2nd values to the insert table?
/
if (mysql_query($createAdminTable)){
$sql = mysql_query("INSERT INTO myAdmin (username, password, last_log_date, account_type)
VALUES('administrator','passwordA', now(),'a')") or die (mysql_error());
$sql = mysql_query("INSERT INTO myAdmin (username, password, last_log_date, account_type)
VALUES('moderator','passwordB', now(),'a')") or die (mysql_error());
i want to create several users like administrator and moderator at start at the createphptable.php..
tried this but dont work. how to setup to add 2nd values to the insert table?
/
if (mysql_query($createAdminTable)){
$sql = mysql_query("INSERT INTO myAdmin (username, password, last_log_date, account_type)
VALUES('administrator','passwordA', now(),'a')") or die (mysql_error());
$sql = mysql_query("INSERT INTO myAdmin (username, password, last_log_date, account_type)
VALUES('moderator','passwordB', now(),'a')") or die (mysql_error());