You are here: Re: Newbie needs help with query « PHP SQL « IT news, forums, messages
Re: Newbie needs help with query

Posted by J.O. Aho on 03/06/07 09:14

Geoff Berrow wrote:
> Message-ID: <op.torcq8kbqnv3q9@misant> from Rik contained the following:
>
>> Raj, look up what crossposting and multiposting is, and why it's frowned
>> upon
>
> To be fair, /I/ would have been interested in a purely SQL solution even
> though I'm only reading php groups. (my solution would have been to
> query with a LIMIT 0,n and do the rest with PHP).

I would have done everything in SQL, as you never know where the server may be
regarding the web-server, if they are at a long distance from each other, you
really want as little traffic as possible between them.

Using limit will give you in the sql query before the result has been randomly
selected, you will always have a random of a subset of the whole, and that
wasn't what the OP did ask for.


> However it /is/ preferable to post in one relevant group first and then
> widen your search in other groups if you do not get a solution.

Yes, but then you do wait at least more than one minute before posting in
other ng.


--

//Aho

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация