just thought i would share this nifty way of checking to see if your php is communicating with mysql.

if so, then check this link out, life may be much easier:
http://www.flashkit.com/board/showth...hreadid=621041

create a file called helloworld.php and put it inside webroot or htdocs for me cuz i use http://www.apachefriends.org . in this file copy and past the code below.

open your browser and point it to http://localhost/helloworld.php and see what you get.

Code:
<html>
	<head>
		<title>PHP Test</title>
	</head>

	<body>
		
		<?php // ***** this code outputs hello world *****
			echo '<p>Hello World</p>';
		?>
		
		<?php // ***** this line tells you what browser your using *****
			echo $_SERVER['HTTP_USER_AGENT'];
			echo '<p></p>';
		?>
		
		<?php // ***** this line checks to see your using IE, if so then it tells you *****
			if (strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') !== FALSE)
			{
				echo 'You are using Internet Explorer.<br />';
				echo '<p></p>';
			}
		?>
		
		<?php // ***** this code connects to mysql, if successfull then it tells me *****
			// ***** this code connects to a database, if successfull then it tells me *****
			// ***** this code outputs the query in html format *****

			// Connecting, selecting database
			$link = mysql_connect('localhost', 'root', 'sweet')
				or die('Could not connect: ' . mysql_error());

			echo 'Connected successfully';
			echo '<p></p>';

			mysql_select_db('amfphpexample') or die('Could not select database');

			// Performing SQL query
			$query = 'SELECT * FROM users';

			$result = mysql_query($query) or die('Query failed: ' . mysql_error());

			// Printing results in HTML
			echo "<table>\n";

			while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
			{
				echo "\t<tr>\n";
				foreach ($line as $col_value)
				{
					echo "\t\t<td>$col_value</td>\n";
				}

				echo "\t</tr>\n";
			}

			echo "</table>\n";

			// Free resultset
			mysql_free_result($result);

			// Closing connection
			mysql_close($link);
		?> 
		
		<?php // this code just tells you the ENTIRE information of php *****
			phpinfo();
		?>
	</body>
</html>
if you need to fix your password for mysql, then here you go as well:
Code:
At the DOS command prompt, execute this command:

C:\> C:\mysql\bin\mysqld-nt --skip-grant-tables

This starts the server in a special mode that does not check the grant tables to control access.
#

Keeping the first console window open, open a second console window and execute the following commands (type each on a single line):

C:\> C:\mysql\bin\mysqladmin -u root flush-privileges password "newpwd"
C:\> C:\mysql\bin\mysqladmin -u root -p shutdown

Replace ``newpwd'' with the actual root password that you want to use. The second command prompts you to enter the new password for access. Enter the password that you assigned in the first command.
and a simple note:
Code:
shell> mysql -ptest
shell> mysql -p test

The first command instructs mysql to use a password value of test, but specifies no default database. The second instructs mysql to prompt for the password value and to use test as the default database.
hope this saved you alot of time...
Hector