Please stop responding to the list. Your problems are far to simple to
bother everyone on the list.
I have no idea what you mean when you say "locally" or "remote."
Basically your problem is that your script does not see any of the
variables. They are empty or not set. They are not getting passed from
the form. Who knows. php.ini configured differently locally than
remotely.
I assume that Server1 is local and server2 is remote. The problem is that
server2 probably hasn't got "register_globals" turned on.
Do this:
Change all your variables that you don't define in your script to this:
$GLOBALS[icao]
$GLOBALS[name]
$GLOBALS[country]
$GLOBALS[sort]
etc. Also, to see if they even exist, use this:
echo "<pre>";
print_r($_GET); // or use print_r($_POST) if you are using a POST instead of a GET method for your form
echo "</pre>";
This prints out all the variables stored.
I would also see if the variables are empty (which they are from what you
show). Put this line in your script:
if (empty($ton)) die("variable ton is empty ($ton). Global: ({$GLOBALS[ton]}) POST ({$_POST[ton]}) GET ({$_GET[ton]})");
If it dies there, it will print out the Global, Post and Get variables of
"ton" to see if they exist there. If they do, then you know you have to
change the variables in your script to those variables in order to get this
to work.
Do you know what version of PHP you are using locally and remotely? If
remotely is not above 4.0.0, then there is different values for _POST and
_GET.
Peter
On Sun, 27 Oct 2002, Seabird wrote:
> 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
>
---------------------------------------------------------------------------
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
