showORDER

[infatti]

I have a site that is using:

 

mysql_select_db($database_BFsite, $BFsite);

$query_news = "SELECT * FROM News ORDER BY showORDER ASC";

$query_limit_news = sprintf("%s LIMIT %d, %d", $query_news, $startRow_news, $maxRows_news);

$news = mysql_query($query_limit_news, $BFsite) or die(mysql_error());

$row_news = mysql_fetch_assoc($news);

 

to get results from a link:

 

<a href="newsDetails.php?ID=<?php echo $row_news['ID']; ?>"> more...</a>

 

But, I am only receiving results from the 1st row in the data table for all links.

 

Could this be because of a database identity problem? Here: mysql_select_db($database_BFsite, $BFsite);

 

Any ideas?

[mpharo]

You need to loop through the information with a while loop...something like this

 

<?

mysql_select_db($database_BFsite, $BFsite);

$query_news = "SELECT * FROM News ORDER BY showORDER ASC";

$query_limit_news = sprintf("%s LIMIT %d, %d", $query_news, $startRow_news, $maxRows_news);

$news = mysql_query($query_limit_news, $BFsite) or die(mysql_error());

 

while($row_news = mysql_fetch_assoc($news)) {

?>

<a href="newsDetails.php?ID=<?php echo $row_news['ID']; ?>">

 

<? } ?>