"); } ?>

Press & News

CURRENT_DATE()) AND status = 'active' AND job_offer = 0 AND story_id = '{$_GET['id']}'"; #echo($sql); $result=mysql_query($sql, $conn) or die(mysql_error()); if(mysql_num_rows($result)) { $resultcount=1; $lastmatchingid=$_GET['id']; //forced result } } if(!$resultcount) { $where=" WHERE status = 'active' AND job_offer = 0"; if($_POST) { if($_POST['search']) { if(!get_magic_quotes_gpc ()) { $_POST['search']=addslashes($_POST['search']); } $textsearch="MATCH (data) AGAINST ('{$_POST['search']}')"; $textlike=''; foreach(split(' ',$_POST['search']) as $key=>$val) { if($val=trim($val)) { $textlike.=" OR data LIKE '%$val%'"; } } $score=",$textsearch AS score"; $where.=($where?' AND':' WHERE')." in_story_id = story_id AND ($textsearch$textlike)"; } } $dateclause=array(" publish_date <= CURRENT_DATE() AND (archive_date = '0000-00-00' OR archive_date > CURRENT_DATE()) AND (kill_date = '0000-00-00' OR kill_date > CURRENT_DATE())"," (archive_date != '0000-00-00' AND archive_date <= CURRENT_DATE() AND (kill_date = '0000-00-00' OR kill_date > CURRENT_DATE()))"); $datesection=array("","

Archived Stories

"); foreach($dateclause as $key=>$val) { $extrawhere=($where?' AND':' WHERE').$val; $matchingout[$key]=array(); $matchingscore[$key]=array(); $sql="SELECT *$score FROM stories,story_chunks$where$extrawhere ORDER BY story_id"; #echo($sql); $result=mysql_query($sql, $conn) or die(mysql_error()); if(mysql_num_rows($result)) { while($row=mysql_fetch_array($result, MYSQL_ASSOC)) { $sql="SELECT * FROM story_chunks WHERE in_story_id='{$row['story_id']}' AND position = 1"; $result2=mysql_query($sql, $conn) or die(mysql_error()); $row2=mysql_fetch_array($result2, MYSQL_ASSOC); $lastmatchingid=$row['story_id'];//danger will robinson $matchingout[$key][$row['story_id']]='

'.$row2['data'].'

'; $matchingscore[$key][$row['story_id']]+=$row['score']; } array_multisort ($matchingscore[$key],SORT_DESC,$matchingout[$key]); #print_r($matchingscore); } $resultcount+=count($matchingscore[$key]); } } if(!$resultcount) { echo('

Sorry, there are no results matching your search

---

'); }elseif($resultcount==1) { if(!$_GET['id']) { echo('

One result found

'); } echo('

---

'); include ('../newsobjectsread.php'); $story=new news_story($lastmatchingid,$conn);//danger will robinson - see above $story->display(); }else { echo('

'.$resultcount.' results found

---

'); /* foreach($dateclause as $key=>$val) { if(count($matchingout[$key])) { echo($datesection[$key]); echo('

'); foreach($matchingout[$key] as $key1=>$val1) { echo("$val1"); } echo('

'); } }*/ echo('

'); foreach($dateclause as $key=>$val) { if(count($matchingout[$key])) { #echo($datesection[$key]); foreach($matchingout[$key] as $key1=>$val1) { echo("$val1"); } } } echo('

'); } ############################################### }else { ?>