Putting together a History from 3 different database table

[osward]

Hello everyone,

Background:
cat table - holds the event details and has a unique "eid" field
user and user_temp table has the "eid" "user_id" and other fields, they are almost identical, the only difference is when user confirm the registeration of the event, it moves from user_temp to user

What I want to do is return a history telling the user all the events he had joined including confirm and not confirm

The return table would get data from the cat table showing the particuars of the events plus a colum tell the user that event he had confirmed or not

I know how to query for "eid" from user and user_temp,
my question is how am I going to pull out the data from the cat table by using the "eid" I got from both tables. I assume each would return an array of "eid" because user might join more than one event.

I think this is a many to one query that I have no idea how to accomplish
Please tell me how I could query the cat table and pull out the rows.

Thanks in advance

[MarkoKlacar]

Hey Osward,

sounds to me you need to look at some SQL joining, try looking at this tutorial and let me know how it went.

Cheers

[osward]

Hey Osward,

sounds to me you need to look at some SQL joining, try looking at this tutorial and let me know how it went.

Cheers

Hi MarkoKlacar

Thanks for the link and it's really resourceful. I think I need time to read it all through because I only understand a little bit html and php

I think I better rephase my orginal question to let everybody understand what I am trying to achieve and hopefully give me a kick start. I will certainly read through all the sql command.

First let me list the command field of the three tables in question

table          field1      field2     field3
cat             eid
user            eid        user_id    username
user_temp       eid        user_id    username

First, I will query user and user_temp for eid result
$result = $db->sql_query(SELECT eid FROM cat WHERE user_id=$user_id");

Then, I want to pass the return eid and query the cat table. Put result of the corresponding eid content in a html table

I am not sure how to use the result of the First step (eid) and query the cat table to return the data I need and put it in the html table.

Please give me a kick start if you could
Thanks in advance