Re: [PHP] Date problem

2002-12-03 Thread James Coates
At 19:32 03/12/2002 +0800, Jason Wong wrote: Assuming the column holding the the birthday is called 'birthday': [snip] Many thanks! > * give me actors whose birthdays fall between two dates (ie: Aries) This one is easy, use the BETWEEN clause in your SELECT statement. Consult manual for det

RE: [PHP] Date problem

2002-12-03 Thread James Coates
At 18:44 02/12/2002 -0500, John W. Holmes wrote: > Can you help me for this ? Yeah, I already did: Perhaps you could throw a clue my way, in that case. I have an actor database (mySQL again) which has actor dates of birth in '-MM-DD' format. I want to be able to query against that ignori

RE: [PHP] Bizarreness with htmlentities() and other things

2002-11-28 Thread James Coates
At 14:07 28/11/2002 +, Rich Gray wrote: There is a bug in PHP for the capitalisation problem Sounds like an internal Microsoft memo. :-) http://bugs.php.net/bug.php?id=14655 If you check the link then a workaround was posted by someone. Cool. If I've got that right, it'll be fine on th

Re: [PHP] editing .htaccess / .htpasswrd

2002-11-28 Thread James Coates
At 15:46 28/11/2002 +0200, Mika Tuupola wrote: > into the .htpsswrd file. Answering to an old mail in here but noticed you didn't get any replies yet. You should check File_HtAccess and File_Passwd packages at PEAR: I quite like class.htpasswd - http://www.hotscripts.c

[PHP] Bizarreness with htmlentities() and other things

2002-11-28 Thread James Coates
Hello! I'm currently doing some work that requires a mySQL database of actor names. For all my actors, I have three columns; first_name, last_name and between_name. Because between_name can be written in many ways ("Peter van Wibble" or "Fred d'Angelo), and the French have a habit of writing th