Multiple WHERE find_in_set lookups

Question

I'm wanting to pull steamid from multiple clubs. Website is based on an Invision Community site. The output is a list of steamids which is imported into our game servers. My simple pull from one club code below works perfectly:

<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT 
                core_members.steamid,
                core_members.member_id,
                core_members.name,
                core_clubs_memberships.member_id,
                core_clubs_memberships.club_id
        FROM core_members
        INNER JOIN core_clubs_memberships
            ON core_members.member_id = core_clubs_memberships.member_id
        WHERE 
                (core_members.steamid IS NOT NULL AND TRIM(core_members.steamid) <> '') AND (find_in_set('1',core_clubs_memberships.club_id))
        ORDER BY core_members.member_id ASC";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc())    {
    
        echo $row["steamid"]. " ". $row["name"];    
        echo ("\r\n");
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Whenever I try to add a second group, the code doesn't work, for example I tried:

<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT 
                core_members.steamid,
                core_members.member_id,
                core_members.name,
                core_clubs_memberships.member_id,
                core_clubs_memberships.club_id
        FROM core_members
        INNER JOIN core_clubs_memberships
            ON core_members.member_id = core_clubs_memberships.member_id
        WHERE 
                (core_members.steamid IS NOT NULL AND TRIM(core_members.steamid) <> '') AND ((find_in_set('1',core_clubs_memberships.club_id) OR (find_in_set('6',core_clubs_memberships.club_id)))
        ORDER BY core_members.member_id ASC";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc())    {
    
        echo $row["steamid"]. " ". $row["name"];    
        echo ("\r\n");
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Multiple WHERE find_in_set lookups

0 Answers0