Problem with array fetch

[drums]

I have a script that was done for my client on one site and I want to add it to other sites as well. I am able to write to the dB but retrieving the data only brings in one column. Can anyone tell me what I am doing wrong?
[code]<?
$query=mysql_query("select * from xlsdata where date='6/13/2006'");
while($record=mysql_fetch_array($query))
    $headingname = $record['heading'];
    $titlename = $record['title'];
    $bodyname = $record['body'];
    $imagename = $record['image'];
    $footername = $record['footer'];
?>
<h1><?=$headingname?></h1>
<h2><?=$titlename?></h2>
<?=$bodyname?>
<br><img src="images/<?=$imagename?>" border="0" alt="<?=$imagename?>"><br><strong><?=$footername?>[/code]
The only thing that shows is the heading.
Thanks.

[drums]

Didn't have the squiggly brackets:
[code]{    
$headingname = $record['heading'];
    $titlename = $record['title'];
    $bodyname = $record['body'];
    $imagename = $record['image'];
    $footername = $record['footer'];
}
[/code]
Thanks go to Lycander at LittleBlackDog.com

[fenway]

Common mistake... I've always said that blocks without explicit curlies shouldn't even compile (cf. Perl).