Re: [PHP-DB] retrieve enum values

2005-04-14 Thread Aman Patel
M_COLUMN ); eval( "\$the_array = array $value;" ); // let eval do all the parsing work. return $the_array; } - Aman Patel, Sys Admin / Database / Web Developer, International Outreach x4076 -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED]

Re: [PHP-DB] Newbie: phpmyadmin and searching Unix Timestamps

2005-03-22 Thread Aman Patel
Graham Anderson wrote: is there an easy way to search through unixtimestamps ? like Select * from SessionTable Where ConvertToMonthFunction(unixTimeStamp) = 'March' ? be great to use the Variable function within phpmyAdmin many thanks g On Mysql (works on 4.0 atleast), you can use the FROM_UNIXTI

Re: [PHP-DB] Urgent DATA help needed

2005-03-22 Thread Aman Patel
Chris Payne wrote: Could anyone show me an example of how to do this? So to take 2001-07-05 and add 3 days to it? To use SQL to do this: > SELECT FROM_DAYS((TO_DAYS('2001-07-05') + 3)); The TO_DAYS and FROM_DAYS are nice functions to use when you are fildling with dates as numbers (i.e. doing a