[N@$$!]

I want to make a install script to run this query into the mysql database

PHP Code:

CREATE TABLE `gebruikers` (

`id` int(5) NOT NULL auto_increment,

`nickname` varchar(100) NOT NULL default '',

`wachtwoord` varchar(100) NOT NULL default '',

`email` varchar(100) NOT NULL default '',

`actief` tinyint(1) NOT NULL default '0',

`ingelogd` tinyint(1) NOT NULL default '0',

`ip` varchar(15) NOT NULL default '',

`rang` varchar(100) NOT NULL default 'user',

PRIMARY KEY (`id`)

) TYPE=MyISAM; 

In the config file I've already introduced data for the database. tOnly you have to do is include the config.php file. bud how do i mak a install script!?!

greetz N@$$!

[Nico]

You have this query in an config file and want to install it from there?
How does the config file look like? Something like this?

PHP Code:

$query = "

 CREATE TABLE `gebruikers` (

`id` int(5) NOT NULL auto_increment,

`nickname` varchar(100) NOT NULL default '',

`wachtwoord` varchar(100) NOT NULL default '',

`email` varchar(100) NOT NULL default '',

`actief` tinyint(1) NOT NULL default '0',

`ingelogd` tinyint(1) NOT NULL default '0',

`ip` varchar(15) NOT NULL default '',

`rang` varchar(100) NOT NULL default 'user',

PRIMARY KEY (`id`)

) TYPE=MyISAM;  

"; 

In this case require the config file in the installation file and run the query using mysql_query()

PHP Code:

require("config.php");



// Make sure you connected to the database before getting to this point.



mysql_query($query); 

[N@$$!]

no, I want to make a install script for this query. forget the config.php file!;-)

greetz N@$$!

[wiremind]

Create a install.php file, put your database settings in there and run your Create Table query.