|
Тема |
Re: mysql select/order pitane [re: Dakota] |
|
Автор | dixie (Нерегистриран) | |
Публикувано | 27.11.02 18:31 |
|
|
neznam dali go pravia po pravilnia nachin, no ideiata e slednata:
kogato pisah message board, triabavshe da ima 10 threads per page, vsichko beshe mn. lesno -
...
$next = intval($_GET['next']);
SELECT pole1, pole2, pole3 FROM table WHERE id <= $next ORDER BY id DESC LIMIT 10;
...
neshto podobno...
t.e vsichko se kontrolirashe s incremental id-ta i novite postove biaha s po-golemi id-ta, syotvetno imashe niakakyv order.
sega tova koeto prtavia e search engine i e gotov s izkluchenie na next 20 chastta. tuk ot incremental id-ta niama smisyl tyi kato search hitovete ne spazvat niakakva posledovatelnost i shte stane goliama kasha ako pochna da gi polzvam.
v momenta vijdam neshtata kato niakakyv dopulnitelen column,
koito da nosi nomer-a na vseki selectnat red, matchnat ot
search-a -
1...match1
2...match2
3...match3
i t.n...ta idei za next? ![](http://i.dirbg.com/clubs/icons/wink.gif)
|
| |
|
|
|