[computerages]

hey eveyone!

I am looking for a php script which would let me order the rows manualy instead of table's id, or something like it...

If you still don't understand what I am looking for:

http://img149.exs.cx/img149/5218/untitled7fk.png

waiting for your reply...thanks!

[rmurdo]

Hi there,

There are probably a dozen ways to do this. What I do is make a field (indexed) called order. You then have an editor with drop down boxes, it reads all the records in then create a dyamic drop down for each one that goes from 1 to total records. Then you can choose what order that drop down is. Save/update the db.

Then you can do a select statement that orders by the column order and not id.

Make any sense?

Robert

[computerages]

Originally Posted by rmurdo

Hi there,

There are probably a dozen ways to do this. What I do is make a field (indexed) called order. You then have an editor with drop down boxes, it reads all the records in then create a dyamic drop down for each one that goes from 1 to total records. Then you can choose what order that drop down is. Save/update the db.

Then you can do a select statement that orders by the column order and not id.

Make any sense?

Robert

Firstly, thanks for the help and your informative reply!!

And it does make sense to me, but I don't understand that how would I make a dyamic drop down menu? COuld you please post that script here?

Thanks again for the help. It is greatly appreciated.

[xtremenw]

Originally Posted by computerages

Firstly, thanks for the help and your informative reply!!

And it does make sense to me, but I don't understand that how would I make a dyamic drop down menu? COuld you please post that script here?

Thanks again for the help. It is greatly appreciated.

Here is how I do it...

print ("<select name=dropdown1>");
while ($row = mysql_fetchrow_array(SELECT order from table))
{
print ("<option value=" . $row[0] . ">" . $row[0]);
}

Not sure if everything is correct. My PHP is a little rusty...

[rmurdo]

Ya.. That looks like the right idea!

Robert

[computerages]

Thanks for the help both of you... But unfortunately I still don't get it... could you guys please post the entire script here... because I am tottaly new to mysql and php..

Thanks again!

[xtremenw]

Originally Posted by computerages

Thanks for the help both of you... But unfortunately I still don't get it... could you guys please post the entire script here... because I am tottaly new to mysql and php..

Thanks again!

I would but I need to goto bed. If there is no reply by tomorrow from rmurdo tomorrow in the later am, i will do it.

you can always email me if you have questions...

I pm'd you my email addy...

[computerages]

Originally Posted by xtremenw

I would but I need to goto bed. If there is no reply by tomorrow from rmurdo tomorrow in the later am, i will do it.

you can always email me if you have questions...

I pm'd you my email addy...

I think rmurdo is gone...

[computerages]

I am still waiting.....