loop and moving up..

[Qben]

Hi, i wonder how to do this:
in the db theres 25 colums.
You can add text to the columns and stuff..

and the content of that table is going to be displayed one column on each row like this:

textfromcolumn1
textfromcolumn2
textfromcolumn3
textfromcolumn4
textfromcolumn5

and so on up to 25.

now if..
..column1 has the text Abc1
..column2 is empty
..column3 is empty
..column4 has the text Abc2
..column5 is empty..

then the empty places are goin to be filled with the non empty ones like this:

..column1 has the text Abc1
..column2 has the text Abc2
..column3 is empty
..column4 is empty
..column5 is empty..

So my question is.. How do i do this?
(Sorry for my english its not very good)

[barand]

You could put the column contents into an array, then [man]rsort[/man] the array to move empty ones to the bottom. Create your table from the array.

hth

[Mordecai]

If you want better speed, then just create a new array rather than rsort()ing. If you know there are a set amount of indeces (25), then you can just create 25-x amount of blank entries in the table as you create it.

Here's how you'd add to an array:

for ($i=0;$i<=25;$i++) {
  $newarray[] = oldarray[$i];
}

[Qben]

i get this:

Parse error: parse error, unexpected '['

on this line:
$newarray[] = oldarray[$i];