[filburt1]

Originally Posted by Velocd

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.

Very bad idea to query in a loop...