Initially, create a working directory where you can download all the files into (The author usually downloads to /usr/local/src or a /usr/local/src/downloads directory). You might want to keep all the downloaded files handy, just in case you have to re-install something. The list of packages to be downloaded are enumerated below. There are two download locations for all the packages (the first one is the official site and the second one belongs to a friend). The official sites will contain the latest version of the package + some useful information for each package. While my friend's FTP site is updated as soon as a new version of a package is released, you might want to check the official sites first.
Apache Web Server: Check www.apache.org for the latest version or download it from here. Currently, the latest stable version is apache_1.3.28 as of 08/10/2002. Apache 2.xx.xx series has also been out for a while (the latest is 2.0.40), but it should not be seriously considered for a production server for now. There are many issues with the Apache 2.x.x series (especially third party modules that worked fine with the 1.3.xx series and don't work on 2.xx.xx), so the author's advice here is to stick with 1.3.xx versions for a while.
PHP Module Check www.php.net for the latest version or download it from here. Currently, the latest stable version is php-4.3.2.
Zend Optimizer: This is actually an optional module. However, since the optimizer enables the PHP code to run faster, I've included this as an essential package. Download the version that is specific to your operating system (Linux or FreeBSD) from here.
mod_gzip: This is another optional module. However, this module saves so much on bandwidth that I've included it as part of the essential package. This module is written by Hyperspace Communications and can also be downloaded from here.
MYSQL: (Only if you're going to use MySQL) Check www.mysql.com for the latest version or download it here. Currently, the latest version is mysql-4.0.14.
SQL Server: (Only if you're using SQL Server) The driver to use is called FreeTDS. Check www.freetds.org for the latest version or download it here. Currently the latest version is freetds-0.60. Note that this is a driver to connect to SQL Server, not the SQL Server package itself. If you're looking to download a pirated version of SQL Server, you will NOT find it here!
While you may not use Perl to serve any web pages, it is still useful to download the perl packages to enable it to connect to databases. The reason for this is that you may need to write some scripts that do lookups on databases and write out certain data. The author has some perl scripts that access data on a SQL database and write out some PHP code automatically. This is especially useful when you need some lookup tables or something like that and you don't want to query the database each time. Instead, you can write a perl script that dumps the data into a PHP array, which your PHP code can then use. If the data in the database changes, all you need to do is rerun your perl script to rebuild your PHP code and you're set!
Perl Sybase Driver: (For SQL Server and Sybase only). Microsoft had originally licensed SQL Server from Sybase corporation and hence the driver works for both products. You can check the latest version at search.cpan.org/search?module=DBD::Sybase or download it from here. Currently, the latest version is DBD-Sybase-0.95.
Perl MySQL/mSQL Driver: (For MySQL or mSQL only). The driver works for both MySQL and mSQL. You can check the latest version at search.cpan.org/search?module=Msql or download it from here. Currently the latest version is Msql-Mysql-modules-1.2216.
Perl Database Independent Driver(DBI): You'll need this driver regardless of what database engine you are using (SQL Server, MySQL, mSQL or even Oracle for that matter). You can check the latest version at search.cpan.org/search?module=DBI or download it from here. Currently the latest version is DBI-1.20.
Optional Apache Modules
MHASH: This is an optional module to perform hash calculations in PHP. You can check for the latest version at mhash.sourceforge.net/dl/ or download it from here. Currently, the latest version is mhash-0.8.10. If you don't use any of PHP's mhash_xx functions, then you might not need this module. The author generally installs it, because he has always needed it at a later stage (because of the nature of the programs that he writes).
BSD User Notes
If you are a FreeBSD, OpenBSD, or NetBSD user, you will also need some other tools, if you are going to add SQL Server support. The reason for this is that, the installation procedures for SQL Server drivers use the GNU Make (gmake) program instead of plain ol' make (for some additional features that make does not provide). Hence, you may need to install it separately, if your system does not already have it.
gettext: Check the latest version from www.gnu.org or download it from here. Currently the latest version is gettext-0.10.36.
make: Check the latest version from www.gnu.org or download it from here. Currently the latest version is make-3.79.