Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MikeydJR

    Display months from range of dates

    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 |...
  2. MikeydJR

    mod rewrite question

    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...
  3. MikeydJR

    Display months from range of dates

    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...
  4. MikeydJR

    How can I setup an alphanumeric validation rule

    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
  5. MikeydJR

    mod_auth_mysql makes me login twice

    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...
  6. MikeydJR

    enter start and end date and get all dates between

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

    Enter start and end date in a form, get all dates between

    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.
  8. MikeydJR

    enter start and end date and get all dates between

    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.

Part and Inventory Search

Back
Top