Professional Web Applications Themes

Advanced search form - Macromedia Dynamic HTML

Hi, can anyone advise or point me towards a tutorial to create an Advanced search form. I would like to add to an existing form (consists of a single text field for a name) an option to search by one of, 2 or 3 parameters using an array of radio buttons (All, Current, Past). I am using MySql and PHP. I am unsure how to modify the existing Recordset to take the extra parameters into account. Any help would be greatly appreciated. John...

Sponsored Links
  1. #1

    Default Advanced search form

    Hi,
    can anyone advise or point me towards a tutorial to create an Advanced search
    form. I would like to add to an existing form (consists of a single text field
    for a name) an option to search by one of, 2 or 3 parameters using an array of
    radio buttons (All, Current, Past). I am using MySql and PHP. I am unsure how
    to modify the existing Recordset to take the extra parameters into account.
    Any help would be greatly appreciated.
    John

    Sponsored Links
    JohnA54 Guest

  2. #2

    Default Re: Advanced search form

    You need to build a dynamic SQL query string from the selected options. In the
    recordset add a If $_POST['radioButtons'] == "option" {
    $codeforSQL = "Select * From Table1 Where column1 = 'paramter'
    }
    You can do a lot by modifying the basic DW querys this is really simple but
    search around for dynamic SQL

    MikeL7 Guest

  3. #3

    Default Re: Advanced search form

    Thanks for the reply MikeL7,
    I will look up further info. Basic SQL I am fairly ok with but this looks a bit more interesting.
    Thanks again
    John
    JohnA54 Guest

Similar Threads

  1. Advanced search
    By lillyag in forum Macromedia Dynamic HTML
    Replies: 2
    Last Post: April 2nd, 01:13 PM
  2. Need help with advanced search please!!
    By EnergyFed in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: June 27th, 01:36 PM
  3. advanced search with php
    By Maceomedia in forum Dreamweaver AppDev
    Replies: 0
    Last Post: May 17th, 08:12 AM
  4. advanced search
    By rajesh in forum Dreamweaver AppDev
    Replies: 2
    Last Post: March 1st, 09:24 PM

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