SQL REPLACE not working

TeamJesus

New Member
There are only two columns and I want to UPDATE only if \[code\]menu_id\[/code\] exists. Otherwise I want to insert a new row. Here's my query:\[code\]REPLACE `dol_subs_menu_access` SET `menu_id` = '{$aVars['menu_item']}',`mlevels` = '{$sMemLevels}'\[/code\]This creates a new row everytime. Is there something I'm missing?
 
Back
Top