Presentations

"") {$searchstring=$_GET['PPT_No'];} ?> Presentations "") { $query="SELECT * FROM presentations where ppt_no='$searchstring'"; $result=mysql_query($query); $num=mysql_num_rows($result); $searchstring = ""; } else { $query="SELECT * FROM presentations where press_date >=2012 ORDER BY press_date DESC LIMIT $from, $max_results"; $result=mysql_query($query); $num=mysql_num_rows($result); } $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num from presentations where press_date >=2012 ORDER BY press_date DESC"),0); $totpages = ceil($total_results / $max_results); if ($total_results == 0 || $num == 0) { $first = 0; $last = 0; $page = 1; } if ($page <= $totpages) { if ($totpages == 1) { $last = $num; $first = 1; } else { $first = $from + 1; if ($num == $max_results) { $last = $from + $max_results; } else { $last = $total_results; } } } } else { $AdvSearch = 1; } if(isset($_GET['Submit']) || $AdvSearch == 1) { $SearchString1=$_GET['optTopic']; $SearchString2=$_GET['txtPresenter']; $SearchString3=$_GET['txtTitle']; $SearchString4=$_GET['optType']; $SearchString5=$_GET['optDate1']; $SearchString6=$_GET['optDate2']; $max_results = 10; $from = (($page * $max_results) - $max_results); if ($SearchString1=="" && $SearchString2=="" && $SearchString2=="" && $SearchString3=="" && $SearchString4=="" && $SearchString5=="" && $SearchString6=="") {$query="SELECT * FROM presentations where press_date >=2012";} else { $query = "SELECT * FROM presentations WHERE substring(press_date,1,4) >= '$SearchString5'"; if ($SearchString1<>"") {$query= $query . " and topic like '%$SearchString1%'";} if ($SearchString2<>"") {$query= $query . " and presenter like '%$SearchString2%'";} if ($SearchString3<>"") {$query= $query . " and title like '%$SearchString3%'";} if ($SearchString4<>"") {$query= $query . " and category like '%$SearchString4%'";} if ($SearchString6<>"") {$query= $query . " and substring(press_date,1,4) <= '$SearchString6'";} } //$query = $query . " ORDER BY press_date"; $total_results = mysql_num_rows(mysql_query($query)); $totpages = ceil($total_results / $max_results); $query = $query . " ORDER BY press_date DESC LIMIT $from, $max_results"; $result=mysql_query($query); $num=mysql_num_rows($result); if ($total_results == 0 || $num == 0) { $first = 0; $last = 0; $page = 1; } if ($page <= $totpages) { if ($totpages == 1) { $last = $num; $first = 1; } else { $first = $from + 1; if ($num == $max_results) { $last = $from + $max_results; } else { $last = $total_results; } } } mysql_close(); } ?>

Search

Search Presentations
Topic:	Title or part of title: ">
Presenter: ">	Type:
Date between:	And:

Listing of Presentations
- of Presentations found, listed by date.

"") {?>" alt="icon"> "") {?> " target="_blank">Download () Sorry download unavailable


= 1){ echo "Page: "; for($k = 1; $k <= $totpages; $k++){ if(($page) == $k){ echo "$k "; } else { echo "$k "; } } } ?>