如何每行仅显示一个用户信息. [英] how to display only one user info per row..

问题描述

嗨 我仅获得一个用户的多个记录...我需要每一行我只能有一个用户记录，而在下一行下一个用户
这是代码.
http://imageupload.org/?di=4129865848716 [

http://imageupload.org/?di=14129862588513 [解决方案

depsql =" SELECT hs_hr_leave .leave_date，hs_hr_leave.leave_status，hs_hr_leave.leave_comments，hs_hr_compstructtree.title，hs_hr_leavetype.leave_type_name，hs_hr_leavetype.leave_color，hs_hr_employee.emp_lastname，hs_hr_employee.emp_firstname，hs_hr_employee.emp_middle_name FROM hs_hr_leave INNER JOIN hs_hr_leavetype ON hs_hr_leave.leave_type_id = hs_hr_leavetype.leave_type_id INNER JOIN hs_hr_employee ON hs_hr_leave.employee_id = hs_hr_employee.employee_id INNER JOIN hs_hr_compstructtree ON hs_hr_leave.emp_depment = hs_hr_compstructtree.dept_id WsHER hs_hr_leave.emp_depment = 1;

depsql); if(mysql_num_rows(

hi i am getting multiply records for only one user ...i need that per row i can have only one user record and on next line next user
here is the code.
http://imageupload.org/?di=4129865848716[^link to sql image]

<<pre lang="xml">table >
<?php
$depsql = "SELECT hs_hr_leave.leave_date,hs_hr_leave.leave_status,hs_hr_leave.leave_comments,hs_hr_compstructtree.title,hs_hr_leavetype.leave_type_name,hs_hr_leavetype.leave_color,hs_hr_employee.emp_lastname,hs_hr_employee.emp_firstname, hs_hr_employee.emp_middle_name FROM hs_hr_leave INNER JOIN hs_hr_leavetype ON hs_hr_leave.leave_type_id = hs_hr_leavetype.leave_type_id INNER JOIN hs_hr_employee ON hs_hr_leave.employee_id = hs_hr_employee.employee_id INNER JOIN hs_hr_compstructtree ON hs_hr_leave.emp_depment = hs_hr_compstructtree.dept_id WHERE hs_hr_leave.emp_depment = 1";
$deprest = mysql_query($depsql);
if(mysql_num_rows($deprest) == 0){
echo "Sorry. No records found";
}else
{
while ($row = mysql_fetch_array($deprest, MYSQL_NUM)) {
    $leave_date      = $row[0];
    $leave_status    = $row[1];
    $leave_comments  = $row[2];
    $demp_title      = $row[3];
    $leave_type_name = $row[4];
    $leave_color     = $row[5];
    $emp_lname       = $row[6];
    $emp_fname       = $row[7];
    $emp_mname       = $row[8];
    $dbD = date("d", strtotime($row[0]));
    $dbM = date("m", strtotime($row[0]));
    $dbY = date("Y", strtotime($row[0]));
    $dbuser = date("Y-m-d", mktime(0, 0, 0, $dbM, $dbD, $dbY));
    $userDates[$dbuser] = array(''comments'' => $leave_comments, ''status'' => $leave_status,''color'' => $leave_color,''deptitle'' => $demp_title,''emplname'' => $emp_lname);
}
foreach($userDates[$dbuser] as $E) { ?>
<tr>
<td width="18%" colspan="2"><strong><?php echo $userDates[$dbuser][''emplname''] ?></strong></td>
<td width="12%" colspan="2"><strong><?php echo $userDates[$dbuser][''deptitle''] ?></strong></td>
<?php
    $num = cal_days_in_month(CAL_GREGORIAN, $DMonth, $DYear); // 31
    $arrydats = array_fill (1,$num,"");
    $i=0;
                foreach($arrydats as $d)
                {
                    $i++;
                    $dates = date("Y-m-d", mktime(0, 0, 0, $DMonth,$i, $DYear));
                    $checkdate = strtotime($dates);
                                 if(isset($userDates[$dates]))
                                   {
                                    echo "<td  width=''26'' title=''".$userDates[$dates][''comments'']."'' height=''20px'' bgcolor=''#".$userDates[$dates][''color'']."'' align=''center'' valign=''middle'' >";
                                    if($userDates[$dates][''status''] == -1)
                                        { echo "R"; }
                                    elseif ($userDates[$dates][''status''] == 0 )
                                        { echo "C"; }
                                    elseif ($userDates[$dates][''status''] == 1 )
                                        { echo "PA"; }
                                    elseif ($userDates[$dates][''status''] == 2 )
                                        { echo "A"; }
                                    elseif ($userDates[$dates][''status''] == 3 )
                                        { echo "T"; }
                                    elseif ($userDates[$dates][''status''] == 4 )
                                        { echo "W"; }
                                    elseif ($userDates[$dates][''status''] == 5 )
                                        { echo "SH"; }
                                        }
                                    else {
                                            echo "<td width=''26'' height=''20px'' align=''center'' valign=''middle'' >".$i."</td>";
                                            }

                }
}
?>
</tr>
</table>

http://imageupload.org/?di=14129862588513[^here you can see the screeshot]

解决方案

depsql = "SELECT hs_hr_leave.leave_date,hs_hr_leave.leave_status,hs_hr_leave.leave_comments,hs_hr_compstructtree.title,hs_hr_leavetype.leave_type_name,hs_hr_leavetype.leave_color,hs_hr_employee.emp_lastname,hs_hr_employee.emp_firstname, hs_hr_employee.emp_middle_name FROM hs_hr_leave INNER JOIN hs_hr_leavetype ON hs_hr_leave.leave_type_id = hs_hr_leavetype.leave_type_id INNER JOIN hs_hr_employee ON hs_hr_leave.employee_id = hs_hr_employee.employee_id INNER JOIN hs_hr_compstructtree ON hs_hr_leave.emp_depment = hs_hr_compstructtree.dept_id WHERE hs_hr_leave.emp_depment = 1";

deprest = mysql_query(

depsql); if(mysql_num_rows(

这篇关于如何每行仅显示一个用户信息.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！