Connects but no data returned!

[Mani Gill]

Hi,

Im using MySQL 5.0 and PHP 5 (on IIS) and am having great problems when running simple SELECT queries in PHP. When testing the connection using:

<?php
$conn = mysql_connect("localhost", "root", "tw197td");
echo $conn;

?>

I get "rescource ID #1" as expected, but when running a basic SELECT query:

$connection = mysql_connection($host, $user, $pw)
or die("Couldnt Connect");

$db = mysql_select_db($database, $connection)
or die("Couldnt Connect");

$query = "SELECT * FROM customer";
$result = mysql_query($query)
or die ("Couldnt execute query");
$row = mysql_fetch_array($result);
extract($row);

echo "The Name is $firstName";


I get a blank page. Ive tried doing a variety of queries and all return a blank page.. Im come to a point where I am well and truely stuck!

Any help will be much appreciated.

many thanks