php5 mysql install script

[recklessop]

Hello im looking for suggestions on how to write an install script to install the database code for my automotive repair management system (example at http://belmont.debianbox.net username and password are demo) but anyhow i just need it to write mysql: username password and host and then it needs to create a database and load the base sql file with all the table structure.. and lastly create a default administrator account. if the last part makes it hard i could always code in an admin account into the sql file. but how do you guys normally write something like this ?

also any comments on how i can improve the system... this is my first attempt at writing a full we based application for everyday use. and its first shop is my beta tester of sorts... not sure if its something worth marketing or not

[phpjabbers]

Hi, here is how we do it.
First of all you need to define your variables in a separate file. Just make an array with of them like this

$Options = Array(
user => value,
admin => value,
database => value ...
)

Then define your tables:

$Table['myTable1'] = 'myTavle1'; ....

Then you include your options file in the admin file. This way you have fully customizable system.

All you have to do now is to make PHP installation script for the tables. It is done just the same way that you do with "select" statements. You will have something like this

$sql = 'CREATE TABLE' . $Table['myTable']. '
Id int(8) autoincrement not null,
colName1 varchar(50), ....

Then with one insert statement you can insert admin account.