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 :).
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php