Support » Plugins and Hacks » newb with mysql query question

  • okay so total newb on the plugin front here, so please be nice 😉

    I am writing a simple plugin for my website. I have a basketball website and want to have a scoreboard on the homepage. However, I want to have all the data on the scoreboard easily changed from inside wordpress.

    I created the plugin and got that working okay. I created the table in mysql and got that working okay. The table is called “scoreboard” and I have 2 rows with data in it for now. However, here is my problem.

    How do i query that table to 1) show the current values on my admin page and 2) update those values as necessary from the admin page? I have been searching all night and I cannot get it to work right.

    Thanks for any help!

Viewing 15 replies - 1 through 15 (of 19 total)
  • my goal is this:

    I want a scoreboard on the homepage, say with 4 games and scores on it. We do live updating of the scores as the games are going on.

    So i want one person to be able to be logged in a updating Game 1 and have another person be able to be logged in somewhere updating Game 2.

    Any thoughts ?

    any advice on how to get started with something like this?

    Shouldn’t be too hard, I don’t think.


    i started to get to be able to query the database. But how can I structure it so that users can go into the admin area and update the scores ?


    Use the wpdb class. It works basically the same as any other SQL query.

    okay. Looked through that a bunch.

    Here is my question.

    I need to write a form on my admin page that will populate the fields with the current value in the table, then allow the user to enter a new value and hit an update button, which will update the value in the table, kind of like how you can set your options in the settings pages in the default WP admin area.

    How would I structure that? Also, keeping in mind that I am using a custom added table to my database.


    This isn’t really a WordPress question. It’s more of a PHP/HTML question.

    Use the WordPress database class to retrieve the info from the database. Set the “value” attribute for each field equal to the appropriate value from the database. This will populate the fields in the form. On the submit action, have it gather the field values and use the WordPress database class again to update the database table.

    okay. thanks for your help. I will try to see what i can work out.

    No problem. Also, you can download and look at the code. I do this on the plugin options page.

    Okay. Thanks so much. I will take a look at that.

    hey so here is what I have:

    <form name='update_team1' id='update_team1' method='POST' action='<?="http://"
    <br />
    <input name="team1" value="<?php echo $team1; ?>" type="text" /><input type="submit" value="Update Widget Footer" /><br />

    So when the page displays, the correct team name shows up in input field, however when I change it and hit submit – the change does not take effect ?

    Any ideas ?

    Do you have code to receive the data?

    not sure what you mean by this ? So guessing I don’t. Can you help me with that ? Thanks!

    Again, this really isn’t a WordPress question. You need to review PHP form processing.

    okay I think I got it all working except for one little problem. When I go to post the new value into the table using UPDATE, if I manually type in wpSite_scoreboard – it works okay. When I use $wpdb->prefix . "scoreboard" it does not work.

    When I do this $table_name = $wpdb->prefix . "scoreboard"; and then echo $table_name, I only get this printed out : scoreboard, but it should be printing out : wpSite_scoreboard.

    Any reason in general why it would not work correctly. I see how you did it and you just used the same $wpdb-> prefix . “table_name” idea, so is there any file that I must include or something I am missing that would make this not work?

    This is the last piece I need, I think!

    Show me the rest of your code.

Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘newb with mysql query question’ is closed to new replies.