How to display cross join query in html

[imi_99]

I have one cross join query, which if run in mysql then show the result like shown on this address

http://www.whatahome.co.uk/test.html

In the result it select heading_title three times but I want to use query in html that it shows heading_title once. I know how to do with ASP but not sure with php. any idea.
thanks

[Weedpacket]

How would you do it in ASP?

[imi_99]

Weedpacket wrote:

How would you do it in ASP?

while ($row=mysql_fetch_array($result))
{
$heading;
if($heading!=$row['1'])
{

echo "first heading from table 1";
$heading=$row['1'];

}

echo "result from table 2";

}

[imi_99]

SELECT heading_title, opening_day, opening_time FROM heading_openinghour CROSS JOIN timetble
WHERE heading_openinghour.heading_id=timetble.heading_id;

while ($row=mysql_fetch_array($result))
{
$heading;
if($heading!=$row['0'])
{
echo $row['0'];
$heading=$row['0'];
}

echo $row['1'];
echo $row['2'];

}

I am using cross join query to select heading from first table
and sub headings from second table.The query works fine but I want to run
query in a way that when query finish printing one heading and all
of its sub heading then it print an extra text field under that sub headings and
then next line starts.
any idea how to do this.

Example

heading1
sub heading1
sub heading2
sub heading3
insert text field here

heading2

sub heading1
sub heading2
sub heading3
sub heading4
sub heading5
insert text field here

heading2

sub heading1
insert text field here