I figured it out - using the wrong info for host Thanks again "Amc" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > > > 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
