[PHP] Re: Best Approach

2008-01-23 Thread Al
PHP's error handler can be set up to automatically send emails. Send them to a dedicated mailbox and then check that mailbox every day. Miguel Guirao wrote: Hello fellow members of this list, There is a couple of rutinary tasks that our servers (different platforms) perform during the night. E

Re: [PHP] Re: Best Approach for Multiple Options

2003-09-03 Thread Vinoaj Vijeyakumaar
This is similar to a problem I faced yesterday. I have a table "property_facilities" which is essentially a table listing facilities available at different properties. The table structure looks something like: property_id facility_id --- --- 01 01 01

Re: [PHP] Re: Best Approach for Multiple Options

2003-09-03 Thread Marek Kilimajer
Use SET column type if you want. But there is a limit for how many members can the SET type have (64 in MySQL). I would go with the first approach. Kae Verens wrote: this will return true for something like 'pool|fireplace|fitness' mysql_query('select id from theTable where amenities like "%pool

[PHP] Re: Best Approach for Multiple Options

2003-09-03 Thread Kae Verens
Ralph Guzman wrote: The second approach is to store amenities as a text delimited string for each property in the facilities table. So if a certain property has a pool, fireplace and fitness center, I would have 'pool|fireplace|fitness' in the amenities field. I can then use PHP to explode or creat