just finished getting everything set up at work and had a few problems with connecting to mySQL.
now that i can connect to mySQL, i cannot seem to select the database i want.
if i run myysql.exe i can select the db i want and run commands fine.
but when i run my script i get "Could not select database!");
Code: Select all
mysql_connect('localhost','chris','survey') or die ("Could not connect to database");
mysql_select_db('survey') or die ("Could not select database!");now one other query if anyone knows anything about is,
as i said before i had some problems connecting to MySql.
i went from:
$db = mysql_pconnect(......
with this error
toExecution failed: 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 'Resource id #2' at line 1
mysql_pconnect(......
and it worked. strange could some tell me whats going on thanx!