$this->result = mysql_query($query,$this->dbh);


function query($query)
{


// Flush cached values..
$this->flush();


// Log how the function was called
$this->func_call = "\$db->query(\"$query\")";


// Keep track of the last query for debug..
$this->last_query = $query;


// Perform the query via std mysql_query function..
$this->result = mysql_query($query,$this->dbh);


// If there was an insert, delete or update see how many rows were affected
// (Also, If there there was an insert take note of the insert_id
$query_type = array("insert","delete","update");


// loop through the above array
foreach ( $query_type as $word )
{
// This is true if the query starts with insert, delete or update
if ( preg_match("/$word /i",$query) )
{
$this->rows_affected = mysql_affected_rows();


// This gets the insert ID
if ( $word == "insert" )
{
$this->insert_id = mysql_insert_id($this->dbh);
}


$this->result = false;
}


}
if ( mysql_error() )
{


// If there is an error then take note of it..
$this->print_error();


}
else
{


// In other words if this was a select statement..
if ( $this->result )
{


// =======================================================
// Take note of column info


$i=0;
while ($i < @mysql_num_fields($this->result))
{
$this->col_info[$i] = @mysql_fetch_field($this->result);
$i++;
}


// =======================================================
// Store Query Results


$i=0;
while ( $row = @mysql_fetch_object($this->result) )
{


// Store relults as an objects within main array
$this->last_result[$i] = $row;


$i++;
}


// Log number of rows the query returned
$this->num_rows = $i;


@mysql_free_result($this->result);




// If there were results then return true for $db->query
if ( $i )
{
return true;
}
else
{
return false;
}


}
else
{
// Update insert etc. was good..
return true;
}
}
}