|
|
Posted by Betikci Boris on 12/21/07 17:13
On Dec 21, 7:09 pm, Betikci Boris <pard...@gmail.com> wrote:
> On Dec 21, 10:43 am, 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
>
> There is no need to define events table, define attended events in
> users table in arrays;
>
> $events_attended=array("1","5","3"); and goes so on..- Hide quoted text -
>
> - Show quoted text -
Addition: You may want to store the date store date as the key... or
use more complex multi-dimentional array to store all -date -event -
result, etc..
Navigation:
[Reply to this message]
|