? updating sort order for complete list

Anon

I've been working on building a content management system that will allow you to also create/maintain your navigation. Part of that includes sorting your navigation. I want to be able to have graphical links that will allow you to push an item up or down in the sort order, while updating the rest of the table data with their new sort value.

For example, let's say I've got three items in my nav table:

sort name

1 cat
2 dog
3 fish

I want to be able to have a link that will, say for example, move "fish" to the number two spot and automatically update dog to a sort value of "3" and have all of this updated in MySQL.

I've searched through various PHP script sites and tutorials to clue me in on what I need to do to pull this off, but I haven't found anything. Is there a way to assign new values to multiple table rows and have that information stored accordingly?

Thank you very much!

Michael

mborish_2000

Did you ever figure out how to do that? I'm interested in doing the same thing... very similar to what msnbc.com is doing. I do not need to link to a database though.

mborish_2000

I'm having tons of trouble trying to figure out how to name the pages and reference them with PHP. Here's what I've got so far:

<?php $thisPage="Selling"; ?>

<html>
<head>
<title>Selling</title>
/CSS Management*/
</head>

<?php if ($thisPage=="Selling") {
echo " class=\"open\"";
} else " class=\"closed\""; ?>>

<div id="navigation>
<ul>
<li>Home</li>
<li>Selling Main</li>
<div id="sublink">
<ul>
<li>Sublink1</li>
<li>Sublink2</li>
</ul>
</div>
</ul>
</div>

<?php if ($thisPage=="Buying") {
echo " class=\"open\"";
} else " class=\"closed\""; ?>>
<div id="navigation>
<ul>
<li>Home</li>
<li>Buying</li>
<div id="sublink">
<ul>
<li>Sublink1</li>
<li>Sublink2</li>
</ul>
</div>
</ul>
</div>

Would This Work? Can anybody think of a better way to do this?

mborish_2000

oh, and I'm trying to keep all of the navigation links on a global page too so all the server would see would be <?php include('navigation'); ?>

LoganK

Mborish, part of the reason why people aren't replying is that you have bumped in a 3 1/2 year thread.

Please make your own thread, and people will be much more willing to help you out.

mborish_2000

thanks, I'm gonna do it now