Wil — Sun, 02 Dec 2001 19:59:32 +0000

I just think it's good practice. Otherwise you may find yourself with undesired results. It also improves on readability, too.

But I am an avid fan of use strict;.

Mark Hensler — Sun, 02 Dec 2001 19:48:37 +0000

Parenthesis are not crucial in that query, they are all AND statements and can only be interpreted one way. Depending who you talk to, it can be considered a good habit.

Wil — Sun, 02 Dec 2001 16:45:39 +0000

Haven't had time to look ar your message, but one thing did hit me in the first few lines. Your MySQL query looks a bit icky.

You should really enclose a number of AND or OR statements in parenthesis. i.e. the following chunk should be in parenthesis:

... WHERE (flag=1 AND status='a' AND cat_ID='$cat_ID') ...

Didn't look at the rest, sorry. Will look when I have more time tomorrow.