Hi Peter I understand your frustration, but how come that it works fine on my localhost, prosessing the exact same code?? I thought it worked because it works fine locally.... What is the differense in my code posted locally and remote? Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching???? "Peter Beckman" <beckman@purplecow.com> wrote in message 20021027172628.I64513-100000@thermonuclear.org">news:20021027172628.I64513-100000@thermonuclear.org... > It seems to me you have no idea what you are doing. You really need to > learn how to troubleshoot your code, as this is a very simple problem to > fix. It's not your code. The variables you put in your SQL are empty. > > Your code: > > $query = "SELECT * FROM $table WHERE Field1 LIKE '%$icao%' $ton > Field2 LIKE '%$name%' $ton > Field3 LIKE '%$country%' > ORDER BY $sort"; > > Problem: > > $ton should equal "AND" or "OR" but it doesn't equal anything. In fact, > all of your variables are either empty or not set. > > You are trying to get: > > Select * from table where field1 like '%something%' AND > field2 like '%something%' AND > field3 like '%something%' > order by field1 > > But since $ton is empty you are executing this: > > select * from airline_a where field1 like '%%' > field2 like '%%' > field3 like '%%' > order by > > Which is COMPLETELY INVALID. Notice no "AND" statements between fields? > > I won't publicly flog you, but please don't respond. I believe this list > is for help with more advanced issues, not "how to properly write an SQL > command and troubleshoot your code for you." > > Peter > > On Sun, 27 Oct 2002, Seabird wrote: > > > My error came out like this: > > > > 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 > > > > Why does it not do this at my localhost?? I have the % around my code so > > that it searches correctly.... right? Or should I clean up my code?? > > Jacco > > > > > > -- > > http://seabird.jmtech.ca > > > > Attitude is Everything! > > But Remember, Attitudes are Contagious! > > Is Yours worth Catching???? > > "Peter Beckman" <beckman@purplecow.com> wrote in message > > 20021027151406.T64513-100000@thermonuclear.org">news:20021027151406.T64513-100000@thermonuclear.org... > > > That's some nasty code.... > > > > > > Two things: > > > > > > 1. What is $ton in your query? > > > > > > 2. Change your mysql_query row to this: > > > > > > $result = mysql_query($query) or die("MySQL Error: > > ".mysql_error()."<br>SQL: $query"); > > > > > > So when your query dies, you'll know why. > > > > > > Peter > > > > > > On Sun, 27 Oct 2002, Seabird wrote: > > > > > > > sorry for my "furry" message before. > > > > > > > > I search a DB in multiple search fields and my result code looks like > > this: > > > > > > > > <?PHP > > > > $db=test; > > > > $table=airline_a; > > > > > > > > if (! $link) > > > > die( "couldn't connect"); > > > > mysql_select_db($db) > > > > or die ("won't open test:".mysql_error() ); > > > > > > > > > > > > $db_res=mysql_list_dbs($link); > > > > $num=mysql_num_rows($db_res); > > > > for($x=0; $x<$num; $x++) > > > > > > > > > > > > $db_res=mysql_list_tables("$db",$link); > > > > $num=mysql_num_rows($db_res); > > > > for($x=0; $x<$num; $x++) > > > > > > > > > > > > > > > > $count = mysql_query("SELECT * FROM $table");//selects all rows > > > > $total = mysql_num_rows ($count);//counts the selected rows > > > > > > > > $query = "SELECT * FROM $table WHERE Field1 LIKE '%$icao%' $ton > > > > Field2 LIKE '%$name%' $ton > > > > Field3 LIKE '%$country%' > > > > ORDER BY $sort"; > > > > $result = mysql_query($query) or die("Error in > > > > query");//////////////////////////so this is the error I > > > > get///////////////// > > > > $total = mysql_num_rows ($result);//counts the selected rows > > > > print "<span class=text>your search returned ".$total." matches</span>"; > > > > > > > > print "<table border=1>\n"; > > > > print "<tr><td class=grey>Icao</td><td class=grey>Name > > (Location)</td><td > > > > class=grey>Country</td></tr>"; > > > > while($row = mysql_fetch_assoc($result)){ > > > > print "<tr>\n" > > > > ."<td class=white>" . $row['Field1'] . "</td>\n" > > > > ."<td class=white>" . $row['Field2'] . "</td>\n" > > > > ."<td class=white>" . $row['Field3'] . " </td>\n" > > > > ; > > > > } > > > > > > > > print "</tr></table>"; > > > > ?> > > > > > > > > > > > > The problem I have is that my setup on my localhost and my remote are > > > > identical (I think) and the files are the same. So where does it go > > wrong. > > > > All I get as error is 'Error in query' which doesn't tell me much. > > Please > > > > help me... > > > > > > > > Jacco > > > > -- > > > > http://seabird.jmtech.ca > > > > > > > > Attitude is Everything! > > > > But Remember, Attitudes are Contagious! > > > > Is Yours worth Catching???? > > > > "John W. Holmes" <holmes072000@charter.net> wrote in message > > > > 002801c27dc0$844bfb00$7c02a8c0@coconut">news:002801c27dc0$844bfb00$7c02a8c0@coconut... > > > > > > Hi everyone, > > > > > > I'm using a MySQL DB and a search form. Eveery thing works fine, but > > > > > when > > > > > > I > > > > > > upload, it has a Error in query. I checked all the little details > > but > > > > > > can't > > > > > > find out why? Any ideas are welcome. > > > > > > > > > > > > Jacco > > > > > > > > > > This one is an easy problem to fix. All you have to do is find the > > error > > > > > and correct what's causing the problem. > > > > > > > > > > Hope that helps. > > > > > > > > > > ---John Holmes... > > > > > > > > > > PS: If you found my answer worthless, it was about as helpful as your > > > > > question. What error? What versions of PHP and MySQL? What's your > > > > > code??? > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > PHP Database Mailing List (http://www.php.net/) > > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > -------------------------------------------------------------------------- > > - > > > Peter Beckman Systems Engineer, Fairfax Cable Access > > Corporation > > > beckman@purplecow.com > > http://www.purplecow.com/ > > > -------------------------------------------------------------------------- > > - > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -------------------------------------------------------------------------- - > Peter Beckman Systems Engineer, Fairfax Cable Access Corporation > beckman@purplecow.com http://www.purplecow.com/ > -------------------------------------------------------------------------- - > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
