Hello.
I'm making a tutorial website. Tutorials are stored in a mysql database and their titles are pulled from the database and displayed in a list on the page so the user can click on the title to read the tutorial.
But, because my tutorials flow from "beginner" to "advanced," they need to display on the index page (described above) in that same order.
If i write 5 tutorials, some "advanced", some "beginner", i need to make all the beginner tutorials stay together, and all the advanced tutorials stay together. I've thought of making a category section in the database and using it to seperate the advanced tutorials from the beginner tutorials, but that still wouldn't work because the beginner tutorials still need to be in a certain order; same with the advanced ones.
The only way i can see to do this is to either:
a) Insert all the tutorials in a specific order and never add any more.
or
b) Re-order the rows in the table somehow.
Any suggestions?
Thanks in advance.
I'm making a tutorial website. Tutorials are stored in a mysql database and their titles are pulled from the database and displayed in a list on the page so the user can click on the title to read the tutorial.
But, because my tutorials flow from "beginner" to "advanced," they need to display on the index page (described above) in that same order.
If i write 5 tutorials, some "advanced", some "beginner", i need to make all the beginner tutorials stay together, and all the advanced tutorials stay together. I've thought of making a category section in the database and using it to seperate the advanced tutorials from the beginner tutorials, but that still wouldn't work because the beginner tutorials still need to be in a certain order; same with the advanced ones.
The only way i can see to do this is to either:
a) Insert all the tutorials in a specific order and never add any more.
or
b) Re-order the rows in the table somehow.
Any suggestions?
Thanks in advance.