PHP Programming - Newbie question...display records based on field value

Author

Newbie question...display records based on field value

Fred

2004-10-31, 3:55 pm

My dbase has two types of 'customers'

They are 'players' and 'coaches.'

Both types are 'customers' and have several basic fields in common.

But each also has distinct fields.

How do I write the code that selects from the overall 'customers'
table only those records which have "yes" in the "coach" field?

Tim Van Wassenhove

2004-10-31, 8:55 pm

In article <bb7ad7bb.0410311141.3063eb34@posting.google.com>, Fred wrote:
> My dbase has two types of 'customers'
>
> They are 'players' and 'coaches.'
>
> Both types are 'customers' and have several basic fields in common.
>
> But each also has distinct fields.
>
> How do I write the code that selects from the overall 'customers'
> table only those records which have "yes" in the "coach" field?

Assuming you have

customer(customer_ID, common fields);
player(customer_ID, fields for players);
coach(customer_ID, fields for coaches)

SELECT *
FROM coach
INNER JOIN customer ON coach.customer_ID=customer.customer_ID
WHERE coach.foo='YES';

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://www.timvw.info>

Sponsored Links