
09-22-2003, 02:36 PM
|
|
|
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
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...
|