sql - Mysql - PHP show data from one column over 3 columns -

i have moodle install building standalone report.

the fieldid has integers relate personnel info.

fieldid    information    1        job title    2        payrol    3        dept  

i 3 separate columns info. works fine within moodle using alias's reference alias column info. can't work in php.

from moodle  join prefix_user_info_data uid on uid.userid = u.id join prefix_user_info_data uid2 on uid2.userid = u.id join prefix_user_info_data uid3 on uid3.userid = u.id join prefix_user_info_data uid4 on uid4.userid = u.id  uid.fieldid = '13' , uid2.fieldid = '1' , uid3.fieldid = '3' , uid4.fieldid = '8' 

sharing php , full code isn't going much, showed relavant bits. i've included part of php using info. ['data'] columns 1 information is. when include , uid2.fieldid = '1' shows department. 2 columns job title , payroll number.

$course = $_post["course"]; $date= $_post["date"]; $sql = "select firstname, lastname, data, name, statuscode, date_format       (from_unixtime(timestart),'%d/%m/%y') timestart, date_format(from_unixtime(timefinish),'%d/%m/%y') timefinish    mdl_facetoface  inner join mdl_facetoface_sessions on       mdl_facetoface_sessions.facetoface=mdl_facetoface.id inner join mdl_facetoface_sessions_dates  on      mdl_facetoface_sessions.id=mdl_facetoface_sessions_dates.sessionid  inner join mdl_facetoface_signups  on     mdl_facetoface_sessions.id=mdl_facetoface_signups.sessionid  inner join mdl_user on mdl_facetoface_signups.userid=mdl_user.id  inner join mdl_facetoface_signups_status on   mdl_facetoface_signups.id=mdl_facetoface_signups_status.signupid  inner join mdl_user_info_data  on mdl_user_info_data.userid = mdl_user.id      name '%".$course."%'  , mdl_user_info_data.fieldid ='1'  , date_format(from_unixtime(timestart),'%d/%m/%y') '%".$date."%'   , firstname <> 'test'  , lastname <> 'test'  , statuscode ='70'  , statuscode<>'10'  , statuscode <>'20'  , statuscode <>'30'  , statuscode <>'40'  , statuscode <>'50'  , statuscode <>'60'  , statuscode <>'80'  , statuscode <>'90'  , statuscode <>'100'";  echo '<table width="90%">';    echo '<td width="25%">'.'<h2>'.$row["firstname"].' '.$row["lastname"].'</h2>'.'</td><td width="25%">'.'<h2>'.$row["data"].'</h2>'.'</td><td width="20%"></td><td width="30%"></td>';          }       echo "</table>"; 

i got time spend on fixing this. usual simple when figured out. these bits needed change or add.

 select  p.data pay, t.data title, d.data dept,     inner join mdl_user_info_data p on p.userid = mdl_user.id  inner join mdl_user_info_data t on t.userid = mdl_user.id  inner join mdl_user_info_data d on d.userid = mdl_user.id    p.fieldid='3'  , t.fieldid='9'  , d.fieldid='1'   <td width="20%"><h2>'.$row["title"].'</h2></td>  <td width="20%"><h2>'.$row["dept"].'</h2></td>  <td width="15%"><h2>'.$row["pay"].'</h2></td> 

cheers looking