
 
 

 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
<b>MySQL Error:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)</b><br>
<b>SQL:
			select 
			ec.Eld_Course_SN, 
		    ec.name,
		    ec.courseDateMemo,
			
			ec.day,
			ec.File_Name,
			ec.place,
			ec.peopleLimit,
			ec.prfoess,
			ec.prfoessTxt,
			ec.meals,
			ec.signUpEnable,
			(select count(ecm.Eld_CourseMember_SN) from Eld_CourseMember ecm where ecm.courseSn = ec.Eld_Course_SN) as people,
			
			
			(select elc.name from Eld_Country elc where elc.Eld_Country_SN =  ec.countrySn) as countryName,
			(select ela.name from Eld_Area ela where ela.Eld_Area_SN  =  ec.areaSn ) as areaName,
			ec.address,
			ec.rePerson,
			ec.phone,
			
			ec.nonPayMoney,
			ec.payMoney,
			ec.courseDateDesc
			  from Eld_Course ec
			 where ec.Eld_Course_SN = 250 
			 </b>