$user="Exotica";
$password="sheila";
$database="Exotica";
mysql_connect('mysql11.secureserver.net',$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM link where hide=0 order by id desc";
$result=mysql_query($query);
$num=mysql_numrows($result);
$query="SELECT * FROM link2 where hide=0";
$result2=mysql_query($query);
$query3="SELECT * FROM link_safe where hide=0 order by id desc";
$result3=mysql_query($query3);
$num3=mysql_numrows($result3);
$query="SELECT * FROM hidestuff";
$result4=mysql_query($query);
$hidestuff = mysql_result($result4,0,'hide');
mysql_close();
$i=0;
while (($i < 3) && ($hidestuff=='SHOW')) {
$url = mysql_result($result2,$i,'url');
$link = mysql_result($result2,$i,'link');
$text1 = mysql_result($result2,$i,'text1');
$text2 = mysql_result($result2,$i,'text2');
if (trim($text2)=='')
$text2 = '';
echo $text1.' '.$link.' '.$text2.'
';
$i++;
}
$i=0;
while (($i < $num) && ($hidestuff=='SHOW')) {
$url = mysql_result($result,$i,'url');
$link = mysql_result($result,$i,'link');
$text1 = mysql_result($result,$i,'text1');
$text2 = mysql_result($result,$i,'text2');
if (trim($text1)=='Where are there so many con-men in the')
$text1 = 'Why are there so many con-men in the';
if (trim($text1)=='')
$text1 = '';
if (trim($link)!='Bling?')
echo $text1.' '.$link.' '.$text2.'
';
$i++;
}
$i=0;
while ($i < $num3) {
$url = mysql_result($result3,$i,'url');
$link = mysql_result($result3,$i,'link');
$text1 = mysql_result($result3,$i,'text1');
$text2 = mysql_result($result3,$i,'text2');
if (trim($text2)=='')
$text2 = '';
echo $text1.' '.$link.' '.$text2.'
';
$i++;
}
?>