neteikshu Posted June 26, 2006 Report Share Posted June 26, 2006 Ir shada MYsql tabula ID| aa 1 | 1 2 | 2 3 | 5 4 | 6 5 | 7 6 | 3 7 | 30 IR shada tabula kaa lai vinju sakarto Ar MYSQL teiksim kaa atskaites punkts 5 taa la rezultaats buutu sakartots seciibaa sakot no vistuvaak staavoshaa ... (uz abaam puseem) Apmeram shadi ID| aa 3 | 5 4 | 6 // JO +1 5 | 7 // jo +2 6 | 3 // jo -2 2 | 2 // jo -3 1 | 1 // jo -4 7 | 30 // jo + 25 Link to comment Share on other sites More sharing options...
bubu Posted June 26, 2006 Report Share Posted June 26, 2006 eh.. pamatskolā vairāk vajadzēja klausīties matemātikas stundās. SELECT * FROM tabule ORDER BY ABS(aa-5) Link to comment Share on other sites More sharing options...
neteikshu Posted June 26, 2006 Author Report Share Posted June 26, 2006 bubu --> Liels paldies kautkaa neienaaca praataa izmantot iebuuveetaas funkcijas Vismaz parverst to sakumaa par negatiivu un peec tam dabuut apsaluuto vertibu :( Link to comment Share on other sites More sharing options...
Recommended Posts