Re: Queries and Common Practices
| From: | Dotan Cohen | Date: | Sun, 22 May 2011 14:45:28 +0000 |
| Subject: | Re: Queries and Common Practices | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-313074@lists.php.net to get a copy of this message | ||
On Sun, May 22, 2011 at 17:38, tedd <tedd.sperling@gmail.com> wrote:
> SELECT p.id, p.name, a.total FROM people p, accounts.a WHERE gender = 'male'
>
Finding the error in the above code is fun. I'm surprised I spotted,
it shows how sensitive one gets to debugging.
For that matter, I like the OP's practice of redundancy in the name of
consistency. If nothing at the least, it gets us used to looking at
the code to debug as above.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com