Last result in a query?

[Solarpitch]

Hey,

 

I'm trying to print a different record for the very last result in a query, but this doesnt seem to work. I need to do this directly from the query like so.

 

When I echo the $num_rows = mysql_num_rows($result); it just has an empty value but there are values being returned.

 

<?php

function get_member_emails($type){

dbconnect();
$sql = "select email from member where type = '".$type."' AND email != ''";
$result = mysql_query($sql);
echo $num_rows = mysql_num_rows($result);

while(($row = mysql_fetch_row($result)) !== false) {
$inc = inc + 1;
if($inc = $num_rows)
{
echo $row[0]; //if last result print this
}
else
{
echo $row[0].", "; //else print this
}
}
    return $select;
}

?>

[Solarpitch]

Hey... can anyone help with this? Trying to figure out since I posted. Thanks  :'(

[sasa]

<?php

function get_member_emails($type){
   $inc = 0; //inicijal variable
   dbconnect();
   $sql = "select email from member where type = '".$type."' AND email != ''";
   $result = mysql_query($sql);
   echo $num_rows = mysql_num_rows($result);
   
   while(($row = mysql_fetch_row($result)) !== false) {
   $inc = $inc + 1; // add one $
   if($inc == $num_rows) // change = to ==
   {
   echo $row[0]; //if last result print this
   }
   else
   {
   echo $row[0].", "; //else print this
   }
   }
    return $select;
}

?>