|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
|
|||
|
|||
|
lo all
I've a problem. I hope U can help me. I'll mak a Select on a TABLE and I'll order the rows and I'll limit the output. But I can't make ORDER BY and LIMIT x,y in one string. OR? Here an example: SELECT id, name from TABLE ORDER BY id LIMIT 0, 10 But this string dosn't go... I hope U can help me... THX |
|
#2
|
|||
|
|||
|
There is nothing wrong with that query. What error is it giving you when you use it? Are you interfacing with mysql on the command line or thru a script?
|
|
#3
|
|||
|
|||
|
ups
I've answer myself :P Sorry I've write the String correct here but not in the PHP source. I've write here: ... ORDER BY id LIMIT 0, 2; and in my script: ... LIMIT 0, 2 ORDER BY id; It's very embarrassingly for me. But thx for the fast reply. |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > order by and limit x,y question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|