I also provide my searchform here. The problem I have is that everything
works when run on my localhost (which is my testing location before upload.
I have the exact same code local and remote.

My searchform should pass the code..... here it comes:

  <form method=GET action=aviation/result.php target=frameData>
        <td width="122"></td>
        <td ></td>
        <td class="text">Icao code:</td>
        <td > <input name=icao type=text class=search size="3"
        <td class="text" >Airline name:</td>
        <td > <input type=text name=name class=search> <br> </td>
        <td class="text" >Country:</td>
        <td > <select name=country class=search>
 $query = "SELECT DISTINCT(Field3) FROM $table ORDER BY Field3";
 $result = mysql_query($query) or die("Error in query");

 while($row = mysql_fetch_assoc($result))
  print "<option>".$row['Field3']."</option>\n";
          </select> </td>
        <td class="text" >Search Criteria:</td>
        <td> <select name=ton>
            <option value=AND>AND</option>
            <option value=OR>OR</option>
          </select> </td>
        <td><span class="text">Sort by:</span> </td>
        <td> <select name="sort">
            <option value=Field1>Designator</option>
            <option value=Field2>Name</option>
            <option value=Field3>Country</option>
          </select> </td>
      <tr bgcolor="#FFFFFF">
        <td> <input type=submit value="Search these criteria"> </td>
      <tr bgcolor="#CCCCCC">
        <td colspan=2 class=grey> <div align="center"
class="signature">***no wildcards permitted***</div></td>


Thanx, and excuse my newbie ignorance,

Attitude is Everything!
But Remember, Attitudes are Contagious!
Is Yours worth Catching????
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
> > MySQL Error: You have an error in your SQL syntax near 'Field2 LIKE
> '%%'
> > Field3 LIKE '%%' ORDER BY ' at line 2
> > SQL: SELECT * FROM airline_a WHERE Field1 LIKE '%%' Field2 LIKE '%%'
> > Field3
> > LIKE '%%' ORDER BY
> You need some ANDs between each of your field LIKE '%%' clauses.
> WHERE field1 LIKE '%%' and field2 LIKE '%%' ...
> ---John Holmes...

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to