Re: My FIRST php atempt

M. Sokolewicz wrote:

Bret Hughes wrote:

On Fri, 2005-02-18 at 01:47, David Freedman wrote:

I am trying my FIRST php file with an attempt to connect to my mySql server. <?php // Connecting, selecting database $link = mysql_connect('localhost', 'host', 'my_passqword') or die('Could not connect: ' . mysql_error()); echo 'Connected successfully'; mysql_select_db('eatc7402') or die('Could not select database'); // Performing SQL query $query = 'SELECT * FROM my_table'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); ============================== more code to print results. .. .. ============================ // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?> The problem is it won't connect to the database. The server IS running. The host, username, and password are the exact same thing I use to connect the mySqlAdmin tool to the database. Doesn't seem like this should be that difficult. How can I discover why it doesn't seem to connect.

what is in the mysql log? chances are it is a db permission issue since you are not running as the same user as the server is. There was a thread like this earlier this week maybe even today? look in the archives of this list. Bret

actually, I'd suggest he first take another look at his mysql_connect() call... I can't recall mysql_connect taking the hostname argument *twice*! as in mysql_connect('localhost', 'host', 'password'); I'd bet "host" should be replaced with "password" of course I mean username, not password [stupid me]