PHP Code:
$fetch_cats = $DB_site->query("SELECT id,title,order FROM `categories` ORDER BY order DESC");
while ($category = $DB_site->fetch_array($fetch_cats))
{
echo $category['title'] . ' ';
echo '<input type="text" name="cat_order['.$category['id'].']" value="'.$category['order'].'" />';
}
Then the POST process portion:
PHP Code:
$fetch_cats = $DB_site->query("SELECT id,title,order FROM `categories`");
while ($category = $DB_site->fetch_array($fetch_cats))
{
$DB_site->query("UPDATE `categories` SET order=$_POST[cat_order][$category[id]] WHERE id=$category[id]");
}
This should work. You might get a parse error or two since I compiled this very quickly, but it shouldn't be hard to work around.