I need a rank column in my MySQL statement, for example:
SET @rank=0; SELECT @rank:=@rank +1 as rank, player, points FROM my_table
Is there a way to use the above with $wpdb? WordPress doesn't like having 2 lines, the ';' causes it to blow up.
$mydata = $wpdb->get_results($wpdb->prepare(" --MySQL SELECT Statement-- "));