MySQL Forums
Forum List  »  Newbie

Combine tables
Posted by: Ross Bartholomew
Date: October 21, 2016 09:25AM

I want to display results from two tables so that they are related. So that the website viewer can look for info from one table and display the related info from the other table.

This all is to do with swimmers (located in a table called events_eb_registrants) and swims (located in a table called events_eb_events)

I want to be able to display a list of all the swimmers as well as separately all the swims. That I can do without difficulty.

I also want to be able to display all the swimmers for a particular swim - either by clicking on the swim in the displayed list (preferred method) or using the swim ID.
I also want to be able to display all the swims that a particular swimmer has swum in - either by clicking on the swimmer (preferred method) or using the swimmer's ID.

Below are the tables with their respective fields:

events_eb_events
id
parent_id
category_id
location_id
title
event_type
event_date

events_eb_registrants
id
event_id
user_id
group_id
first_name
last_name
organization
address
address2
city

Options: ReplyQuote


Subject
Written By
Posted
Combine tables
October 21, 2016 09:25AM
October 28, 2016 04:42AM


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.