[SOLVED] Correct Syntax

[cheechm]

'UPDATE site_menu SET `order` = ' . $row['order']+1  . ' WHERE `order` < ' .$order . ' AND id != ' . $menu_id;

What is the correct syntax for $row['order']+1?

 

Thanks

 

EDIT:

 

Full code

 
$order = 1;
     if ($action == 'move_up')
                    {
                        $sql = 'SELECT *
							FROM site_menu
							ORDER BY `order` DESC LIMIT 0,1';

                        $result = $db->sql_query($sql);
                        while ($row = $db->sql_fetchrow($result))
                        {
$osql = 'UPDATE site_menu SET `order` = ' . $row['order']+1  . ' WHERE `order` < ' .$order . ' AND id != ' . $menu_id;
                            $oresult = $db->sql_query($osql);
                            $rsql = 'UPDATE site_menu SET `order` = ' . $order . ' WHERE id = ' . $menu_id;
                            $rresult = $db->sql_query($rsql);

                            $db->sql_freeresult($rresult);
                            $db->sql_freeresult($oresult);
                            $db->sql_freeresult($result);

                        }

[marklarah]

Okay, don't use row['...

It hurts mysql... Now try this:

$update_order = $row['order']+1;

"UPDATE site_menu SET `order` = '$update_order' WHERE `order` < '$order' AND id != '$menu_id";