Professional Web Applications Themes

IF and OR in a query - PHP Development

Having a little trouble returning the result I'm looking for in a query and thought I'd ask a question here. I have an input screen with a pull down menu to capture vacation activity within a given month as well as capture overlap onto another month. For example, if you're taking vacation between June 25 and July 4, the input would be 'junjul' if the days off were July 4 through 10, the input would be 'jul' and if the days off happened to be July 25 through August 5, the input would fall under 'julaug' with the idea being ...

  1. #1

    Default IF and OR in a query

    Having a little trouble returning the result I'm looking for in a
    query and thought I'd ask a question here.

    I have an input screen with a pull down menu to capture vacation
    activity within a given month as well as capture overlap onto another
    month. For example, if you're taking vacation between June 25 and
    July 4, the input would be 'junjul' if the days off were July 4
    through 10, the input would be 'jul' and if the days off happened to
    be July 25 through August 5, the input would fall under 'julaug' with
    the idea being that the query captures any vacation for the month of
    July but also sends back info for any overlapping month vacation.
    Also, if you did a query for the month of June or August, that
    overlapping vacation would show as well. I did this very effectively
    in Access once and am trying duplicate it with PHP.

    So a question becomes, IF jul (is selected in the query for the month
    of July) THEN return any data for junjul AND julaug if they were used
    on the input form and have that data returned under a July query.

    Any thoughts?
    Chris Guest

  2. #2

    Default Re: IF and OR in a query

    Another way of 'saying' that might be

    IF jul THEN INCLUDE junjul AND julaug
    (in the resultant query)

    On Sun, 05 Jun 2005 04:11:25 -0700, Chris <coverland914 >
    wrote:
     

    Chris Guest

  3. #3

    Default Re: IF and OR in a query

    Hello Chris,

    Use: INSTR(columnname,'jul') > 0

    This will evaluate to a positive integer when 'jul' is in the search column
    or zero when it is not found.

    Joseph Melnick
    JM Web Consultants
    http://www.jphp.com







    "Chris" <coverland914 > wrote in message
    news:com... 
    >[/ref]


    Joseph Guest

Similar Threads

  1. Query of Queries on query New type query
    By david_h in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 6th, 08:55 PM
  2. Replies: 1
    Last Post: July 2nd, 09:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139