View previous topic :: View next topic |
Author |
Message |
ivan
Joined: 08 Sep 2003 Posts: 320 Location: Zagreb
|
Posted: 05.12.2004 17:20 Post subject: max value |
|
|
kako pomoću php-a izvučem iz tablice neku najveću vrijednost
zapravo jel ima neka direktna mysql naredba za to |
_________________ no ojro |
|
Back to top |
|
|
silence
Joined: 24 Apr 2004 Posts: 890 Location: .....ni na nebu, ni na zemlji.....
|
Posted: 05.12.2004 17:32 Post subject: |
|
|
recimo brojčanu?
i treba ti samo taj jedan broj?....
SELECT broj FROM tablica ORDER BY broj DESC LIMIT 0,1
onak, na brzinu.....
računaj da cijeli dan spavam i ovo mi je prvo palo na pamet |
_________________ This End-User License is an agreement between Microsoft Corporation (hereafter referred to as "Microsoft") and you, the end-user (hereafter referred to as "our bitch"). |
|
Back to top |
|
|
ivan
Joined: 08 Sep 2003 Posts: 320 Location: Zagreb
|
Posted: 05.12.2004 17:39 Post subject: |
|
|
vidiš nisam dobro postavio pitanje, meni bi trebalo da mi izbaci red gdje je zbroj neka dva polja najveći
znači ako imam
id ime prezime a b
onda bi trebao izvući ono gdje je a+b najveće
ako nema neka direktna naredba, onda ću to riješit s nekim petljama
fala |
_________________ no ojro |
|
Back to top |
|
|
budha
Joined: 02 Mar 2004 Posts: 1377 Location: Osijek
|
Posted: 05.12.2004 18:05 Post subject: |
|
|
mislim da ces to morat petljat |
_________________ I hate to advocate drugs, alcohol, violence, or insanity to anyone, but they've always worked for me. |
|
Back to top |
|
|
che.UP mi3.crew
Joined: 07 Sep 2003 Posts: 2320 Location: zagreb
|
Posted: 05.12.2004 19:58 Post subject: |
|
|
hm... ne da mi se sad gledat u manual ali u mysqlu imas nesto kao
Code: | select MAX(neko_polje) from ..... |
i to vraca maximalnu vrijednos nekog polja...
pa mozes probat Code: | select MAX (neko_polje + neko_drugo_polje) |
|
_________________ UP | TypeTester | Accommodations App
Meni u Firefox-u ne radi AJAX |
|
Back to top |
|
|
njava mi3.crew
Joined: 25 Aug 2003 Posts: 624 Location: Zagreb
|
Posted: 05.12.2004 21:27 Post subject: |
|
|
word che |
|
|
Back to top |
|
|
ivan
Joined: 08 Sep 2003 Posts: 320 Location: Zagreb
|
Posted: 05.12.2004 22:11 Post subject: |
|
|
e da to je to, ja sam probavao SELECT * FROM tablica WHERE MAX(polje) samo mi baš nije radilo |
_________________ no ojro |
|
Back to top |
|
|
|