[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] PHP Guru
- Subject: [ale] PHP Guru
- From: cluon at geeklabs.com (Mike Harrison)
- Date: Fri, 1 Feb 2013 09:58:43 +0000 (UTC)
- In-reply-to: <[email protected]>
- References: <CAPfJb3pwgRVBmzBn9iOhx7ZkB4XYeBH9DERWsZ3NEcU5PWfbWA@mail.gmail.com> <[email protected]> <CAPfJb3p=CnYp=9Dh+L0jmQ+kCUip_TapU5dveS9N1m9cUMstnQ@mail.gmail.com> <[email protected]>
> still have parentheses and commas in them. This is why I always alias SQL
> function calls into human readable names if I plan to address the result by
> name rather than by column number.
Please don't EVER use column numbers, and don't ever use "select *" for
something in real code. You want to make your database schema and column
order irrelevant.
And some people in this lists jaws dropped, because they remember when I
used to do both.