PHP4 and MySQL

[Anon]

I have finally installed PHP4 and can not connect to my MySQL server using the same code as before. Can someone please give me an example of a PHP4 connection string?
Thanks

[Anon]

try this:

$conn = mysql_connect("hostname", "mysql_user", "mysql_pass");

hostname is the host of the mysql server, if both mysql and webserver are on the same box, this would be "localhost". Also, check what port you have mysql listening to - if it is not the default, you have to tell PHP what port by appending the port to the hostname: "localhost:port" where port is the port number.

Also, you will have to select a database to use once you are connected:

mysql_select_db("database");

[Anon]

This is what I use now with PHP3:

$mysql_link = mysql_connect(localhost, "", "");
$db = mysql_select_db ("db", $mysql_link);

This doesn't work with PHP4.
Any clues?

[Anon]

Try changing:

$mysql_link = mysql_connect(localhost, "", "");

to:

$mysql_link = mysql_connect("localhost", "", "");

[Anon]

Still getting errors. Here are the errors and code I am using:

Warning: Supplied argument is not a valid MySQL-Link resource in /home/sites/home/web/testConn.php on line 5

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/home/web/testConn.php on line 6

Code:

mysql_connect("localhost", "--", "--");
$db = mysql_select_db ("guestbook");

$result = mysql_query("SELECT * FROM users;",$db);

$myrow = mysql_fetch_row($result);
$newUsername = $myrow[0];

[Anon]

Almost there:

change:

mysql_connect("localhost", "--", "--");
$db = mysql_select_db ("guestbook");

$result = mysql_query("SELECT * FROM users;",$db);
$myrow = mysql_fetch_row($result);
$newUsername = $myrow[0];

to

Code:

$db = mysql_connect("localhost", "--", "--");
mysql_select_db ("guestbook");

$result = mysql_query("SELECT * FROM users;",$db);
$myrow = mysql_fetch_row($result);
$newUsername = $myrow[0];