$user="Exotica";
$password="Sheila69";
$database="Exotica";
mysql_connect('mysql11.secureserver.net',$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM newspa where hide=0 order by text";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < 10) {
$url = mysql_result($result,$i,'url');
//$link = mysql_result($result,$i,'link');
$text = mysql_result($result,$i,'text');
$city = mysql_result($result,$i,'city');
if (trim($text)=='')
$text = '';
if (($text!='') && ($text!='Queensway Spa')) {
echo ' '.$text.'
';
}
$i++;
}
?>