-> Mike, MD> I have been having this problem for a while now, and I cant figure it out. the code is: MD> <? MD> $host = "localhost"; MD> $uname = "sniper"; MD> $pass = "starcraft"; MD> $database = "sha"; MD> $tablename = "members"; MD> $connect = mysql_connect ($host, $uname, $pass); MD> $select = "mysql_select_db ($database)"; MD> $query = "SELECT * from $tablename"; MD> $result = mysql_query ($query, $connect);
MD> while ($row = mysql_fetch_array($result)) MD> { MD> print_r( $row ); MD> echo mysql_error(); MD> } ?>> MD> mysql has an error on line 19. Line 19 is while ($row = mysql_fetch_array($result)). What am I doing wrong? MD> Thanks for your help, MD> Mike ensure $result is correct: <? $host = "localhost"; $uname = "sniper"; $pass = "starcraft"; $database = "sha"; $tablename = "members"; $connect = mysql_connect ($host, $uname, $pass); what is that? ;] -> $select = "mysql_select_db ($database)"; # why do u use ""? $query = "SELECT * from $tablename"; $result = mysql_query ($query, $connect); while ($row = mysql_fetch_array($result)) { print_r( $row ); echo mysql_error(); } ?> Yours L0vCh1Y -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php