How to display?

[Anon]

the records are displayed in the following way:
(sql=select * from xxx order by number asc)

Number
1
1
2
3
3
3

Can i change it to display in this way?
Number
1
1

Number
2

Number
3
3
3

if yes, what should i change in the code? thanks!!

[ricgomez]

You can't with only a sql statment. You need to code some php.
You can do something like:

$sql="select * from xxx order by number asc"

$flag = "";
while (more rows to fecth) {
$row = fetch next row

if ($row[0] != $flag) {
echo("Number <BR>");
$flag = $row[0];
}
echo("$row[0]<BR>");
}

Hope it helps