Link to home
Start Free TrialLog in
Avatar of Bob Schneider
Bob SchneiderFlag for United States of America

asked on

Building JSON Results Table FROM DB

I want to take a page like this and create a JSON table so users could look up finishers based on one or more of the following search fields:
1) First Name
2) Last Name
3) Gender
4) Age
5) Bib
6) Race Participating in

All of these fields are in a sql server db will require a JOIN of three tables.

Tables:
1) Participant (First, Last, Gender) joined by ParticipantID to
2)  PartRace (Bib, Age) joined by RaceID to
3) RaceData (Race Entered)

Let me know what else I need to tell you to purt this together.
Avatar of Bob Schneider
Bob Schneider
Flag of United States of America image

ASKER

Oops....that should have said I want a JSON page...
ASKER CERTIFIED SOLUTION
Avatar of Big Monty
Big Monty
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you very much, both of you!