I was asked that the output file should only output the name and id of the last person who uploaded a file with a specific name. confusing right? even I am confused. so let me give an example
let us say that you have 3 employees registered in your company. lets call them
- Pikachu,
- Raichu and
- Pichu.
Pikachu has 3 files uploaded in the company, Raichu has 2 files uploaded and Pichu has also 2 files uploaded. The files must also be ordered according to employeename(ASC) and filename(DESC). Mine is already in ordered by. This is my only problem. In this case the output should look like this:
*noticed that the employee name and employee id is in the last file uploaded?? does anyone knows how to do that?please i beg you guys to help me out here T-T the task is way too hard and im just a rookie
Im thinking of using 2 tables here. table 1 for the employee id and employee name, table 2 for the file name, etc. so i guess this would also involve 2 while clause. i have the idea but i dont know how to mix them all up.
my code before I edited it like sir vincent look like this:
if ($_SESSION[$fgmembersite->GetLoginSessionVar()] == 'sa'
OR $_SESSION[$fgmembersite->GetLoginSessionVar()] == 'admin')
{
$sql= "select * from gmdc_employee
where employee_name like '%$search%'
AND employee_name like '$listname%'";
} else {
$sql = "select b.* from gmdc_user a, gmdc_employee b
where a.username = '".$_SESSION[$fgmembersite->GetLoginSessionVar()]."'
AND a.company_id = b.company_id
AND b.employee_name like '$listname%'
AND b.employee_name like '%$search%'";
}
$query = mysql_query("$sql ORDER BY employee_name,confirmation DESC
,file_id DESC,file_date DESC
LIMIT $offset,$limit") or die ( mysql_error () );
$result = mysql_query($sql) or die (mysql_error());
$total = mysql_num_rows($result);
if(!$result || mysql_num_rows($result) <= 0)
{
$fgmembersite->HandleError("No file found.");
return false;
}
while ($row = mysql_fetch_assoc($query))
{
$file_id = $row['file_id'];
$file_desc = $row['file_description'];
$file_date = $row['file_date'];
$file_name = $row['file_name'];
$file_accs = $row['folder_access'];
$file_employee = $row['employee_id'];
$file_confir = $row['confirmation'];
$file_ename = ucwords($row['employee_name']);
$info = pathinfo($file_name);
$file_ext = $info['extension'];
echo '<tr><td> </td></tr>
<tr class="subone"><td class="sub" width="100">'.$file_employee.'<br />
</td>';
if($_SESSION[$fgmembersite->GetLoginSessionVar()] == 'sa')
{
?>
<td class="sub" width="100">
<a href="" onclick = javascript:newPopup('addfile.php?emp=
<?php echo $file_employee ?>');><?php echo$file_ename?></a>
<br /> </td>
<?php
} else {
echo '<td class="sub" width="182">'.$file_ename.'<br /> </td>';
}
echo'<td class="sub" width="218">
<a href="'.$file_accs.$file_name.'" target="_blank"
style="text-decoration: underline;">'.$file_desc.'</a>
<br /> </td><td class="sub" width="100">
'.date('M d, Y',mktime(0,0,0,substr($file_date,5,2)
,substr($file_date,8,2),substr($file_date,0,4))).'
<br /> </td><td class="sub" width="100">'.$file_confir.'
<br /> </td>';
if($_SESSION[$fgmembersite->GetLoginSessionVar()] == 'sa')
{
if($file_confir == 'Pending' OR $file_confir == 'NotApproved')
{
if(isset($_GET['id']))
{
$fgmembersite->Delete_Db($_GET['id']);
}
echo '<td class="sub" width="100">
<a href="index.php?id='.$file_id.'">Delete</a>
<br /> </td>';
}
}
else if($_SESSION[$fgmembersite->GetLoginSessionVar()] == 'admin')
{
if($file_confir == 'Pending')
{
if(isset($_GET['yes']))
{
$fgmembersite->UpdateYesDB($_GET['yes']);
//echo "<script>location.reload();</script>";
}
else if(isset($_GET['no']))
{
$fgmembersite->UpdateNoDB($_GET['no']);
//echo "<script>location.reload();</script>";
}
if (!isset($_GET['offset'])) {
$prevoffset = 0;
} else {
$prevoffset = $_GET['offset'];
echo'<td class="sub" width="100">
<a href="index.php?offset='.$prevoffset.'&searchfile='.$search.'
&namelist='.$listname.'&yes='.$file_id.'">Approve</a>
//there's a link here<br /><br />
<a href="index.php?offset='.$prevoffset.'&searchfile='.$search.'
&namelist='.$listname.'&no='.$file_id.'">NotApprove</a>
//there's a link here
</td> ';
}
}
}?>
Just ignore every if($_SESSION[$fgmembersite->GetLoginSessionVar()] == 'admin')
and whatever, this is for different output since my file can be logged into by 3 different users. SA(programmers), admin(the approver of the file uploaded), and user(company). There are TD and TR there as well, I don't know why wont it appear here.
output looked like this:
employee_id + employee_name + file_name
3 | pichu | file6
3 | pichu | file1
1 | pikachu | file7
1 | pikachu | file4
1 | pikachi | file3
2 | raichu | file8
2 | raichu | file5
2 | raichu | file2
and I want my output to be like this:
***OUTPUT***
**employee_id employee_name file_name**
3 pichu file6
file1
1 pikachu file7
file4
file3
2 raichu file5
file2
for example that raichu uploaded another file, the output should now look like this:
OUTPUT
**employee_id employee_name file_name**
3 pichu file6
file1
1 pikachu file7
file4
file3
2 raichu file8
file5
file2