Jump to content

Archived

This topic is now archived and is closed to further replies.

drums

Problem with array fetch

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
Common mistake... I've always said that blocks without explicit curlies shouldn't even compile (cf. Perl).

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.