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,
<?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