Hello
I am trying to build a simple cms with php, and i have some questions.
first of all i have done the tables in mysql, i have 3 tables, first is called "posts" which holds the articles that i submit, the other one is the "categories" to show which category the post belongs to, and the last table is "users" table just to allow the admin to login in. the admin panel has been done where i post new articles to mysql database.
what i want to do :
1) to show 10 articles per page ( i have already found a pagination class but would like to hear your comments, link :
http://net.tutsplus.com/tutorials/php/how-to-paginate-data-with-php/
)
how this thing can be done ?
2) have my posts under their category
http://mysite/category/article
e.g. :
http://mysite/php/1-hello-world-test
http://mysite/cplusplus/2-using-function
http://mysite/visualbasic/3-events-handling
as you can see every article would have an id number with auto-increment property.
so how i would make those urls with the title of the article on them ?
i know the theory but i can't implement it so i would appreciate any comment and suggestion on how this should be done .
Thanks
