vendredi 24 juin 2016

Storing lyrics in a mysql database with proper mapping

Something like. I want to have a database where people can search Christian hymns based on hymn #. A hymn has a title, chorus, and a couple verses, and some bible references. If my hymn table store id, title,chorus,verses,bible_refs. When a user search and find a hymn # and want view it, how can i be able to map the order in which the hymn appears. For example, Title, Verse1, Verse2, chorus, Verse3 and bible_ref. I am also want to achieve proper line breaks between the order. The hymns can structured in various orders. Any expert on php who did that kind of stuffs can help me I would appreciate.

Aucun commentaire:

Enregistrer un commentaire