Mike,
Try mysql_fetch_array instead of mysql_fetch_row
--
Beverly Steiner
[EMAIL PROTECTED]
-Original Message-
From: Mike Delorme [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 12:01 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Not seeing whats wrong with
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 =
You're missing a semi-colon... I'll leave it up to you to find. :)
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
-Original Message-
From: Mike Delorme [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20,
Should be:
?
$host = localhost;
$uname = sniper;
$pass = starcraft;
$database = SHA;
$tablename = members;
mysql_connect ($host, $uname, $pass);
mysql_select_db ($database);
$query = SELECT * from $tablename;
$result = mysql_query ($query);
while ($row = mysql_fetch_row($result))
{
...statements