RE: [PHP] How to fetch only 1st row of tabel without implementing loop?

SELECT * FROM newsmast LIMIT 1 is that what you mean?? jessie :) -----Original Message----- From: Manisha [mailto:manisha@aurica.com] Sent: Thursday, October 11, 2001 9:03 PM To: php-general@lists.php.net Subject: [PHP] How to fetch only 1st row of tabel without implementing loop? I want to fetch only first row with sql statement given to mySQL. 'select * from newsmast' gives me more than 1 records, but I want to display only first row fetched. I know with loop and specifying condition in a loop I can do that. But I want to know, is there anything which I can specify in sql statement itself ? like maxrow = 1 or equivalent ?, so there won't be any need of loop ? manisha -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net