LoadVariables('get'); $page_title = 'Famous '.$REWRITE[1].' '.str_replace("_"," ",ucwords($REWRITE[2]))." Page ".$REWRITE[4]; include('header.php'); //debug($REWRITE); $sql = "SELECT c_sign FROM celebrity WHERE c_sign != '' GROUP BY c_sign ORDER BY c_sign"; $do->doQuery($sql); while($row = $do->getRows()) { $zodiac_Array[] = $row; } switch (strtolower($REWRITE[1])) { case 'cancer': $imgSrc = 'cancer.jpg'; $date = "June 22 - July 23"; break; case 'capricorn': $imgSrc = 'capricorn.jpg'; $date = "Dec 22 - Jan 20"; break; case 'gemini': $imgSrc = 'gemini.jpg'; $date = "May 22 - June 21"; break; case 'leo': $imgSrc = 'leo.jpg'; $date = "July 24 - Aug 23"; break; case 'scorpio': $imgSrc = 'scorpio.jpg'; $date = "Oct 24 - Nov 22"; break; case 'sagittarius': $imgSrc = 'sagittarius.jpg'; $date = "Nov 23 - Dec 21"; break; case 'taurus': $imgSrc = 'taurus.jpg'; $date = "Apr 21 - May 21"; break; case 'virgo': $imgSrc = 'virgo.jpg'; $date = "Aug 24 - Sept 23"; break; case 'aquarius': $imgSrc = 'aquarius.jpg'; $date = "Jan 21 - Feb 19"; break; case 'aries': $imgSrc = 'aries.jpg'; echo "Mar 21 - Apr 20"; break; case 'pisces': $imgSrc = 'pisces.jpg'; $date = "Feb 20 - Mar 20"; break; case 'libra': $imgSrc = 'libra.jpg'; $date = "Sept 24 - Oct 23"; break; } ?>
" border="0" width="25" height="17">
doQuery($sql_descr); $sign_descr = $do->getRows(sd_descr); echo $sign_descr; ?>
Find a celeb Zodiac sign
Ex: Angelina Jolie (full name)
Most Popular Categories by Zodiac
$sign) { $sql = "SELECT c_category as mostPopular,COUNT(c_category) as counter FROM celebrity WHERE c_sign = '".$sign['c_sign']."' AND c_category != '' GROUP BY c_category ORDER BY counter DESC LIMIT 1"; $do->doQuery($sql); $row = $do->getRows(); ?>
" class="class_font link_month"> ( )
Famous
'; echo $pag->Pagination(); ?>
fields = array( 'c_name' => 'c_name', 'c_birth_day' => 'c_birth_day', 'c_birth_month' => 'c_birth_month', 'c_birth_year' => 'c_birth_year' ); $pag->tables = array('celebrity' => 'celebrity'); $where = " c_category = '".str_replace("_"," ",$REWRITE[2])."' AND c_name != '' AND c_sign = '".$REWRITE[1]."'"; $pag->where = " WHERE ".$where; $i = 0; $pag->order = ' ORDER BY c_name '; if($REWRITE[3] == 1) { $pag->per_page = 36; } else { $pag->per_page = 48; } $pag->columns = 3; $pag->nr_letters = 10; $pag->table_border = 0; $pag->displayInfo = true; $pag->date_format = 'F d, Y'; // June 04, 2006 $pag->link = "path=Zodiac_Category&sign=".$REWRITE[1]."&category=".str_replace("_"," ",$REWRITE[2])."&pic=".$REWRITE[3].""; $pag->displayLinks = 'bottom'; // top or bottom //$pag->functions = array('unhtmlentities'); $pag->HTML = '
/">
/" class="class_font link_month">FIELD[c_name]
FIELD[c_birth_day], FIELD[c_birth_year]
page_links; } ?>
 
">famous people in category with pictures.