http://forum.lowyat.net/ Tue, 27 Oct 2026 08:37:52 +0800 FeedCreator 1.7.2 http://forum.lowyat.net/topic/4852267 All the otai coding master. i need help. if i want to put a condition to this query like status has to be &#39;3&#39; then only ttlpoints+&#036;points will execute. but status is from earn_act table. and the data that i want to update is from csp table this is the code i have right now...<br /><br />if (&#036;row[`xid&#39;]&#33; = &#39; &#39;) <br />{ <br />&#036;sql_update_csp= &quot;UPDATE csp SET ttlpoints =(ttlpoints+&#036;point) where xid=&#39;&#036;xid&#39;&quot; ; <br />how do i fix this? i tried putting AND after where like this where xid=&#39;&#036;xid&#39; and earn_act. status=&#39;3&#39;; but it doesnt work knightz11 Codemasters Wed, 16 Oct 2019 18:43:22 +0800