I posted a message in the MySQL forum and got the following response:
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.
I've put a copy of the origional message below.
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/ 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
" $row_array = mysql_fetch_row($result); for ($j = 0; $j < mysql_num_fields($result); $j++) { echo(" " . $row_array[$j] . " " } echo("
" } ?>
I set the following as:
$host="localhost";
$user="root";
$password="";
I've since tried the same "test.php" on a commercial web host and it ran fine.
Can some one please point me in the right direction?
Thanks
Simon
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.
I've put a copy of the origional message below.
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/ 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
" $row_array = mysql_fetch_row($result); for ($j = 0; $j < mysql_num_fields($result); $j++) { echo(" " . $row_array[$j] . " " } echo("
" } ?>
I set the following as:
$host="localhost";
$user="root";
$password="";
I've since tried the same "test.php" on a commercial web host and it ran fine.
Can some one please point me in the right direction?
Thanks
Simon