union

mySQL 3.23.56

Seshta li se niakoi kak moga samo s SQL da drypna ot tablicata "table1":

id | name | drugi coloni
---------------------------
1| Peter |....
2| Ivan |....
3| Stoyan |....
4| Dimitar |....
5| Nikolai |....
6| Yordan |....
7| Svilen |....

, set ot vida (id 4 e primerno):

id | name | drugi koloni
4 | Dimitar |...
Vsichki ostanali order by id desc

10x ...

>samo s SQL
select .... from table where id=4;
select .... from table where id<>4 order by id desc;
ако с е пхп не стааа така
2 заявки са ти

union го няма в 3.х

root@ro6avia#echo rm -rf * > /bin/seek_and_destroy
root@ro6avia#/bin/seek_and_destroy

Predvid facta, che prosto se opitvash da pomognesh shte premylcha niakoi dumi, koito napirat ... obiavih versiona tochno zaradi lipsata na union-a ... siguren sym, che moje i s edna zaiavka ... mislish li, che tova, koeto si postnal ne mi e iasno ?!?

select .... from table order by id != 4, id desc;

Vpechatlen sym, 10x :)