Posted by Captain Paralytic on 12/21/07 10:13

On 21 Dec, 08:43, Tarscher <tarsc...@gmail.com> wrote:
> Hi all,
>
> I have events containing attendees (events has many attendees). The
> attendee table tells whether a user will attend the event or not. I
> want to build a query that returns all the different events to a user
> and if he will attend the event or not (or hasn't filled it in yet)
>
> the returned result could be something like:
>
> event.id attendees.user_id attendee.present
> 1 1 0
> 2 1
> 3 1 1
>
> Please note that attendee.present can be null if the user didn't yet
> tell if he would come to the event.
>
> Can this be done?
>
> thanks
> Stijn

And this has what to do with php?

You would be better to ask this in a database group.

However some questions:
If a user is querying the database to find if he will be attending the
event, why does his own ID need to be present in the output?
How does the attendee's id get into the table against an event in the
first place?

[Back to original message]