private static function get_basket_info() { if (self::$query_complete === false) { global $connection; $query = ' SELECT ' . NEW_TABLE_BASKETS . '.basket_id, ' . NEW_TABLE_SITES . '.site_id, ' . NEW_TABLE_SITES . '.site_short, ' . NEW_TABLE_SITES . '.site_long, ' . NEW_TABLE_BASKETS . '.checked_out FROM ' . NEW_TABLE_BASKETS . ' LEFT JOIN ' . NEW_TABLE_SITES . ' USING(site_id) WHERE ' . NEW_TABLE_BASKETS . '.delivery_id = "' . mysql_real_escape_string(ActiveCycle::delivery_id()) . '" AND ' . NEW_TABLE_BASKETS . '.member_id = "' . mysql_real_escape_string($_SESSION['member_id']) . '"'; $result = @mysql_query($query, $connection) or die(debug_print("ERROR: 783032 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); if ($row = mysql_fetch_object($result)) { self::$basket_id = $row->basket_id; self::$site_id = $row->site_id; self::$site_short = $row->site_short; self::$site_long = $row->site_long; self::$basket_checked_out = $row->checked_out; self::$query_complete = true; } } }