For the love god help me!

_cobalto_

I really need this code, it is suppose to install a data base, but it doesn't do anything, help me 😕


mysql_query ("CREATE DATABASE hosting");

mysql_query ("USE hosting");

mysql_query ("GRANT ALL ON hosting.* TO peter@localhost IDENTIFIED BY 'pasword'");

mysql_connect("localhost","peter","PASSWORD") or die ('Error');

mysql_query ("DROP TABLE IF EXISTS 'cntr_db';
CREATE TABLE 'cntr_db' (
  'id' tinyint(4) NOT NULL auto_increment,
  'cntr' int(11) default NULL,
  'fch_cntl' tinyint(4) default NULL,
  'fch_cntr1' tinyint(4) default NULL,
  'fch_cntr2' tinyint(4) default NULL,
  PRIMARY KEY  ('id'),
  KEY 'id' ('id')
)");

Please don't tell me to use the phpMyAdmin, my boss wan it done in a script, I will name my first born with the name of the person who help me 🙁

[cobalto]

stolzyboy

this worked for me

<?
mysql_query ("CREATE DATABASE hosting"); 

mysql_query ("USE hosting"); 

mysql_connect("localhost","user","pass") or die (mysql_error() . "connect to mysql"); 

mysql_select_db("hosting") or die (mysql_error() . "select db");

mysql_query ("DROP TABLE IF EXISTS `cntr_db`") or die (mysql_error() . "drop table"); 

mysql_query("CREATE TABLE `cntr_db`(
`id` TINYINT( 4 ) NOT NULL AUTO_INCREMENT,
`cntr` INT( 11 ) ,
`fch_cntl` TINYINT( 4 ) ,
`fch_cntr1` TINYINT( 4 ) ,
`fch_cntr2` TINYINT( 4 ) ,
PRIMARY KEY ( `id` ) 
);")or die (mysql_error() . "create table"); 
?>