very basic php mysql question
| From: | AMC | Date: | Mon, 20 Sep 2004 22:17:33 +0000 |
| Subject: | very basic php mysql question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-197351@lists.php.net to get a copy of this message | ||
Hi,
I have a php page with the code below. The page doesn't show the record from
the database when it runs and I'm not sure why. I'm not getting any error
message, just a blank page. There is one record in the tabele I'm trying to
query.
I'm brand new to php so I'd really appreciate the help.
<? php
$user = "aclark";
$host = "localhost";
$password = "ajaxx";
$database = "corrigent";
$connection = mysql_connect($host, $user, $password)or die("can't open damn
connection");
$db = mysql_select_db($database, $connection) or die("can't open damn
database");
$query = "select * from customer";
$result = mysql_query($query) or die ("couldn't execute query");
while ($row = mysql_fetch_array($result));
{
extract($row);
echo $company;
}
?>