Re: help me pls

"Marthinus adi" <marthinusa@yahoo.co.uk> wrote in message news:20010812061900.10648.qmail@web20304.mail.yahoo.com... > 1. what's the different between MySQL and PostgreSQL. > When i should use MySQL, > and when to use PostgreSQL, why ? ...... MySQL is a bit simpler; it's faster if you're doing a lot of simple queries. PostgreSQL is a somewhat more complete implementation of SQL; it allows you to do things like subqueries and transactions, at the cost of being a bit slower. Either should be entirely sufficient for what you want to do. > 2. i want to upload one/more file, but the uploaded > file always store in temporary file, ex Windows/temp. ... you can specify the upload dir with upload_tmp_dir in php.ini, or use move_uploaded_file() to put it where you want. > i want the news is saved by the > 1.html,2.html,3.html,...... > and i want to make directory for that file day by > day, month by month and year by year, > so if you want to click "more news" or "view > details" so > the URL is like this > http://www.name.com/2001/08/12/1000.html > 2001 is the directory for news file in the 2001, > 08 for the month, and ...... > 1000.html is the file name. > > can somebody teach me about that.....maybe > somebody have the sample script pls ?....... You can do what you have described without any script; this is fast and simple, at the cost of being unuseable in any other form. On the other hand, storing stories in a database in chunks offers a lot more flexibility. There are plenty of news systems available; check out http://sourceforge.net/search/?type_of_search=soft&exact=1&words=php+news