I've got my pagination script working, but now I need help trying to get it to extract data from 2 different sources.
The episode data is stored in table episodes, whilst the main table (where the info on airdates for episodes is stored in epdata2).
This is my code:
<?php
/***********************************
* PhpMyCoder Paginator *
* Created By PhpMyCoder *
* 2010 PhpMyCoder *
* ------------------------------- *
* You may use this code as long *
* as this notice stays intact and *
* the proper credit is given to *
* the author. *
***********************************/
?>
<head>
<title> Pagination Test Site</title>
<style type="text/css">
#nav { font: normal 13px/14px Arial, Helvetica, sans-serif; margin: 2px 0; }
#nav a { background: #EEE; border: 1px solid #DDD; color: #000080; padding: 1px 7px; text-decoration: none; }
#nav strong { background: #000080; border: 1px solid #DDD; color: #FFF; font-weight: normal; padding: 1px 7px; }
#nav span { background: #FFF; border: 1px solid #DDD; color: #999; padding: 1px 7px; }
</style>
</head>
<?php
//Require the file that contains the required classes
include("pmcPagination.php");
//PhpMyCoder Paginator
$paginator = new pmcPagination(20, "page");
//Connect to the database
mysql_connect("localhost","root","REDACTED");
//Select DB
mysql_select_db("mytvguide1");
//Select only results for today and future
$result = mysql_query("SELECT * FROM epdata2 WHERE airdate >= CURTIME() order by expiration ASC;");
//You can also add reuslts to paginate here
mysql_data_seek($queryresult,0) ; while($row = mysql_fetch_array($result))
{
$paginator->add(new paginationData($row['programme'],
$row['channel'],
$row['airdate'],
$row['expiration'],
$row['episode'],
$row['setreminder']));
}
?>
<?php
//Show the paginated results
$paginator->paginate ();
?><? include("footer1.php"); ?>
<?php
//Show the navigation
$paginator->navigation();
?>
Basically, what I'm trying to do is select certain records from the episodes table, and have them with certain airdates, stored in the datetime format, similar to this:
2010-04-26 13:00:00 13:30:00 Episode 1
2010-05-04 00:15:00 00:50:00 Episode 2
I'm trying to get it to remove the record after it expires (i.e. hide it) - one bug I found today was the event disappeared during it, at 10:09am it did not show, despite the fact the event expired at 10:30am. (this is UK time, GMT).
Anyone able to help me please, I would much appreciate this?