db_resultのクエリの送信に失敗しました。You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'then @c
	    else @c:=@c+@s
	  end as rank,
	  case
	    when @p =  then @s:=@s+' at line 30<br />
	select 
id,
t_kodo,
t_name,
address,
ido,
keido,
gml_posList,
chiikikodo,
chiikishikibetsukodo,
chiiki,
jinkouheisei27nen,
jinkouheisei22nengumikawa,
heisei22nen27nennojinkouzougensuu,
heisei22nen27nennojinkouzougenritsu,
mensekikm2,
jinkoumitsudo1km2atari,
setaisuuheisei27nen,
setaisuuheisei22nengumikawa,
heisei22nen27nennosetaizougensuu,
heisei22nen27nennosetaizougenritsu,
otoko,
onna,
jinkouseihi
, rank from 
	(
	  select
	  @p:=@a,
	  case
	    when @p =  then @c
	    else @c:=@c+@s
	  end as rank,
	  case
	    when @p =  then @s:=@s+1
	    else @s:=1
	  end as S,
	  
id,
t_kodo,
t_name,
address,
ido,
keido,
gml_posList,
chiikikodo,
chiikishikibetsukodo,
chiiki,
jinkouheisei27nen,
jinkouheisei22nengumikawa,
heisei22nen27nennojinkouzougensuu,
heisei22nen27nennojinkouzougenritsu,
mensekikm2,
jinkoumitsudo1km2atari,
setaisuuheisei27nen,
setaisuuheisei22nengumikawa,
heisei22nen27nennosetaizougensuu,
heisei22nen27nennosetaizougenritsu,
otoko,
onna,
jinkouseihi
, @a:= from 
	  
	  (
	    select @c := 1, @a := null, @s := 0)
	  AS dummy,
	  kokusei_27_jinkou_all 
	  WHERE chiikikodo LIKE '%000'
	   desc
	) as tmp;