require("../php/anonymous.ini"); $brand_id = 2; session_start(); //検索条件 $where = "WHERE status = 1 AND brand = '{$brand_id}' "; //表示順 $order = "ORDER BY sort desc, price asc "; //検索実行 $query = "SELECT * FROM product $where $order"; $result = $db->exec($query); $num = pg_numrows($result); //ブランド情報 $query_brand = "SELECT * FROM brand WHERE id = '{$brand_id}'"; $result_brand = $db->exec($query_brand); $obj_brand = pg_fetch_object($result_brand); ?>