Development

else if (isset($_POST['update'])) // Change position and name of the categories
{
confirm_referrer('admin_categories.php');

$cat_order = $_POST['cat_order'];
$cat_name = $_POST['cat_name'];
$cat_id = $_POST['cat_id'];

$result = $db->query('SELECT id, disp_position FROM '.$db->prefix.'categories ORDER BY disp_position') or error('Unable to fetch category list', __FILE__, __LINE__, $db->error());
$num_cats = $db->num_rows($result);

for ($i = 0; $i < $num_cats; ++$i)
{

if ($cat_name[$i] == '')
            message($lang_admin_categories['Must enter name message']);

if ($cat_order[$i] == '' || preg_match('/[^0-9]/', $cat_order[$i]))
            message($lang_admin_categories['Must enter integer message']);
            
if ($cat_id[$i] == '' || preg_match('/[^0-9]/', $cat_order[$i]))
            message($lang_admin_categories['Must enter integer message']);

$db->query('UPDATE '.$db->prefix.'categories SET cat_name=\''.$db->escape($cat_name[$i]).'\', disp_position='.$cat_order[$i].' WHERE id='.$cat_id[$i]) or error('Unable to update category', __FILE__, __LINE__, $db->error());
    }

<tr><th scope="col">ID (ne pas modif)</th>
                        <th class="tcl" scope="col"><?php echo $lang_admin_categories['Category name label'] ?></th>
                        <th scope="col"><?php echo $lang_admin_categories['Category position label'] ?></th>

    <td><input type="text" name="cat_id[<?php echo $i ?>]" value="<?php echo $category[0] ?>" size="3" maxlength="3" /></td>
                                    <td class="tcl"><input type="text" name="cat_name[<?php echo $i ?>]" value="<?php echo pun_htmlspecialchars(utf8_encode($category[1])) ?>" size="35" maxlength="80" /></td>
                                    <td><input type="text" name="cat_order[<?php echo $i ?>]" value="<?php echo $category[2] ?>" size="3" maxlength="3" /></td>