quindi il problema è in questa riga?
Codice PHP:
<a href=\"".$city_url."\" class=\"citylist_city\">".$city['cityname']."";
if($show_city_adcount)
$a = "(0+".$city_accounts[$city['cityid']].")";
echo "".$a."</a>
secondo me è perchè $city_url è definito fuori dal ciclo while. Hai provato a spostare la sua assegnazione all'interno del secondo while? :
Codice PHP:
<table width="170" border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffCC">
<tr>
<td width="989" valign="top"><?php
// Show city list
if($location_sort)
{
$sort1 = "ORDER BY countryname";
$sort2 = "ORDER BY cityname";
}
else
{
$sort1 = "ORDER BY c.pos";
$sort2 = "ORDER BY ct.pos";
}
if ($show_region_adcount || $show_city_adcount)
{
// First get ads per city and country
$country_adcounts = array();
$city_adcounts = array();
$sql = "SELECT ct.cityid, c.countryid, COUNT(*) as adcnt
FROM $t_ads a
INNER JOIN $t_cities ct ON ct.cityid = a.cityid AND ($visibility_condn)
INNER JOIN $t_countries c ON ct.countryid = c.countryid
WHERE ct.enabled = '1' AND c.enabled = '1'
GROUP BY ct.cityid";
$res = mysql_query($sql) or die(mysql_error().$sql);
while($row=mysql_fetch_array($res))
{
$country_adcounts[$row['countryid']] += $row['adcnt'];
$city_adcounts[$row['cityid']] += $row['adcnt'];
}
}
$sql = "SELECT * FROM $t_countries c INNER JOIN $t_cities ct ON c.countryid = ct.countryid AND ct.enabled = '1' WHERE c.enabled = '1' GROUP BY c.countryid $sort1";
$resc = mysql_query($sql);
$country_count = mysql_num_rows($resc);
//$split_at = ($country_count%3?((int)($country_count/3))+2$country_count/3)+1);
$percol = floor($country_count/$location_cols);
$percolA = array();
for($i=1;$i<=$location_cols;$i++) $percolA[$i]=$percol+($i<=$country_count%$location_cols?1:0);
$i = 0; $j = 0;
$col = 1;
while($country = mysql_fetch_array($resc))
{
if($sef_urls) $country_url = "{$vbasedir}-$country[countryid]_" . RemoveBadURLChars($country['countryname']) . "/";
else $country_url = "?cityid=-$country[countryid]&lang=$xlang";
?>
<div>[url="<?php echo $country_url; ?>"]<?php echo $country['countryname']; ?> <?php if($show_region_adcount) echo "(".(0+$country_adcounts[$country['countryid']]).")"; ?>[/url]</div>
<?php
if($country['countryid'] == $xcountryid || !$expand_current_region_only)
{
$sql = "SELECT * FROM $t_cities ct WHERE countryid = $country[countryid] AND enabled = '1' $sort2";
$resct = mysql_query($sql);
while($city=mysql_fetch_array($resct))
{
$num_record = mysql_num_rows($resct);
$colonne = 2;
$tot_righe = $num_record/$colonne;
$i_x = 0;
$x_x = 0;
$k_x = 0;
$cell_width = floor(100/$colonne);
echo
'<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffCC">
<tr>';
while($city = mysql_fetch_array($resct))
{
/*********************/
if($sef_urls) $city_url = "{$vbasedir}$city[cityid]_" . RemoveBadURLChars($city['cityname']) . "/";
else $city_url = "?cityid=$city[cityid]&lang=$xlang";
/*********************/
$i_x++;
$k_x++;
$x_x++;
echo "<td width=\"".$cell_width."%\"><a href=\"".$city_url."\" class=\"citylist_city\">".$city['cityname']."";
if($show_city_adcount)
$a = "(0+".$city_accounts[$city['cityid']].")";
echo "".$a."</a> </td>";
if($i_x == $colonne)
{
echo'</tr>';
if($i_x == $colonne && (($x_x/$colonne) != $tot_righe))
{
echo'<tr>';
}
$i_x = 0;
}
}
if($colonne <= $x_x)
{
if(($k_x%$colonne) != 0)
{
$indice = $k_x;
while (($indice%$colonne) != 0 )
{
echo'<td> </td>';
$indice++;
}
if(($indice%$colonne) == 0 )
{
echo'</tr>';
}
}
}
else{
echo '</tr>';
}
echo '</table>';
?>
<?php
}
}
?>
<?php
}
?></td>
</tr>
</table>
$country_count/3)+1);
Rispondi quotando
