Cacher is the code snippet organizer for pro developers

/**获得购买次数*/
function get_goods_ordernum($goods_id)
{

        $sql = 'SELECT count(*) ' .
               'FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS oi LEFT JOIN ' . $GLOBALS['ecs']->table('users') . ' AS u ON oi.user_id = u.user_id, ' . $GLOBALS['ecs']->table('order_goods') . ' AS og ' .
               'WHERE oi.order_id = og.order_id AND ' . time() . ' - oi.add_time < 2592000 AND og.goods_id = ' . $goods_id;
        $count = $GLOBALS['db']->getOne($sql);
		return $count;

}

<?
function db_query($qry_str)	{return mysql_query($qry_str);}
	function db_num_rows($res)	{return mysql_num_rows($res);}
	function db_fetch_array($res)	{return mysql_fetch_array($res);}
	function db_fetch_object($res)	{return mysql_fetch_object($res);}
	function db_data_seek($res,$num){return mysql_data_seek($res,$num);}
	//function db_insert_id($res)	{return mysql_insert_id($res);}
	//以下是自行扩展
	function db_error()	{return mysql_error();}
	function db_free_result($res)	{return mysql_free_result($res);}
	function db_close($res)	{return mysql_close($res);}
	//function db_insert_id()	{return mysql_insert_id();}
?>