Search/Display problem

[salsa_dancer]

Hello, I have recently moved to a new server and have uploaded my website to it including the php script that was previously working on the old server. I haven't changed anything and I have a search option on the website to access a database of schools.

When I now use the search option it no longer works as it did and just displays the information direct from the database with no search criteria set. Could someone tell me what is missing from the code as I would have thought it would just copy over and work???

              <?php
if (isset($mode) && ($mode = "full")){
	$limiter = 100;
} else {
	$limiter = 50;
}
{

$query = "SELECT * FROM Addresses WHERE areas LIKE '%$city%' && Salutation LIKE '%$city2%' ORDER BY Rank ASC LIMIT 0,$limiter";
$numero = mysql_query($query);
$numero_rows = mysql_num_rows($numero);

/* Get data from dBase */
$result = mysql_query( $query, $link );
$num_rows = mysql_num_rows( $result );
echo "<font face=\"Arial, Helvetica, sans-serif\" size=\"2\" color=\"#000000\">";
if ($num_rows == 0){
	echo "No results were found, for this search. Please try different criteria.";
} else {
	echo "<br>Displaying $num_rows results, out of a possible $numero_rows.";
	if ($num_rows != $numero_rows){
		echo "\nView the complete result set <a href=\"$PHP_SELF?mode=fullcity=$areas&Salutation=$city2\"><font color=\"#008000\">here</font></a>.</font>";
	}
}
echo "\n<br>\n";
while ($data = mysql_fetch_object( $result )) {
	$data++;
?>

[devinemke]

i suspect that your old server had register_globals ON and the new one has it OFF. read up on Using Register Globals.

[salsa_dancer]

Ok - thanks. Reading up on this as we speak. Is there anyone that can suggest what I need to change so that I can get this working ASAP whilst I learn all about it?

Thank you.

[AdamBrill]

Try changing this:

$query = "SELECT * FROM Addresses WHERE areas LIKE '%$city%' && Salutation LIKE '%$city2%' ORDER BY Rank ASC LIMIT 0,$limiter";

to this:

$query = "SELECT * FROM Addresses WHERE areas LIKE '%$city%' && Salutation LIKE '%" . $_REQUEST['city2'] . "%' ORDER BY Rank ASC LIMIT 0,$limiter";

Also, you didn't connect to the database, so that could be your problem.

In order to help you with your debugging, you may want to change this:

$numero = mysql_query($query); 

to this:

$numero = mysql_query($query) or die(mysql_error());