How to select from mysql?

  • How to create query SELECT in mysql?

    dbsite – “wp_users” – “user_login”
    dbsite – “players” – “name” – “money”

    As the profile wordpress show data table “money” to match “user_login” and “players”?

    In wp profile: User have 300 (300 from table “money”) dollars.

Viewing 1 replies (of 1 total)
  • Thread Starter twixi

    (@kaban777)

    <?php
    global $wpdb;
    $sql = “SELECT * FROM players WHERE name IN (SELECT user_login FROM wp_users WHERE ????) LIMIT 1″;
    $results = $wpdb->get_results($sql);
    foreach( $results as $result )
    ?>

    <?php echo $result->money; ?>

    ???? = need “user_login” + “name”

Viewing 1 replies (of 1 total)
  • The topic ‘How to select from mysql?’ is closed to new replies.