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]
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
