MySQL Forums
Forum List  »  Newbie

Re: Query challengers table
Posted by: Jassim Rahma
Date: June 12, 2022 03:35PM

Sorry. did not get you but what I want is the following:

1. Every user will have their user profile saved inside users table.

2. A user will choose to challenge a another user(s) then the details will be saved inside challenge table where challengers.challenger_id is the user himself and the challengers.user_id are all other users he challenged.

3. Now from here I want to get the list of users he challenged that is challengers.challenger_id (you are right) with their user_id, first_name and last_name.

Sorry if it was not clear..

Options: ReplyQuote


Subject
Written By
Posted
June 10, 2022 01:56PM
Re: Query challengers table
June 12, 2022 03:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.