Hello All,

I have created a website that covers a horse racing syndicate and at present I have a table for each of the horses that details each race they run in (i.e. date, distance, placing, money won etc etc)

Obviously from those tables I can retrieve stats on individual horses for example total money won, number of wins, number of seconds etc.

How would I combine the results to show the same data but as a whole syndicate? In other words total wins, total money by all the horses combined.


Any help appreciated

at present I have a table for each of the horses that details each race they run in

That's a very poor way of using a database.

To do what you need easily and efficiently, you would really need to restructure the datastore otherwise you are will have to retrieve each set of data with a seperate call to the database and do the calculations in server side code.

Originally Posted by chrishirst

That's a very poor way of using a database.

To do what you need easily and efficiently, you would really need to restructure the datastore otherwise you are will have to retrieve each set of data with a seperate call to the database and do the calculations in server side code.

Ok thanks.

What structure would you recommend? I am relatively new to PHP so I have just really been self taught!

Can't be specific but offhand;

tables
horse: all the horse detail needed
owner: just the owners details
track: id, name, location etc
race: id, date, distance, track.id, name etc

results: horse.id, race.id, position, time, etc

horse to owner link: owner.id, horse.id
horse to race link: horse.id, race.id, position, prizemoney

then to get any collection of data it just needs JOIN queries to pull the required info out.

These are just approximations of course, to define an exact database schema needs all the information you expect to store.

In addition, i would suggest reading up on Database Normalization and general database design, would be useful to make things easier for yourself in the long run.

Great! Thanks for your help guys!