display group of data

[isaac_cm]

I have items table divided into groups and I have the sql but I do not know how to display each items group name once and not repeated for each items
for example:

Silk
  item 1
  item 2
  item 3

wool
  item 4
  item 5
  item 6

ans so on, any idea ? thanks

[HuggieBear]

Can you provide me with your column names?

Regards
Huggie

[isaac_cm]

date, main_group, sub_group, item name, quantity, price

[HuggieBear]

So silk and wool are sub groups or main groups?

Regards
Huggie

[isaac_cm]

yes they are main group and sub group for style only but I will figure out what to do to sub group if I know what to do to main group

[HuggieBear]

Try this then....

[code]<?php
$groupheader = null;
while ($row = mysql_fetch_array($result)){
  $group = $row['main_group'];
  if (is_null($groupheader) || strcmp($groupheader, $group) != 0){
      $groupheader = $row['main_group'];
      echo "<br>\n{$row['main_group']}<br>\n";
  }
  echo "{$row['item_name']}<br>\n";
}
?>
[/code]

You'll possibly need to change your SQL query.

Regards
Huggie

[isaac_cm]

thanks alot, do you know how to give the user tha ability to print the report without pressing next on each page

thanks again

[HuggieBear]

You haven't implied anywhere that your results are going to be on more than one page... Are they?

Regards
Huggie

[isaac_cm]

yes may be more than 30 pages, I know how to make next, previous button but when the user will go for printing it will be very frustrating

[craygo]

would better off having a link to print entire report, that way they can still print just the page they want if nessasary.

Post the code you are using now and i can insert the code for you.

Ray

[isaac_cm]

I did not make it yet I will use dreamweaver server behavior but I know
what you mean

I can pleace the your code in the right place

thanks

[craygo]

well the concept would be this

Can have a link or button to pass on the variable "printreport"

[code]<a href="<?=$_SERVER['PHP_SELF']?>?printreport=yes">Click here for entire report</a>[/code]

Then have this check on the page

[code]<?php
if(isset($_GET['printreport'])){
// query to select all records
$sql = "select * FROM table";
} else {
// query to select records by page
$sql = "SELECT * FROM table LIMIT x, x";
?>[/code]

Ray

[isaac_cm]

but would not be a very long page to display , I heared that there is another solution but using js, do you know it ?

thanks alot man