DATEDIFF Question

Posted on 16th Feb 2014 07:03 pm by admin

First time post, and of course it is a help question.

I am using a WP plug-in to display previous and next games in a season. (Leaguemanager is the plug-in name - Link http://wordpress.org/extend/plugins/leaguemanager/ ). The challenge I am having is that the previous game only displays the first game of the season, not the actual previous game...

The following code is pulled from the shortcode.php file in the lib folder of the plugin.

Here is the code for the next game which works...

$next_matches = $leaguemanager->getMatches("( `home_team` = {$team->id} OR
`away_team` = {$team->id} ) AND DATEDIFF(NOW(), `date`) <= 0");
$next_match = $next_matches[0];

Here is the code for the previous game that pulls the first game of the
season, not the actual previous game.

$prev_matches = $leaguemanager->getMatches("( `home_team` = {$team->id} OR
`away_team` = {$team->id} ) AND DATEDIFF(NOW(), `date`) > 0");
$prev_match = $prev_matches[0];

It's probably something really simple, but I have been ahcking away at this for about 8 hours and I cannot get it to work. On a side note if you swap the "0" for a "1" in this line $prev_match = $prev_matches[0]; it will show the second game of the season.

Thanks

Your Answer:

Login to answer

Other forums

Scrolling news bar and MySQL
I am not sure if this is the correct forum to post this on. If not, I apologize. I am still pretty

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

Function module "DPS_CHECK_TABLE_EXISTS" not found (after OSS 1422843 impl)
Dear All,

I implemented Note OSS 1422843.

When i execute the new report RSPO20

Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.

However

PHP Search Issue
Hi, I am using the following code to search and return flights from a database. The user searches by

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

can i optmize image to 50% quality before uploading 2 server
Hi there

i have jus written a php program to upload and display images but when i try to uplo

Creating a custom API
I'm creating a site, and I need to create a basic API. Unfortunately I have no idea where to start.