Database newbie… beginner’s guide?

  • afx237vi

    (@afx237vi)


    20 years, 7 months ago

    I don’t think this is Worpress related, per se, but I thought I might explain what I want to do and see if you guys can point me in the right direction.

    I currently have a WordPress blog about the sport of pro cycling, but I want to extend it and have a section where users can check the palmares of their favourite cyclists. A palmares is a list of all their major career achievements.

    So I basically want a database where I enter the name of the rider (eg Lance Armstrong), team (Discovery), year (2005), achievement (1st, Tour de France) and so on.

    And I want – for example – the number of wins to update every time I make an entry, and possibly cross-reference things, such as if I click on “Discovery” I’ll go to a page where all the Discovery wins are listed.

    An example of what I want is the site cyclingbase.com – but that’s in French. I can’t find anything like it in English, which is why I want to do it.

    Thing is, I have no idea where to start. I’m not bad with technical stuff, and got WP up and running easily, but I’m at a loss where to start with this. Any pointers? I’m eager to learn!

Viewing 1 replies (of 1 total)
  • Lorelle

    (@lorelle)

    20 years, 7 months ago

    What you need is a plugin or PHP script that will create a new table with this information in it, like a score card, and then allow you to pull the information out of it.

    Or you just make a table on a Page and update it manually, which could be faster.

    Just search the net for PHP scripts for score keeping or reference, something like that.

    I vote for doing it manually. It will take longer to figure out and setup such a program.

    <table>
    <tr><td>Name</td><td>Team</td><td>Year</td><td>Achivement</td><td>Race</td></tr>
    <tr><td>Armstrong</td><td>Discovery</td><td>2005</td><td>First Place</td><td>Tour de France</td></tr>
    ...etc.
    </table>

    This is a really really simple version, but you just put in the info and save the page, instant update.

    Otherwise, you will have to have an interface, setup the tables, forms, and…go manual.

    If you are serious about this, you might have to hire someone to set it up for you.

Viewing 1 replies (of 1 total)

The topic ‘Database newbie… beginner’s guide?’ is closed to new replies.

Tags