\n";
/* Connect to DB */
require_once('inc_connect.php');
$dbcnx = mysql_connect("$dbsvr", "$dbuser", "$dbpass") or die("Failed to Connect: " . mysql_error()); // Connect to '$db'
mysql_select_db($db, $dbcnx) or die("Failed to Access Database: " . mysql_error());
/* Variables ------------------------------------ */
/* Functions ------------------------------------ */
require_once('inc_string.inc'); // String manipulation functions...
require_once('inc_topics.inc'); // Query Topics...
require_once('inc_categories.inc'); // Query Categories...
/* Queries ------------------------------------ */
$vStartTime = GetMicrotime(); // Get timestamp before executing the query...
QueryTopics("SELECT OptionName
FROM PUBSELECTOPTIONS
WHERE FieldID = 9990186948838
ORDER BY OptionName");
QueryCategories("SELECT CategoryID, CategoryName, Subcat1, CategoryID AS Subcat1id
FROM PUBCATEGORY
WHERE CategoryHidden = 0
ORDER BY CategoryName, Subcat1");
$vEndTime = GetMicrotime(); // Get timestamp when the query is finished...
/* Disconnect from DB */
mysql_close($dbcnx) or die ("Could not close connection to database"); // Disconnect from '$db'
?>
Site Map @ The Money Pit Home Improvement Radio Show