Re: very basic php mysql question

Thanks, the script runs now, but I cannot open a connection. I know the user name, and password are correct. What could be the cause? <?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; } ?> "Matthew Sims" <matt@killermookie.org> wrote in message news:38150.208.44.135.18.1095719428.squirrel@208.44.135.18... > > > > 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>