'.$country.''; echo '

'.$city.'

'; $query1 = "select name,name2,address,address2,post_code from shop where country = '$country' and city = '$city' order by name "; $result=$db->query($query1); foreach ($result as $row) { echo '

'.$row['name'].'

'; if ($row['name2']) echo $row['name2']; echo '

'.$row['address'].'

'; if ($row['address2']) echo '

'.$row['address2'].'

'; echo 'Post Code: '.$row['post_code']; } } include_once("../include/close.html"); ?>