Start Building Professional
Web Apps Today

it will show me only one column i want to add multiple column

Hello,


as per your mail i have add the code i m remove single code but it will show me only one column but in my database i am add three column value but it show me only last value. please tell me wht i do .



                        $sql_u = mysql_query("SELECT headName from dummyHead WHERE projID='".$_REQUEST['projid']."' LIMIT 0,1");

                        $countDummy = mysql_num_rows($sql_u);

                            if($countDummy<=0)

                             {

    

    $grid->render_sql("select * from shot,shotTaskArtist where shotTaskArtist.projID=shot.projID and shot.projID='".$_REQUEST['projid']."' and shotTaskArtist.shotID_new=shot.shotID order by shot.shotID asc","shot_task_id","checkEfficiency,overDue,difficulty,shotID_new,shotStatus,taskID,TaskREF,task_note,manDays,userID,taskStatus,startDate,endDate,task_priority,actualMandays,supervisorName");

    

    

    }

     else {     

                         //$head = "";

                            while($rows = mysql_fetch_array($sql_u))

                             {

                                    

                            

         $grid->render_sql("select * from shot,shotTaskArtist where shotTaskArtist.projID=shot.projID and shot.projID='".$_REQUEST['projid']."' and shotTaskArtist.shotID_new=shot.shotID order by shot.shotID asc","shot_task_id","checkEfficiency,overDue,difficulty,shotID_new,shotStatus,taskID,TaskREF,task_note,manDays,userID,taskStatus,startDate,endDate,task_priority,actualMandays,supervisorName,".$rows['headName']."");

        

        }//while    

        

     }


also i m add the code in sample.php file contain.


mygrid = new dhtmlXGridObject('gridbox');

        

        mygrid.setSkin("gray")

        mygrid.setImagePath("dhtmlxGrid/codebase/imgs/");

        mygrid.clearAll(0);

        //mygrid.attachHeader("Total Rows,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,-Total Actual Mandays,#cspan,#cspan,<div id=''>0</div>", ["text-align:left;"]);

    

    <?php     

                        $sql = mysql_query("SELECT headName,setcoltype from dummyHead WHERE projID='$projIDs'");

                            $countDummy = mysql_num_rows($sql);

                            if($countDummy<0)

                             {

                                     

                             ?>

                            

                             mygrid.setHeader("Check,Add,Del,ShotID,Shotstatus,TaskID,Taskref,Task-Note,Alloted Mandays,UserID,TaskStatus,StartDate,EndDate,Shot Priority,Actual Mandays,Supervisor");

                             mygrid.setColTypes("ch,link,link,ro,ro,ed,ed,txt,ed,ed,ro,dhxCalendarA,dhxCalendarA,dhxCalendarA,ed");

                            

                             <?php

                            }else {

                            while($rows = mysql_fetch_array($sql))

                            

                            {    

                            

                        ?>

    

        mygrid.setHeader("Check,Add,Del,ShotID,Shotstatus,TaskID,Taskref,Task-Note,Alloted Mandays,UserID,TaskStatus,StartDate,EndDate,Shot Priority,Actual Mandays,Supervisor,<?=$rows['headName']?>");

        



         <?php }

         }

     ?>

        

        

        mygrid.setColSorting(" , , ,str,str,str,str,str,str,str,str,date,date,int,int,str")

        mygrid.setColTypes("ch,link,link,ro,ro,ed,ed,txt,ed,ed,ro,dhxCalendarA,dhxCalendarA,dhxCalendarA,ed,ed,ed,ed");        

        

        mygrid.attachHeader(" , , ,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter, ,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter")

        mygrid.init();

        mygrid.enableSmartRendering(true);

    

[please tell me wht i do .


waiting for reply

thanks for previous help

$data = array();
while($rows = mysql_fetch_array($sql_u))
   $data[]=$rows['headName'];

$grid->render_sql(...supervisorName,".implode(",",$data));