Searching MySQL with PHP

Discussion in 'PHP' started by midwestbonsai, Dec 5, 2007.

  1. #1
    Hello,

    I have a project on hand that goes over my head.
    I want to create a database to store various info about the articles on my site. I would also like it to by secure, to avoid getting hacked.

    And then have users able to display them on screen, in various ways.
    Have "Buttons" they could click to have them display in order by title, in grouped by author sorted by date, grouped by subject sorted by date.

    Then in various other places around my site I would like to list the newest 10 articles (linked of course).

    Here is the important info I would like to include in the data base.

    Title
    Author
    Author Location (Country)
    Subject
    Date Published
    URL

    How would you go about this?
     
    midwestbonsai, Dec 5, 2007 IP