[Resolved] Printing only 1 repeating value from an array

[Nico]

I've got a query where date is an important part of the query, however I don't want every row to have the date field-- only if the date is different than the line before it.

i.e.

Date               Other Info           Other Info

2004/01/01     row result          row result
              row result         row result
              row result         row result
2004/01/02     row result         row result

If the date is the same for the proceeding array results, I don't want to print it. I know its an easy one but I can't find any snippets of when I've used it before and I can't remember how to set it up.

Thanx fer the help

Nico

[xDeadxBeatx]

Can you be more specific about what you want help with?

[swr]

You want to store the last date you printed, and only print a date when the data is different from the last date printed. Something like this:

$last_printed_date = '';
foreach ($query_results as $row) {
    $date = $row[0];
    $info1 = $row[1];
    $info2 = $row[2];
    if ($date == $last_printed_date) {
        $printdate = '';
    }
    else {
        $printdate = $date;
        $last_printed_date = $date;
    }
    echo "<tr><td>$printdate</td><td>$info1</td><td>$info2</td></tr>\\n";

}

You'll need to "order by date" (or similar) in your SQL query for it to work properly.

[Nico]

yep thats what I need, however in that format I can't get it to work.... This field is already in the middle of a loop. Here is the code for it:

<?
			$sql = mysql_query("SELECT $table2.emp_id,last_name,first_name,cur_date,time_saved,time_left,pay_type,
										manager,$table2.dept 
								FROM $table2 
								LEFT JOIN $table 
								ON $table2.emp_id=$table.emp_id 
								$where$date_query
								ORDER BY cur_date,dept,manager")
								or die(mysql_error());

		while($res = mysql_fetch_array($sql)) {
?>

	<tr>
		<td class=normal><?=$res['cur_date'];?></td>
		<td class=normal><?=$res['dept'];?></td>
		<td class=normal><?=$res['manager'];?></td>
		<td class=normal><?=$res['emp_id'];?></td>
		<td class=normal><?=$res['last_name'];?>, <?=$res['first_name'];?></td>
		<td class=normal><?=$res['time_left'];?></td>
		<td class=normal><?=$res['time_saved'];?></td>
		<td class=normal><?=$res['pay_type'];?></td>
	</tr><?  } ?>

the field in question is $res['cur_date'];

I just want to print each unique date only 1 time in that field.

thanx!

Nico

[razz]

while($res = mysql_fetch_array($sql)) {

// ADD THIS

 $cur_date = $res['cur_date'];
 $dept = $res[dept'];
 $manager = $res['manager'];
 $emp_id = $res['emp_id'];
 $cur_date = $res['cur_date'];
 $last_name = $res['last_name'];
 $first_name = $res['first_name'];
 $time_left = $res['time_left'];
 $time_saved = $res['time_saved'];
 $pay_type = $res['pay_type'];

// Then change the table to reference the short names

?>
TABLE CODE HERE

razz

[dave420]

Or, use this code instead:

$old_date="";
while($res = mysql_fetch_array($sql)) { 
if ($res["cur_date"]==$old_date) {
unset($res["cur_date"]);
} else {
old_date=$res["cur_date"];
}
?> 

    <tr> 
        <td class=normal><?=$res['cur_date'];?></td> 
        <td class=normal><?=$res['dept'];?></td> 
        <td class=normal><?=$res['manager'];?></td> 
        <td class=normal><?=$res['emp_id'];?></td> 
        <td class=normal><?=$res['last_name'];?>, <?=$res['first_name'];?></td> 
        <td class=normal><?=$res['time_left'];?></td> 
        <td class=normal><?=$res['time_saved'];?></td> 
        <td class=normal><?=$res['pay_type'];?></td> 
    </tr><?
}

[Nico]

wonderful-- thats exactly what I was looking for! Thanx for the help guys

Nico