Live Data Feed for Sports events

Something like this already exists in WordPress in raw form.

When editing a post (or when composing a new post and you’re set for Advanced controls under Options > Writing) focusing on a game, you can create two custom fields, one for each team using the key for team name and value for their score. Then to update the scores, edit these fields in the post and save your changes.

Now, to display these with the post, insert the_meta() tag into your WordPress template:

https://codex.www.ads-software.com/Template_Tags/the_meta

Place it somewhere in The Loop portion of the template.

There are also some plugins out there that allow more control over displaying meta/custom field data:

https://codex.www.ads-software.com/Plugins/Meta

Hey, thanks for your helpful reply. I’m afraid posting live scores in posts is not a good idea because I plan to have student blogging the developments at the event so the live score post will be pushed down with the newer entries/posts.

I prefer to put the live scores in a category and list menu so a visiter can view the live scores on the right column instead of in the post.

I’m not tech-savvy, but I can learn fast. Is it possible to create custom fields in links menu to reflect live scores?

Thanks,

Rene V.

Custom fields are tied to posts (and Pages in 1.5), so it’d be hard to assign them independent of these.

This is all stretching the intention of custom fields, but with an existing Page, you could edit the custom fields for teams/scores in this, and with a bit of php could pull in the data to your sidebar. The following would go into your theme’s sidebar.php or #menu section, or where you want the scores to appear:

<?php
$page_id = 100; // Set this to Page ID #.

$scores = $wpdb->get_results("SELECT meta_key, meta_value FROM $wpdb->postmeta WHERE post_id = $page_id ORDER BY meta_id");
if($scores) {
foreach($scores as $score) {
$team = $score->meta_key;
$points = $score->meta_value;
if(is_numeric($points)) {
if(!$game) {
echo "<ul class="scores">n";
}
echo "<li>$team: $points</li>n";
$game++;
if(2 == $game) {
echo "</ul>n";
$game = 0;
}

}
}
}
?>

The script verifies the value field is a number (i.e. score), so you could prep the team listings and not have them display; or you can place 0 (zero) as the score to “initialize” and display them. The teams are ordered by entry (meta_id table value), so should show up together (So Team A vs. Team B are the first custom fields, Team C vs. Team D are next, and so on).

Note that I slipped in a ‘scores’ class for each game <ul>, so you could style the output in your css.

Hello,

I did copy and paste the PHP code with two custom fields: Riverside Boys and Fremont Boys and it’s not appearing..However…the link from the Post go directly on the Page. the page id is 10. So, I already set up two custom fields for teams and set up a page for Live Scores.

I’m using WordPress 1.5 default theme and added your PHP code into sidebar template inside the

.

Do I need to insert meta tag?

Am I missing anything? I’m still naive to PHP coding.

https://www.lightkitchen.com/blog/

I’m setting up a live score in

https://www.lightkitchen.com/blog/?p=10

I’m using my personal website to test blog and live scores.

Would it be easier if you send me the entire sidebar template with default WP links with your added code so I can figure it out?

Thanks for your effort!!!

Rene V.

https://desto.net/andrew/content/newsticker2/newsTicker.html

that’s a good example of what I want in WP. Can you use the PHP page to flesh out the javascript and html within

menu?

Or just below the header (header image)?

I ran a basketball tournament this past christmas. You can view the site here. For the live scores “scoreboard” I simply used an IFRAME and had a separate html page with a simple little scoreboard table that I had my staff update using FrontPage. It worked out really well.