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:crazymonkey1385@hotmail.com] > Sent: Thursday, March 20, 2003 12:01 AM > To: php-db@lists.php.net > Subject: Not seeing whats wrong with code > > 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 > } > ?> > > Thanks, > Mike Delorme -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
