Help with formatted output

bruceg

Currently, my report looks similar to this:

ID DATE PRESS TYPE REF DESC

1 2001-07-05 5 TP 2 TEST DESC
1 2001-07-06 6 TP 2 ANOTHER DESC
2 2001-07-05 5 TP 2 DESC
2 2001-07-05 6 TP 2 DESC
3 2001-07-05 3 PA 3 DESC
3 2001-07-05 3 PT 3 DESC
3 2001-07-05 3 PP 5 DESC
3 2001-07-06 3 PP 4 DESC

I would like the report to report the ID once for each, similar to this:

ID:1

DATE PRESS TYPE REF DESC

2001-07-05 5 TP 2 TEST DESC
2001-07-06 6 TP 2 ANOTHER DESC

ID:2

DATE PRESS TYPE REF DESC

2001-07-05 5 TP 2 DESC
2001-07-05 6 TP 2 DESC

ID:3

DATE PRESS TYPE REF DESC

3 2001-07-05 3 PA 3 DESC
3 2001-07-05 3 PT 3 DESC
3 2001-07-05 3 PP 5 DESC
3 2001-07-06 3 PP 4 DESC

Here is my current select statement:

$sql = "
SELECT *
FROM $tableName,
$tableName2
WHERE anilox.anxid = anxtxn.txid
ORDER BY anxid
";

Thanks for any help!

Bruce

reagent

some pseudo code:
use a var to keep track of the last id you fetch, initially set this to 0 or some other number that will not appear as an id in the database

loop over your records and for each one, check to see if the id is the same as the last one. if it is the same, print out a line of data. if it is different, print out your ID: line and the header..

hth.
p.

bruceg

I'll give it a try - thanks for the help!

bruceg

Could you give a little sample code of how this would work? I cannot seem to get my code to do what I want.

Thanks..

reagent

ID DATE PRESS TYPE REF DESC

thats the data you have. i'll assume you are using this to get your records:

$iLastId = -1;
while ($arrData = mysql_fetch_array($result)) {
if ($iLastId != $arrData['ID']) {
print str_repeat('*', 20)."\n";
print "ID: ".$arrData['ID']."\n\n";

print "ID DATE PRESS TYPE REF DESC\n";
print "-- ---------- ----- ---- --- ----\n";
}
print $arrData['ID']." ";
print $arrData['DATE']." ";
print $arrData['PRESS']." ";
print $arrData['TYPE']." ";
print $arrData['REF']." ";
print $arrData['DESC']."\n";

$iLastId = $arrData['ID'];
}

bruceg

Yes, very similar. Sorry I didn't post it.