On Sat, 16 Mar 2002 11:50:11 -0000 "DL Neil" <[EMAIL PROTECTED]> wrote:
> Hi Dave, > SELECT * FROM tblNm; > SELECT * FROM tblNm GROUP BY Catid1; > SELECT Catid1, count(*) FROM tblNm GROUP BY Catid1; > > As I said 'follow your instincts' and take it one step at a time: Code > the simplest query first, then try making it more complicated by > adding/amending one clause at a time, crafting the result until it suits > your purposes... Nothing to say except you have to avoid use '*'. That makes your queries easier to read and will safe your db engine :). pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php