Hey there guys, I'm trying to select all the rows where a certain ID is: the problem is the query is only returning the first row with the ID. Kinda clueless here, would appreciate any help.
"SELECT * FROM players WHERE acc_id = '$acc_id'";
Using mysql_fetch_array() , I only have the first listed row with the account ID in the array but there is about 5 in the table.
It's selecting all the data from that first row, and I'm guessing that I'm using the wrong query, I'd really like to avoid writing a loop to go through all these queries as I'm sure there is a way to do it with just a single query.