This is wierd
I have version 3.23.32 of mysql and version 4.04 of php.
I create a database using DOS prompt in windows by typing the following:
mysqladmin create <dbname>
Now, my problem is when I try to select the database within php. I first of all connect using mysql_connect, and then when I try to select the database with mysql_select_db, it is here where the problem starts.
Now, if I create a database with the name 'test', I can select the dbase fine in php. But when I create any dbase name other than 'test' eg 'website' the damn thing says 'Couldn't select database' (cos I have a die string saying this.)
You see, if i create dbases like 'test1' 'test2' etc, they all work fine, in that i can select them. But no mater what name I call a database that is different from 'test', it just will not connect!!
I am totally puzzled, I really don't understand why it doesn't work.
If anyone can help me I would greatly appreciate it!!!!!!!!
Thankyou very much!
Paul.
I have version 3.23.32 of mysql and version 4.04 of php.
I create a database using DOS prompt in windows by typing the following:
mysqladmin create <dbname>
Now, my problem is when I try to select the database within php. I first of all connect using mysql_connect, and then when I try to select the database with mysql_select_db, it is here where the problem starts.
Now, if I create a database with the name 'test', I can select the dbase fine in php. But when I create any dbase name other than 'test' eg 'website' the damn thing says 'Couldn't select database' (cos I have a die string saying this.)
You see, if i create dbases like 'test1' 'test2' etc, they all work fine, in that i can select them. But no mater what name I call a database that is different from 'test', it just will not connect!!
I am totally puzzled, I really don't understand why it doesn't work.
If anyone can help me I would greatly appreciate it!!!!!!!!
Thankyou very much!
Paul.