Recent content by MikeydJR

Thanks, that's perfect. Here's my final code: SELECT DATE_FORMAT(datum, '%b %Y' ) as viewmonth, DATE_FORMAT(datum, '%Y-%m' ) as linkmonth FROM table GROUP BY YEAR(datum), MONTH(datum) ORDER BY YEAR(datum) DESC, MONTH(datum) DESC Apache: 2.0.52 | MySQL: 4.1.20 | PHP: 4.3.9 | MS Access 2002 |...

I am new to mod_rewrite, but I need to redirect http://www.mysite.com/chf/grantcal.php?v=day&d=2007-10-01 to http://www.mysite.com/chf/index.php?mod=cal&d=2007-10-01 I tried this in htaccess in the /chf directory: Options +FollowSymlinks RewriteEngine on RewriteRule...

I have a MySQL table with data containing a date field. I need to take the start and last dates and list the months in the range. For example: 2007-08-01 2007-08-25 2007-09-15 2007-09-28 2007-10-06 2007-10-25 Would list: Oct 2007 Sept 2007 Aug 2007 These will be links to a list of data from...

I'm using access 2002, and I need to set a validation rule in a table so that the only charcters allowed in the text field are: a-z (case-insensitive) 0-9 these characters + " and spaces. Anything else will return an error. Not quite sure how to set this. TIA

I have apache 1.3.22, and I'm trying to use mod_auth_mysql to protect some files. However, it always makes me login twice. Here's my htaccess file: AuthName "Test Folder" AuthType Basic Auth_MySQL_DB http_auth Auth_MySQL_Password_Table mysql_auth Auth_MySQL_Encryption_Types Plaintext...

Thanks, Steve. I think I will repost in the VBA forum. I need the resulting dates to be in a table.

I'm trying to create a form where I enter a start date and end date and create/update a table with all dates between EX: start date 8/1/03 end date 8/7/03 Returns Table named ALLDATES datefield 8/1/03 8/2/03 8/3/03 8/4/03 8/5/03 8/6/03 8/7/03 TIA for any advice.

I'm trying to create a form where I enter a start date and end date and get all dates between EX: start date 8/1/03 end date 8/7/03 Returns 8/1/03 8/2/03 8/3/03 8/4/03 8/5/03 8/6/03 8/7/03 TIA for any advice.