Small Mysql PHP question

Anon

I know somebody may thinking "hey I've heard this before". It's true I can't connect to mysql using PHP.

The error message I get after taking for ever to run the results back to me.

MySQL Connection Failed: Lost connection to MYSQL server during query in dbconnect.php on line 2

Fatal error: Maximum execution time of 30 seconds exceeded in dbconnect.php on line 2

eg..(dbconnect.php)
<?php
mysql_connect("localhost", "myusername","mypassword") or
die($php_errormsg);

print "Connected successfully";

mysql_select_db("guestbook") or
die ("Could not select database")

I'm running this on a local machine using apache,XP,PHP4 and MYSQL. I have php4 installed using the modules I'm using port 80 I run the phpinfo() and it reads back everthing meaning PHP works. MY server (Apache) is running smoothly under windows surprisingly. I've been stuck for about 3 days Is starting to frustrate me. Please help I searched everwhere. Just think what I went through to get this far never even seeing a unix box before in my life?

Anon

I have no clue but you could try:

$link = mysql_connect(stuff)

Mark

Anon

Good connection to a database. If you have PHP 4.1.1. Just use this and build on it from there.

<?php
$db = mysql_connect("localhost","username","pasword");
mysql_select_db("dbname", $db);
$sql = "select * from tablename where bus_id='$bus_id'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
print("You are in a loop.");
}
?>
Zig's

acenet

hi mack,
check ur mysql setup. u should be able to connect to mysql directly - check this first. i strongly suspect that ur mysql config is not ok. check out the config details for mysql for XP on mysql.com
i think XP config and NT config varies a little when compared to win 95/98. u should see winmysqladmin.exe in c:\mysql\bin and running this starts the mysql daemon. also if have not installed mysql in c:\mysql then u need to make entries in my.ini file which would be present in c:\windows or c:\winnt

all the best
rajesh