IMPORTANT: Please read our Guide To Quality Writing before you begin posting!

Dismiss Notice
Please note that we are only approving writers from the US, UK and Canada at this time.

Best Way To Store This Data in Database

Discussion in 'Programming' started by iajua, Apr 20, 2015.

  1. iajua

    iajua New Member

    Joined:
    Apr 20, 2015
    Posts:
    11
    Likes Received:
    0
    Gender:
    Male
    Hi guys,

    I do a weekly call and I have a collection of all my recordings I post to an archive page. Right now this content is not stored in a database but I would like to transition it to one. Here is what the data and formatting appear like for each recording:


    2015-04-15 (recording date)

    Play-By-Play:
    00:00 - - Welcome to the call
    01:20 - - Topic One
    08:54 - - Topic Two
    Call Length: 21:00
    etc...

    Download Audio File (direct download link)


    Before proceeding, I'm curious of the best way to store the "Play-By-Play" section. The HTML looks like this:

    [​IMG]

    Should I just store that section WITH the HTML tags in a table? Or is there a more appropriate method?

    Thanks!
     
    iajua, Apr 20, 2015
    #1

Share This Page