Re: very basic php mysql question

> > 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>