$result=mysql_query("SELECT * FROM pagans WHERE (pagans.ctst='usca' and vhot='x' and uhot='x' and sponsor='x') ORDER BY wotw_name ASC ");
 
while ($row = mysql_fetch_array($result)) { 

$p_id =  $row['pagans.p_id'];
$dt_created = $row["dt_created"]; $d1 = date("n/j/y", strtotime($dt_created)); 
$dt_mod = $row["dt_mod"]; $d2 = date("n/j/y", strtotime($dt_mod)); 
$city = $row['city']; 
$ctst =  $row['ctst'];
$sponsor =  $row['sponsor'];
$v7 =  $row['v7'];
$wotw_name =  $row['wotw_name'];
$sunsign =  $row['sunsign'];
$url1 =  $row['url1'];
$city =  $row['city'];

 if ($url1 != "") 
  {$web = "<A HREF=$url1>WEB</A>";} 
 else {$web = "" ;}

 if ($v7 != "") 
  {$v72 = "<FONT COLOR=#003300><B>V7 Enhanced</B></FONT>";} 
 else {$v72 = "" ;}

 
$display_sponsors .= "

<font size=2><a href='http://www.witchvox.com/wotw/wwp_detail.html?id=".$row[p_id]."'><B>$wotw_name</B></a> ($city ) - </FONT>

";} 

print "<FONT SIZE=2><B>Active WitchVox Sponsors: </B></FONT><br><BLOCKQUOTE>$display_sponsors</BLOCKQUOTE>\n"; 



?>