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 here...
}
?>
MD> Hello,
MD> 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,
MD> and I cant firgure out whats wrong with it:
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)
MD> while ($row = mysql_fetch_row($result))
MD> {
MD> $row
MD> }
?>>
MD> Thanks,
MD> Mike Delorme
WBR, Max 'AMiGo' Gashkov
amigo@otaku.ru ]=[ http://diary.otaku.ru/amigo
http://www.journals.ru/users/endymion
Distributed.net participant [408228][RC5-72]
______________________________________________
NP: [Massimo Santucci] 2 love (first cut)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
