End of Array - Formatting HTML

Marc_McIntire

Hello Everyone,

I am formatting the output of a database row array and need to detect the end of the array row to change my html formatting.

I have experimented with the array end() function and have not been able to come up with a workble solution.

I am thinking that i may need to creat a separate function that will load a variable in advance with the value of a field that is in the last row, that i can compare to later in the while statement.

If someone could post a possible example, I would appreciate it greatly.

Thanks,

Marc

ClarkF1

It would help if we could see your current code and then work from there

Marc_McIntire

Hello Again,

Here is some code that should help. What I am trying to do exactly is only place that <hr> tag between records, and not after the last record. Thus I am trying to detect when the while loop is at the end of the array.

Thank you for your help, i really do appreciate it.

Marc

<?php
require_once ('connect.inc.php');

$query = "SELECT * FROM carts";
$result = @($query);

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {

echo($row['id']) . "<br>\n";
echo($row['name']) . "<br>\n";

//if ( !($row['id'] == end($row)) ) {
//if(in_array($row['id'], $row)) {
//if($row['id'] == end($row)) {
	echo("<hr />\n");
//}

}

mysql_free_result($result);
mysql_close();
?>

Marc_McIntire

I had commented out some of the different approaches that I attempted in the code (if statements near the HR tag). Some of it is incomplete, or makes no sense after I changed it around, but I left it in there fr completeness.

Marc

NogDog

It might be easier to put the <hr> before each row, except for the first:

$hrFlag = FALSE;
while($row = mysql_fetch_array($result, MYSQL_BOTH)) {
  if($hrFlag)
  {
    echo "<hr />\n";
  }
  else
  {
    $hrFlag = TRUE;
  }
  // rest of code for processing result row....
}

Marc_McIntire

NogDog,

I can use your solution to accomplish what I was trying to do.

I would still sure like to know what would be the most elegant way to detect the end of an array is though. Have you got any suggestions that I might pursue to find the best solution?

Agin, thank you,

Marc

NogDog

The only way I know of is to create a counter variable and increment it each loop iteration. You can compare it each time to the value of msyql_num_rows() to see if you've reached the last record.