|
|
Posted by Tarscher on 12/21/07 11:43
On 21 dec, 12:24, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> On 21 Dec, 11:18,Tarscher<tarsc...@gmail.com> wrote:
>
>
>
> > On 21 dec, 12:12, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
> > > On 21 Dec, 10:52,Tarscher<tarsc...@gmail.com> wrote:
>
> > > > On 21 dec, 11:45, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
> > > > > 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?"
>
> > > > sorry, a typo
>
> > > > INSERT INTO attendee (event_id, user_id) VALUES ($event_id,
> > > > session['user_id'])
>
> > > > I get the event_id via the url since the user does this per event.
> > > > eg
> > > > event1: 'will attend' 'will not attend'
> > > > event2: 'will attend' 'will not attend'
>
> > > > The 'will attend' and 'will not attend' links point to the sql query
> > > > inserting in attendee
>
> > > > I hope this helps
>
> > > No, that is not what I mean.
>
> > > You have a table attendee which contains events. Personally I would
> > > have an events table to contain the events.
>
> > > Now you tell us that the attendee table has events and attendees and
> > > it is possible for an attendee to say that they will not attend the
> > > event. I have to say that someone who will not attend an event will by
> > > definition not be an attendee!
>
> > > My question is, if for some reason you have all your events listed in
> > > the attendee table and the attendee has not put in there a record
> > > saying that he will or will not attend the event, how did the record
> > > with the event id and attendee id get in the table in the first place?
>
> > I have an event table and attendee table (events has many attendees).
> > The event_id in attendee points to the key of the event table.
> > event table: id, name, time
> > attendee table, id, user_id, event_id, present
>
> Things aren't as stated in your first post.
>
> However you STILL haven't answered my question.
>
> How does an attendeed get an entry in the attendee table against a
> particular event? You have suggested that the entry can be there
> before the prospective attendee has looked at the table, so HOW did it
> getthere?
Sorry, I have a hard time understanding your question.
The attendee can enter because he sees all available events (with
attend and not attend link behind): the one he attends, the one he
will not attend and the one he hasn't yet voted on (in this case there
is no attendee record for that user for that event.)
we have 3 cases:
- on the list of events the user clicks an event he previously said he
would attend to not attend. The attendees present record changes to 0
- on the list of events the user clicks an event he previously said he
would not attend to attend. The attendees present record changes to 1
- on the list of events the user clicks an event he hasn't 'voted' on
yet. An attendees record is created in the attendee table
i hope this helps
Navigation:
[Reply to this message]
|