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...
Did you know?Explore Trending and Topic pages for more stories like this.
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
No comments posted yet
Your Answer:
Login to answer
185
43
Other forums
Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo
Working with Dates, help.
Sooo to make a long story short, here's what im trying to accomplish.
I need to create a drop
Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBa
List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab
How can use this array as a key?
Say I have this array for example:
print_r($array);
Prints:
Code: [Select]Array
BB_Code error
I'm having a problem with a custom built function and keep getting this error:
Warning: M
Windows Authentication
I have a website which is windows authenticated.
now i want something more on this application.<
Getting PHP to ammended the selected in option field
Hey Guys
thanks for everyones help so far. This site and its users are oozing awesomness.
User registration and login
I don't know whether this is the correct forum, if not i apologise but am pretty desperate at the mo
Save remote XML to local website folder
Hi, I hope you can help me out. I would like to be able to pull an XML file from another site and t