<?

	require("db.inc");
	db_connect();
	$rstring="";

	$q1 = "select item_details.page, item_details.position, item_details.item, item.rgb_r, item.rgb_g, item.rgb_b, item_details.lch_l, item_details.lch_c, item_details.lch_h, item_details.leh, item_details.family from item left join item_details on item.image_name = item_details.image";
	//$q1 = "select item.* from item left join item_details on item.image_name = item_details.image";
	//$q1 = "select * from item";
	//echo $q1;
	$res1 = db_query($q1);
	if ($res1[0][0]>0)
	{
			$rstring="status=1&resultlist=";
			for ($m=1;$m<=$res1[0][0];$m++)
			{ 
				  for ($n=0;$n<=10;$n++)
			   {
				  $rstring.=$res1[$m][$n];
				  if ($n<10)$rstring.=";";
				  }
        if ($m<$res1[0][0])$rstring.="|";
			}
			db_disconnect();
	}
	else 
	{
		$rstring="status=0&resultlist=";
	}
	
  echo $rstring;
?>