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


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more