Originally Said By: Dave Buchholz
Troy,one thing I notice staright away are that your tables are type InnoDB whereas I would normally work with MyISAM tables (big advantage here for your type of site is full text searching capability)
Dave,
That sound fine. I know it's taken you a lot of time to help me. I will continue reading and experimenting.
I thought that I had to use InnoDB for Relational Tables. Sorry I hadn't even noticed yours were MyISAM.
I did manage to write an SQL Join statement that works a little.
SELECT pair_id, male_id, female_id, imagethumb1 FROM tblBreedingSchedule
LEFT JOIN tblBreeders
ON tblBreedingSchedule.male_id = tblBreeder.id
But it only shows the imagethumb for the male. So now I will go read more on adding the imagethumb for both. This was for a set of currently used tables and the tblBreeders contains both males and females. So I might be hitting a brick wall for that reason.
I might continue to ask questions here in case others have advise. But I will contact you in a week or so. Have a great vacation.
TroyD
