Re: Not seeing whats wrong with code
| From: | David Smith | Date: | Thu, 20 Mar 2003 05:22:50 +0000 |
| Subject: | Re: Not seeing whats wrong with code | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26493@lists.php.net to get a copy of this message | ||
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