Arrow

Team Registration Number | Peter's Sports League Standings | Forum

Back to the sports standings script page
 
Current User: Guest
Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

Home Forum Peter's Sports League Standings Team Registration Number

Team Registration Number
Page:   1   Reply to Post Add a New Topic
UserPost

10:25 am
February 27, 2009


David

Guest

  Quote and Reply
  Report Post
Print this Post
1

Peter,

I am the webmaster for a USSSA Softball League http://www.irvingsoftball.com and we need to to have the teams USSSA registration number added to the team info when we add them to the database. And then when a user clicks on Team History then it will look up the registration number and pull the team history off of that instead of the team name.

How hard would that be to have that added maybe for the next revision.?? Or is there a way to do it now?

1:31 pm
February 27, 2009


David

Guest

  Quote and Reply
  Report Post
Print this Post
2

I actually learned something today.

I figured out how to have to change the masterteam.php and editmasterteam.php to ask for the USSSA Reg # and to have it added to the database right along with showing it on the Manage Master Teams page.

Now I am at the point of needing help. If I add a Reg # in and it is already in the database how do I have it tell me that it is there and what team name it is associated to?

Please help..

2:33 pm
February 28, 2009


Peter

Admin

posts 732
  Quote and Reply
  Report Post
Print this Post
3

Hi David,

I’m not completely sure what you are trying to do. From what I gather, you have successfully added the extra field for the registration number. Then, outside of the sports standings application, you have another database table (different table but same database) that contains information based on the registration number? If so, you need a query similar to this to get at the extra information you want?

SELECT othertable.fieldyouwant
FROM othertable
LEFT JOIN sportsdb_masterteams ON sportsdb_masterteams.regnumber = othertable.regnumber
WHERE sportsdb_masterteams.masterteamid = $masterteamid
Page:   1   Reply to Post

Reply to Topic:
Team Registration Number

Guest Name (Required):

Guest Email (Required):

HTML Editor
Smileys
Confused Cool Cry Embarassed Frown Kiss Laugh Smile Surprised Wink Yell
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
5 + 10    

Topic RSS