<% require "constants.php3"; %> National Journal of Homeopathy - View Events
<% require "top_bar.txt" %>
 
<% require "left_nav.txt" %>
<% require "top_nav.txt" %>

<% $Quotes_Per_Page = 25; $countsql = "SELECT count(*) FROM events"; mysql_select_db($DB_NAME); $countrs = mysql_query($countsql); $countrec = mysql_fetch_array($countrs); if($countrs == false){ echo mysql_error(); } $TotalRecords = $countrec[cnt]; $TotalPages = intval($TotalRecords / $Quotes_Per_Page); if(($TotalRecords % $Quotes_Per_Page) != 0){ $TotalPages = $TotalPages + 1; } $pg = isset($pg) ? $pg : 0; if($pg == 0){ $offset = $pg * $Quotes_Per_Page; }else { $offset = ($pg) * $Quotes_Per_Page; } $sql = "SELECT * FROM events"; $sql .= " Order by eventdate desc LIMIT $offset, $Quotes_Per_Page"; mysql_select_db($DB_NAME); $rs = mysql_query($sql); %>

Event List

<% if (mysql_affected_rows($Connection) > 0) { %> <% while ($rec = mysql_fetch_array($rs)) { %> <% } } else { %> <% } %>
  Event Name Venue Topic Date
">More <% echo $rec["eventname"]; %> <% echo $rec["city"]; %> <% echo $rec["topic"]; %> <% echo $rec["eventdate"]; %>
No Entries found.
<% if($pg > 0) { %> < Prev <% } %>   <% for($i=0; $i<$TotalPages; $i++) { %> <% if($i != $pg) { %> <% } %> <% echo $i+1; %><% if($i != $pg) { %><% } %>   <% } %> <% if($pg<($TotalPages-1)) { %> Next >              <% } %>
 

Back

 

 
<% require "search.txt" %>