query($query); if ( $db->num_rows($parent_result) ) { $p = $db->fetch_assoc($parent_result); //if there was a match, then load the "parent" actor sort_by into $_REQUEST $_REQUEST['star']= $p['parent_sort_by']; //default alias & alias_search to the actor's name. if typo, then convert //search to "search for actor name". it's just easier to work with. $alias_name = $alias_search_name = $p['alias']; //temp override this 2/2009 for new design //if ($p['typo_or_synonym']=='t') { // $alias_search_name = 'Search for "' . $p['alias'] . '"'; //} } } // take star from post info & see if there is a match $query = "select * from entries where actor_sort_by='" . strtolower($_REQUEST['star']) . "' and (status='live');"; $result = $db->query($query); $entry_count = $db->num_rows($result); //if no match, redirect out of here if ( $entry_count == 0 ) { header( "Location: http://www.hardlyfamous.com/" ); exit; } //now get some global-ish stuff from the array then rewind $stuff = $db->fetch_assoc($result); $actor_name = $stuff['actor_first'].' '.$stuff['actor_last']; $actor_first = addslashes($stuff['actor_first']); //used only for select below $actor_last = addslashes($stuff['actor_last']); //used only for select below $actor_sort_by = $stuff['actor_sort_by']; //used for showing photo $letter = $stuff['actor_file_under']; $category = $stuff['category']; //calculate seed for anchoring aliases, alias+parent+month $seed = $p['id']+$stuff['id']+date("m"); mysql_data_seek( $result, 0 ); //now rewind // create the menu box of links to other stars with same letter $query = "select max(actor_first) as actor_first,max(actor_last) as actor_last,actor_sort_by,count(*) as count from entries where actor_file_under='$letter' and (status='live' or status='unconfirmed') group by actor_sort_by order by actor_sort_by;"; $menu_result = $db->query($query); $actor_count = $db->num_rows($menu_result); // check if there are aliases for this star $query = "select * from aliases where parent_sort_by='".$_REQUEST['star']."' order by rand($seed) limit 2"; $alias_result = $db->query($query); $alias_count = $db->num_rows($alias_result); //$alias_count=0; //remove when uncommenting //set global variables $gbl->page_title= ($alias_name ? $alias_name : $actor_name) . " -- Before They Were Famous"; $gbl->meta_key= ($alias_name ? $alias_name : $actor_name) . '\'s first job, before they were famous'; $gbl->meta_desc= 'See what jobs ' . ($alias_name ? $alias_name : $actor_name) . ' had before becoming famous.'; $gbl->show_ads='none'; $gbl->getHeader(); //$db->debug = 1; if ( !$p['typo_or_synonym']=='t' ) { $temp_footer_name = ($alias_name && $p['typo_or_synonym']=='s' ? $alias_name : $actor_name); $gbl->footer_override = "This $temp_footer_name trivia and all celebrity trivia on hardlyfamous.com is provided for entertainment purposes only. With your help, we have assembled the largest online collection of jobs that celebrities had before they were famous, but as you can imagine, this type of celebrity trivia is prone to rumor and gossip. We go to great lengths to corroborate entries, but we do not guarantee the accuracy of this $temp_footer_name trivia or any other content. Please help by reporting rumors or corrections for $temp_footer_name trivia or any celebrities before they were famous."; } $old_actor = ''; // select previous link $query = "select actor_sort_by,actor_first,actor_last from entries where (status='live') and actor_sort_by < '".$_REQUEST['star']."' order by actor_sort_by desc limit 1"; $prev_menu_result = $db->query($query); $prev_menu_array = $db->fetch_assoc($prev_menu_result); $prev_link = ($db->num_rows($prev_menu_result)) ? "/stars/".$prev_menu_array['actor_sort_by'] : "/"; $prev_name = ($db->num_rows($prev_menu_result)) ? $prev_menu_array['actor_first'].' '.$prev_menu_array['actor_last'] : "Menu"; // select next link $query = "select actor_sort_by,actor_first,actor_last from entries where (status='live') and actor_sort_by > '".$_REQUEST['star']."' order by actor_sort_by limit 1;"; $next_menu_result = $db->query($query); $next_menu_array = $db->fetch_assoc($next_menu_result); $next_link = ($db->num_rows($next_menu_result)) ? "/stars/".$next_menu_array['actor_sort_by'] : "/"; $next_name = ($db->num_rows($next_menu_result)) ? $next_menu_array['actor_first'].' '.$next_menu_array['actor_last'] : "Menu"; ?>
<?= $actor_name ?>

Before they were famous...  «   » 

Did you mean: '.$p['parent'].'?

'; } ?>
Q:
What did do before becoming famous?
 
fetch_assoc($result)) { ?>
A:
Go To Next Page



View More Stars:   fetch_assoc($menu_result)) { $big_menu_string .= ''.$m['actor_first'].' '.$m['actor_last'].''; $big_menu_string .= " · "; } echo $big_menu_string; ?> Related Searches: fetch_assoc($alias_result)) { echo ''.$a['alias'].' · '; } //if we are on an alias page, then show the parent link too // if ( $alias_name ) { // echo ''.$p['parent'].''; // } ?> Go to "next_letter[$letter]) ?>" Stars
getFooter(); ?>