If you have written some custom code for the PHP Pages Component and would like to share it, post it here:

Here is how to connect to a database other then the Joomla database using the Joomla 1.5 API.

$options = array();
$options['driver']   = 'mysql'; // or mysqli
$options['host']     = 'localhost';
$options['user']     = 'j10';
$options['password'] = 'j10';
$options['database'] = 'j10';
$otherdb = JDatabase::getInstance($options);

$otherdb->setQuery('SELECT * FROM jos_users');
$rows = $otherdb->loadObjectList();

print_r($rows);

The $option values are dependent on your database settings.

Something I recently wrote...

PHP Code:
function alphanumeric_underscores($string) {
// Converts a string into an underscores-instead-of-spaces, all-lower-case, alphanumeric string.
// "This function isn't too complex" becomes "this_function_isnt_too_complex".
$string = strtolower($string);
$string = ereg_replace("[^A-Za-z0-9 ]", "", $string);
$string = str_replace(" ", "_", $string);
return $string;
}

--- url snipped ---