query help

[esiason14]

I have a list of basball players. For each player listed, the user has the option to select that player so that they can track them in their profile (I got this part working).
The player id in the baseball player table is player_id. In the users table it is myplayer_id.
Next to each player there is a submit button that does the insert into the db if selected. What I want to do is...if that player already exists in the users profile..then show a different image...not the submit button for that player. Make sense?
Basically (I think) I have to build a query that compares the myplayer_id (in the users table) to the player_id (in the players table. Make sense? IF they match, and the user is logged in ($logged_in == 1) then show this :

 echo "\t\t<td$row_color align=\"center\"><img src=\"images/ismyp.gif\" border=\"0\"></td>\n"; 

if there is no match, then show this:

       echo "\t\t<td$row_color align=\"center\"><input type=\"image\" src=\"images/addmyp.gif\" value=\"$player_id\"
name=\"myplayers\"></td>\n";

Can someone please help me figure this out. I've been trying for a couple of hours now and I getting pretty pissed 🙂

[TF_TheMoon]

Your description of what you are trying to achieve does especially make sense, and it sounds like your table structure is wrong as well.

If the user table has a field called player_id then I take it that the you wnat user can only 'track' one player at a time, if you don't then you'll need another table to have a many to many relationship.

It sounds like your page is one page listing all the players, I'm guessing really I need more info, but based on that normaly what you'd do is to run a query of all players that that use has, in your case this would appear to just be something like

SELECT myplayer_id from users WHERE user_id=$userID

Since it appears you only have one record per user. Normally you'd expect multiple rows and then would populate an array with the result of the query the query, then run a query to get the list of players and perform a loop to print the content. What you coudl then do is call the in_array() functin of PHP passing the current playerID and referencing the array of the results from the query. A match would be found if the ID of the current player was in the list of players the user had signed up.