if reached last row in query

[jamkelvl]

Trying to do something if last row in query has been reached.

 

All other code omitted.

 

<?php

				// get results
				while($row = mysql_fetch_array($result)){
					extract($row);
						// if last row display
						echo '('.$initials.' * 1);';
						// else 
						echo '('.$initials.' * 1) + ';									
				}

?>

 

Any help?

[Haberdasher]

Probably not the most efficient but it works

 

$Result = MySQL_Query("SELECT * FROM contacts WHERE active = '1'");
$num_rows = mysql_num_rows($Result);
print $num_rows.' Records<br><br>';
$i=1;
	while ($Row = MySQL_Fetch_Array($Result))
	{
		if ($i == $num_rows)
		{
			print 'This is the last row! '.$Row[p_id].'<br>';
		}
		else
		{
			print 'This is not the last row. '.$Row[p_id].'<br>';
		}
		$i++;
	}

 

Output:

 

2 Records

This is not the last row. 1
This is the last row! 2