mysql 프로그램에서는 되는 쿼리가 sql_query()로는 작동하지 않음.

$sql = " select distinct avl_bo_table from g5__piree_770015_vote_list";	//echo "이야야아아아!!
";	$result= sql_query($sql); $sql = "select * from (";	while($rowss = sql_fetch_array($result)){		//print_r($rowss);		$sql .=" select a.*,b.ca_name from `g5__piree_770015_vote_list` as a left join";		$sql .=" `g5_write_{$rowss['avl_bo_table']}` as b on (a.avl_wr_id= b.wr_id)";		$sql .=" where ca_name is not null and ca_name !=''";		$sql .=" union all ";		}	$sql = substr($sql, 0, -10 ); //맨마지막에 붙는 union all 삭제. 	$sql .= ")";	 	if($stx!=''){		$sql .= " where INSTR(LOWER(avl_title_s), LOWER('$stx'))";	}	$sql .=" as t order by ca_name, avl_n desc";	$sql2 = $sql;	/*SELECT * FROM (	SELECT avl_n, avl_bo_table,avl_wr_id,ca_name,avl_title_s  FROM g5__piree_770015_vote_list AS a	LEFT  JOIN  g5_write_free_board4 AS b  ON (a.avl_wr_id = b.wr_id AND avl_bo_table = 'free_board4')	WHERE ca_name IS NOT NULL AND ca_name != ''	UNION ALL	SELECT avl_n, avl_bo_table,avl_wr_id,ca_name,avl_title_s  FROM g5__piree_770015_vote_list AS a	LEFT  JOIN  g5_write_free_board5 AS b  ON (a.avl_wr_id = b.wr_id AND avl_bo_table = 'free_board5')	WHERE ca_name IS NOT NULL AND ca_name != ''	) AS t 	 ORDER BY ca_name*/	$result2 = sql_query($sql2);print_r($result2);

mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )