Ninjakreborn Posted May 18, 2007 Share Posted May 18, 2007 I am trying to create an auto-installer for my "admin" program that I re-use from project to project. That I have built into my framework. I have created a file called install.php <?php require_once("../ppassistant/system/core/config.php"); #START // current information // $username = "admin"; // $password = "password"; // you can change it after you login once it's installed. $sql = " CREATE TABLE `administration` ( `id` bigint(20) NOT NULL auto_increment, `email` varchar(220) NOT NULL default '', `username` varchar(120) NOT NULL default '', `password` varchar(120) NOT NULL default '', `accesslvl` varchar(20) NOT NULL default '', PRIMARY KEY (`id`) ); INSERT INTO `administration` (email, username, password, accesslvl) VALUES ('admin', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'all'); "; if (mysql_query($sql)) { echo "Admin Installation Successful.<br />"; }else { echo "Admin Installation Problem.<br />"; echo mysql_error(); } ?> It's coming back with. Admin Installation Problem. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO `administration` (email, username, password, acc Can anyone see something I might have done wrong with this, thanks? Quote Link to comment https://forums.phpfreaks.com/topic/52037-solved-sql-syntax-error-in-installphp/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.