I need a mysql/php solution. Here's the spec:
I need a administration page for a 'web posting/blogger' type of script.
Password protected script by database authentication.
The form will let the admin enter a headline on one field and a link for that headline on another field (the entire headline will be inside a link tag). On the same form I need it to have a field to browse for pictures on local hard drive and to upload the image along with the headline and link on submit. If no image is selected it can still be able to post to database. It will just set image field to blank. So when the posting is outputted to a webpage it can be formatted with a 1 colunm html table to display just a headline. However if an image is set then it is formatted with a 2 column html table.
I will need a select field(drop down box) to set the posting to a specific category.
I will also need a seperate admin page where I can add or delete categories.
I will need to be able to set the order of the posted headlines an example would be the ability to set the priority level of a headline. such as if I want a certain headline that I posted that got pushed down by a more recent posting to be at the very top of the posts I can set the position of it to number 1.
I need the output of the postings to be seperated by their respective categories.