>
> 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;
>
> }
>
> ?>
>
Your while statment has a ; at the end of it.
while ($row = mysql_fetch_array($result)) {
echo $row["company"];
}
--
--Matthew Sims
--<http://killermookie.org>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
