0) $page=(int) $_GET[page];
else $page=1;
if (strlen($_GET[city])>0)
{$q='SELECT register.cvrnr, register.name, register.city, register.postalcode, register.adress, register.startdate, register.startdate, register.industry, register.businessform, register.phone, register.fax, register.email
FROM register WHERE ((register.city)="'.utf8_decode($_GET[city]).'") ORDER BY register.name;';}
else
{echo("Empety search!
");include('include/footer.php');exit();}
$qp='&city='.$_GET[city];
$result = mysql_query($q) or die("Not working ".$q." with error ".mysql_error());
$k=1;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
$register[$k]['cvrnr']=utf8_encode($line[cvrnr]);$register[$k]['all']=$register[$k]['cvrnr'];
$register[$k]['name']=utf8_encode($line[name]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['name'];
$register[$k]['city']=utf8_encode($line[city]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['city'];
$register[$k]['index']=utf8_encode($line[postalcode]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['index'];
$register[$k]['adress']=utf8_encode($line[adress]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['adress'];
$register[$k]['startdate']=utf8_encode($line[startdate]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['startdate'];
$register[$k]['enddate']=utf8_encode($line[enddate]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['enddate'];
$register[$k]['industry']=utf8_encode($line[industry]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['industry'];
$register[$k]['businessform']=utf8_encode($line[businessform]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['businessform'];
$register[$k]['phone']=utf8_encode($line[phone]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['phone'];
$register[$k]['fax']=utf8_encode($line[fax]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['fax'];
$register[$k]['email']=utf8_encode($line[fax]);$register[$k]['all']=$register[$k]['all'].';'.$register[$k]['email'];
$k++;
}
mysql_close($link);
echo('List for city:'.$_GET[city].'
'.Count($register).' results
');
include('include/output.php');
include('include/footer.php');?>