FUDforum: comp.lang.php » sql order but move some rows bottom

Home » Imported messages » comp.lang.php » sql order but move some rows bottom

Show: Today's Messages :: Polls :: Message Navigator

sql order but move some rows bottom [message #182404]

Sat, 03 August 2013 10:44

nawfer
Messages: 34
Registered: August 2011

Karma:

Member

I would like to order a list; sorted by column 1,
but when the elements have the value 100,
move them at the end of the list

A)
if I have 2 columns
a 2
b 1
c 100
d 1
a 100
b 1
c 2
d 1

B)
to sort by column 1
a 2
a 100
b 1
b 1
c 2
c 100
d 1
d 1

C)
but make sure that when I 100 the row is moved under
a 2
b 1
b 1
c 2
d 1
d 1
a 100
c 100

how can solve both with sql and with php? I was interested in both
solutions although I prefer to understand first how can do with sql;

the sql after fill the php array;

if I use ORDER BY column1 ASC, (column2 = 100) ASC
in reality does how in B)

Report message to a moderator

[Message index]

		sql order but move some rows bottom By: nawfer on Sat, 03 August 2013 10:44
		Re: sql order but move some rows bottom By: Luuk on Sat, 03 August 2013 10:53
		Re: sql order but move some rows bottom By: nawfer on Sat, 03 August 2013 16:10
		Re: sql order but move some rows bottom By: Luuk on Sat, 03 August 2013 16:31
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 11:50
		Re: sql order but move some rows bottom By: Luuk on Sun, 04 August 2013 13:13
		Re: sql order but move some rows bottom By: anver on Sun, 04 August 2013 14:42
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 14:56
		Re: sql order but move some rows bottom By: Luuk on Sun, 04 August 2013 17:36
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 17:52
		Re: sql order but move some rows bottom By: nawfer on Mon, 05 August 2013 12:50
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 15:49
		Re: sql order but move some rows bottom By: Luuk on Sun, 04 August 2013 17:37
		Re: sql order but move some rows bottom By: nawfer on Sun, 04 August 2013 17:53
		Re: sql order but move some rows bottom By: Luuk on Sun, 04 August 2013 18:20
		Re: sql order but move some rows bottom By: nawfer on Mon, 05 August 2013 12:57

Previous Topic:	fetch items from a row
Next Topic:	Validate Radio Buttons?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 20:03:07 GMT 2024

Total time taken to generate the page: 0.04782 seconds