|
|
Posted by Captain Paralytic on 12/21/07 10:45
On 21 Dec, 10:36, Tarscher <tarsc...@gmail.com> wrote:
> On 21 dec, 11:13, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
>
>
> > 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?
>
> I indeed don't need the user_id since it is stored in the session. It
> was just to clarify that the query need to return 1 user.
>
> Via the session the user_id stored in the session.
>
> Regards
I don't understand how
"Via the session the user_id stored in the session."
answers the question
"How does the attendee's id get into the table against an event in the
first place?"
Navigation:
[Reply to this message]
|