This is killing me - I keep getting magical array elements added to my updated array in WP.
For example if my query is (var_dumped below):
string(70) "UPDATE wp_mytable SET already_played = '' WHERE user_id = '1'
the already_played cell shows:
what the hell is going on? Like i say, I var_dump the query and I'm positive its only running once... am I missing something very obvious here? Its set as MEDIUMTEXT.
EDIT here is the code:
$allPlays=array('5','6'); $allPlays=implode(',',$allPlays); global $wpdb; $my_table = $wpdb->get_blog_prefix() . "mytable"; $newQuery = "UPDATE " . $my_table . " SET already_played = '$allPlays' WHERE user_id = '$userID'"; $someResult = $wpdb->query($newQuery); //RESULT is not just 5 and 6, but 5,6,and other randoms!!