Here is the query:
mysql_query("UPDATE il_pageparameters SET totalvisitor_to_refer=$totalvisitor_to_refer, referer_page_url='$referer_page_url', message='$message', rewardmessage='$rewardmessage', background_image='$bg', poweredby='$rg', istoshowrm=$istoshowrm, msg1='$msg1' WHERE id=$configid;");
I have tried echo'ing the output:
echo "UPDATE il_pageparameters SET totalvisitor_to_refer=$totalvisitor_to_refer, referer_page_url='$referer_page_url', message='$message', rewardmessage='$rewardmessage', background_image='$bg', poweredby='$rg', istoshowrm=$istoshowrm, msg1='$msg1' WHERE id=$configid;";
Run the echo'd output manually in phpmyadmin and it works fine.
If i paste the echo'd output into the mysql_query() statement it works fine.
But if i build the query like that it updates multiple rows instead of just the row i have chosen with the WHERE clause.
Anyone have any ideas?