Re: Not seeing whats wrong with code

David Smith <DavidSmith@byu.net> · Wed, 19 Mar 2003 22:22:50 -0700

Mike Delorme wrote:

Hello,

I am trying to write a script that conects to mysql, then SHA database. Then I need to list ALL the rows of table members. It sais there is a error on line 18. The while statement is on line 18, and I cant firgure out whats wrong with it:

<?

$host = "localhost";

$uname = "sniper";

$pass = "starcraft";

$database = "SHA";

$tablename = "members";

$connect = "mysql_connect ($host, $uname, $pass)"; 
$select = "mysql_select_db ($database)";

$query = "SELECT * from $tablename";

$result = mysql_query ($query)

while ($row = mysql_fetch_row($result))

{

$row

You are missing a semi-colon here. And you are not printing the info. 
Try this instead of "$row": "print_r( $row );".

}
?>

Thanks,
Mike Delorme

--Dave

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php