PHP stuff

function DAOGetConnection($objDBSettings, $objLogger = NULL)
{
$objReturn = null;

if ($objConn =@mysql_connect($objDBSettings['HOSTNAME'],$objDBSettings['USERNAME'], $objDBSettings['PASSWORD']))
{
if (mysql_select_db($objDBSettings['DATABASE'], $objConn) == true)
{
$objReturn = $objConn;
}
}

return $objReturn;
}

function DAOExecuteSQL($objConn, $strSQL, $objLogger = NULL)
{
$bReturn = false;
if (is_null($objConn) == false)
{
if (mysql_query($strSQL, $objConn) == true)
{
$bReturn = true;
}

}
return $bReturn;
}

function DAOQuerySQL($objConn, $strSQL, $objLogger = NULL, $bCloseConnection = true)
{
$objReturn = null;
$objResult = null;

if (is_null($objConn) == false)
{
if($objResult = mysql_query($strSQL, $objConn))
{
if (mysql_num_rows($objResult) > 0)
{
$objRow = mysql_fetch_assoc($objResult);

$objReturn = array($objRow);

while ($objRow =mysql_fetch_assoc($objResult))
{
array_push($objReturn, $objRow);
}
}
mysql_free_result($objResult);
}


if ($bCloseConnection == true)
{
mysql_close($objConn);
}
}


return $objReturn;
}