[Resolved] Displaying a list of records

[klik]

I have links which are stored in a database table.

I'd like to list all of them, each with all their attributed siplayed.

<?php

$result = mysql_query("SELECT * FROM cms_links WHERE link_activated='1' AND link_type='standard'");

while ($myrow = mysql_fetch_array($result)) {

	printf($myrow["link_name"], $myrow["link_url"], $myrow["link_description"], $myrow["link_click_count"], $myrow["link_date_added"], $myrow["link_last_modified"], $myrow["link_member"]);

}

?>

I thought this was the way to do it, but a lot of the information is not being displayed.

Any help would be greatly appreciated.

[devinemke]

$result = mysql_query("SELECT * FROM cms_links WHERE link_activated = '1' AND link_type = 'standard'");
while ($row = mysql_fetch_assoc($result))
{
	echo
	$row['link_name'] . '<br>' . 
	$row['link_url'] . '<br>' . 
	$row['link_description'] . '<br>' . 
	$row['link_click_count'] . '<br>' . 
	$row['link_date_added'] . '<br>' . 
	$row['link_last_modified'] . '<br>' . 
	$row['link_member'] . '<br><br><br>
	';
}

[klik]

Thanks a lot.

You've helped me a lot the last few days Devinemke.

Appreicate it!