>>>>> "David" == David Woodhouse <dwmw2@???> writes:
David> On Fri, 2007-02-09 at 00:19 +0800, W B Hacker wrote:
David> Hm. I'm not sure about 'SELECT foo AS
David> somearbitraryvariable' but we _could_ probably make it set
David> a variable named according to the _field_ name. So a lookup
David> 'SELECT helo,host,expire FROM greylist where blah' could
David> set variables like $acl_m_helo, $acl_m_host, $acl_m_expire.
David> Actually that's a really bad example and we'd probably want
David> to name them $sql_helo, $sql_host or something like
David> that. But the nomenclature is unimportant. We can now do
David> And of course it only really works like this when there's
David> _one_ result. I'm happy enough to declare that it sets the
David> variables according to the _last_ result returned by the
David> lookup.
Why the last not the first (wouldn't the first be quicker in the code
as well) ?
Sincerely,
Adrian Phillips
--
Who really wrote the works of William Shakespeare ?
http://www.pbs.org/wgbh/pages/frontline/shakespeare/
