Report style page headers

[fmaestas]

Hello,
(a newbie here)

I'm trying to create a PHP report page that prints a customer name at the top of the screen, then all their related records from there on down. (It would need to print when the value changes).

What I have now is the customer name printed along with every new row that is displayed.

Since the customer name is the same for every record, I only need to display it once.

I'm using this:

while(list(
$custname,
$job1,
$job2)=mysql_fetch_row($result))

{
print "$custname";
print "$job1";
print "$job2";
}

I'm not sure where to place the customer field so it prints once.

Thanks!

Frank Maestas
[e-mail]

[piersk]

Instead of what you have written, try this:

<?php

while($row=mysql_fetch_row($result))
{
print "$row[0]";
print "$row[1]";
print "$row[2]";
}
?>

where $row is the array containing the results.

[jayant]

while(list($custname,$job1,$job2)=mysql_fetch_row($result)) {
if($lastcustname!=$custname) { print "$custname"; }
print "$job1"; 
print "$job2"; 
$lastcustname=$custname;
} 

simple eh ........ 😉

[fmaestas]

Thanks Jayant!

Beautiful, that did the trick.

Thank you.