August 26th, 1999, 10:12 AM
Hi - The following code prints the test message but bombs on the databse selection:
$mysql_link=mysql_connect ($host,$user,$password) or die("Connection failed");
print("This is a test");
$query="SELECT * FROM joesauto";
August 26th, 1999, 10:45 AM
I'm guessing that your problem is most likely in the permissions you have set. Check the db table of the mysql database....there should be one entry that has both the database name 'joesauto' and the desired username. Then you'll need to specify a set of privledges for that user.
Once you are done editing the mysql database you'll need to run 'mysqladmin reload' from the prompt.
For more information on MySQL's privledge system check out:
Or the documentation at:
August 26th, 1999, 05:07 PM
Hi My ISP said that these two statements should NOT have a "$" in front:
Does this make sense? It seems to work - but how can I know when to delete these "$" from examples?
[This message has been edited by rwiegmann (edited 08-26-99).]
August 26th, 1999, 06:25 PM
Yes, I'm sorry I didn't look at your code close enough. Your ISP is right....those two statements should not have dollar signs before them.