Searching mulitple tables

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Searching mulitple tables

    i have a simple search page which i want to search on 2 tables (with
    different structure ) is there any way to combine the results rather than
    having 2 seperate recordsets and 2 looped regions ?

    help appreciated

    ads


    ceaseanddesist Guest

  2. Similar Questions and Discussions

    1. Mulitple Domains
      If we purchase Flash Media Server 2 Professional, can that be used on multiple domains ?
    2. Searching two different tables using WA QueryBuilder
      Hi. Im using DW 2004, Access 2003, ASP/VBScript together with WebAssist QueryBuilder extension, latest version. I am trying to make a simple...
    3. How do I Query mulitple datasources?
      Here is what I have and what I need to do... 1. I have multiple dabases with financial transactions. All are based on the same table structure. ...
    4. Mulitple Table Query Help
      I'm not sure the follow multiple table query is the right way to do what I need to do although it seems to be working: $php_SQL = "SELECT * "....
    5. mulitple update queries from one button
      Is it possible to launch several update quries from one button on my form?
  3. #2

    Default Re: Searching mulitple tables

    Hi, did you tried this: $query_Recordset1 = "SELECT * FROM table1, table2 WHERE table1.text LIKE '%$input%' OR table2.text LIKE '%$input%'";
    Let me know, maybe I can help you
    Gustonez Guest

Posting Permissions

  • You may not post new threads
  • You may 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