hello i want to ask , before i use this script n SQL files work fine 100% , but now itsnt work again. my friend say now they dont use UPDATE and WHERE. but still error after i change it. can somebody help me?
Query_SQL("UPDATE `event_log` SET `won_by` = '" + Escape_SQL(StrCharInfo(0)) + "', `won_time` = NOW(), `price_id` = " + $get_item_id + ", `price_amount` = " + $get_item_amount + " WHERE `event` = 'Mr Password' AND `won_by` IS NULL");
Question
RyokoMVP
hello i want to ask , before i use this script n SQL files work fine 100% , but now itsnt work again. my friend say now they dont use UPDATE and WHERE. but still error after i change it. can somebody help me?
Query_SQL("UPDATE `event_log` SET `won_by` = '" + Escape_SQL(StrCharInfo(0)) + "', `won_time` = NOW(), `price_id` = " + $get_item_id + ", `price_amount` = " + $get_item_amount + " WHERE `event` = 'Mr Password' AND `won_by` IS NULL");
Event_Log.sql
thanks for help
Link to comment
Share on other sites
8 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.