|
|
Posted by Paul Lautman on 12/21/07 22:19
Betikci Boris 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..
Do you know what you are talking about?
Navigation:
[Reply to this message]
|