MySQL localhost test

[SimonJC]

Hi

I'm trying to setup my computer as a server.

OS: XP Pro
IIS: installed
mysql-3.23.55-win
php-4.3.1-Win32

When I ran "winmysqladmin" I received an ODBC error saying that 3.51 drive hadn't been found. I didn't find the 3.51 driver straight away but found the "myodbc-2.50.39-nt" which I installed, error still there! (obviously!). I have since installed the 3.51 driver which has cured that error.

Do I need to remove the 2.50 driver? If so how?

I've used a test.php (located in "c:/Inetpub/

http://wwwroot")

from "PHP & MySQL for DUMMIES" (like me) and I get the following error:

Error " . mysql_errno() . ": " . mysql_error() . "" elseif (mysql_num_rows($result) == 0) echo("Query executed successfully!" else { ?> Variable_name Value
&quot; $row_array = mysql_fetch_row($result); for ($j = 0; $j < mysql_num_fields($result); $j++) { echo(&quot; &quot; . $row_array[$j] . &quot; &quot; } echo(&quot;
&quot; } ?>

I set the following as:
$host=&quot;localhost&quot;;
$user=&quot;root&quot;;
$password=&quot;&quot;;

I've since tried the same &quot;test.php&quot; on a commercial web host and it ran fine.

Can some one please point me in the right direction?

Thanks

Simon

 

[KarveR]

Looks like IIS doesn't know its suppopsed to be using PHP. personally Im unsure of how to configure it to do so but a post in this forum : forum41 should get you up and running quickly ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.