Search the Community

Hi this is kind of hard to explain but I am going to try anyway lol. I have these 3 tables below in a database. This table is called postaride This table is called waypoints The final table is called days The id in the postaride table is an auto_increment and the other two tables get their ids from that table which is why you see in each of the id columnts 12 and 13. What I am trying to do is make a query which will search these 3 tables. I then wanted it to group the information together to be displayed. for example (i have a login system that uses $session->username to find the current users username) I wanted it to find a person username and then the ID and display that information. so like if it found the username tention66626 it would display something like this on my web page: username startpoint waypoints destination monday tuesday ... etc 1 tention66626 Arkesden Arkesden -> ardleigh -> althorne 1 08:00 --:-- username startpoint waypoints destination monday tuesday ... etc 2 tention66626 Abridge Barkingside-> Barking-> Aveley 1 --:-- 10:00 So it would display like this or if the username john was logged in it would do the same getting the relevant information from the tables. This is the sort of thing I am aiming for if it is even possible I have been trying all night but just could not figure it out so thanks in advance for any help or tips anyone can give and I look forward to seeing your replies - Gotenks