Re: query only returns one row

2003-01-08 Thread Sameh Attia
X wrote: Hmmm, this genereated the error message, Parse error: parse error in /directory/connect.php on line 12 - Line twelve is the first printf... line. Any suggestions? Chris Here is corrected version: ?php $db = mysql_connect(host, user, pwd); mysql_select_db(dbname,$db);

RE: query only returns one row

2003-01-07 Thread X
PROTECTED] Subject: Re: query only returns one row Hi Chris, You need to use a while loop to fetch all of the records returned in the SELECT statement in PHP, as follows: ?php $db = mysql_connect(host, user, pwd); mysql_select_db(dbname,$db); $result = mysql_query

Re: query only returns one row

2003-01-06 Thread Ferhat Can
Hi Chris, You need to use a while loop to fetch all of the records returned in the SELECT statement in PHP, as follows: ?php $db = mysql_connect(host, user, pwd); mysql_select_db(dbname,$db); $result = mysql_query(SELECT * FROM NAMES_TBL,$db); while