Trying to add two different selects for same field but different purposes

[FUNKAM35]

$where= " province = '$province' ";
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num  FROM rental  WHERE  $where "),0) ;

<?php
$country=$_GET[country];
$province_numbers=array();
$additional = array();
$select="SELECT distinct province FROM rental WHERE country = '$country' order by province asc "; 
$results = mysql_query("$select", $link_id);
if(mysql_num_rows($results)>0){
 while ($query_data = mysql_fetch_row($results))
 {
$province=$query_data[0];
if(trim($province==""))continue;
$province=stripslashes($province);
echo "<li><a href=\"rentals.php?province=$province&country=$country\" title='$province $country'>$province</a></li>\n";
}
}
?>

Hi, I am trying to add the code above as an include.

 

However it conflicts with the main select on the page printed first above

 

Basically the page is listing all properties in one province, which works fine

 

but when I try and add the include it lists all the provinces but wont select the main province the page is about, it lists properties from the last province in the include not from the province in the where!

 

Hope this is clear I know what I mean

Many thanks in advance

 

[Ch0cu3r]

Rename the variable $province used in your include to a different name

[.josh]

sidenote:

 

if(trim($province==""))continue;

should be

 

if(trim($province)=="")continue;

[FUNKAM35]

Rename the variable $province used in your include to a different name

Thanks how do I do this, don't understand thanks

[Ch0cu3r]

You find each instance where $province is used in the included file, and then replace it with $new_var_name

 

new_var_name being the new name for the variable of your choosing. That is what I mean by renaming the variable.

[FUNKAM35]

I might be thick but how does it then know its selecting tge province?

[Ch0cu3r]

When renaming the variable, you are not changing its value. The value will still be the same.

 

The problem is the $province variable used in your include is overriding the $province variable used in the parent file. To prevent this you need to rename the $province variable used in the include file.

 

This will be the code for the include, with the $province variable being renamed to $theProvince

<?php
$country=$_GET[country];
$province_numbers=array();
$additional = array();
$select="SELECT distinct province FROM rental WHERE country = '$country' order by province asc "; 
$results = mysql_query("$select", $link_id);
if(mysql_num_rows($results)>0){
 while ($query_data = mysql_fetch_row($results))
 {
$theProvince=$query_data[0];
if(trim($theProvince==""))continue;
$theProvince=stripslashes($theProvince);
echo "<li><a href=\"rentals.php?province=$theProvince&country=$country\" title='$theProvince $country'>$theProvince</a></li>\n";
}
}
?>

The $province variable used in the parent file will not be affected by the code in the include file.

[FUNKAM35]

_{fantastic many thanks,will try this, could see the overriding bit but didnt know how to solve it, many thanks,will report back when tried.}

[FUNKAM35]

woohoo it works many thanks