Trying to show total only

[rfigley]

This is probably a stupid question, haven't worked the code for a while. This code shows line by line according to query. Attempting to just show total member count. Left in all previous code, total count for $member_no doesn't come up. Assuming due to end of loop and the count not still being available?

Here is my code:

<?
 include('maillist1_dbconnect.php');
 echo "<link href=stylesheet.css rel=stylesheet type=text/css>";

$query = ("select * from smpro_list WHERE custfield3 != 'Prospect'  and  custfield3 != 'health and justice prospect'  and custfield3 != 'Guest'  and custfield2 != 'Guest' and custfield2 != 'health and justice prospect' and custfield2 != 'Prospect'  and listid = '1' order by custfield1");

$result = mysql_query($query) or die("Query fail");


if (mysql_num_rows($result) == 0)
{

} else
{

  echo "<CENTER>";
  echo "<font size=2 face=Arial, Helvetica, sans-serif>";
  echo "<table border=1 cellpadding=0 cellspacing=0 bordercolor=#CCCCCC>";
echo "<tr><td> " . "&nbsp" .  "<B>#" . "&nbsp" . "</td>
<td> " . "&nbsp" .  "<B>ID" . "&nbsp" . "</td>
<td> " . "&nbsp" .  "<B>First Name" . "&nbsp" . "</td>
          <td> " . "&nbsp" . "<B>Last Name" ."&nbsp" . "</td>
		  <td> " . "&nbsp" . "<B>Category" ."&nbsp" . "</td>

	  <td> " . "&nbsp" .  "<B>Chapter" .  "</B>" . "&nbsp" . "</td>" .  "</B>" . "&nbsp" . "</td>
	  <td> " . "&nbsp" . "<B>Phone" ."&nbsp" . "</td>
	  <td> " . "&nbsp" . "<B>Renewal" ."&nbsp" . "</td>
	  <td> " . "&nbsp" . "<B>Email" ."&nbsp" . "</td>
	  <td> " . "&nbsp" . "<B>Website" ."&nbsp" . "</td>

	  </tr>";
$member = 1;
  while($row = mysql_fetch_array($result))
    {

$member_ID = $row['member_ID'] ;
$ID = $row['ID'] ;
  $member_no = $member++;


    echo "<tr>";
	echo "<td><font size=2 face=Arial, Helvetica, sans-serif> " . "&nbsp " . $member_no ."&nbsp" . "<br>" . "</td>" ;
	echo "<td><font size=2 face=Arial, Helvetica, sans-serif> " . "&nbsp" . $row['id'] ."&nbsp" . "</td>" . 
	"<td><font size=2 face=Arial, Helvetica, sans-serif> " . "&nbsp" . $row['custfield0'] ."&nbsp" . "</td>" . 
		"<td><font size=2 face=Arial, Helvetica, sans-serif> " . "&nbsp" . $row['custfield1'] ."&nbsp" . "</td>" .
		"<td><font size=2 face=Arial, Helvetica, sans-serif> " . "&nbsp" . $row['custfield2'] ."&nbsp" . "</td>" .

	"<td><font size=2 face=Arial, Helvetica, sans-serif> " . "&nbsp" . $row['custfield3'] . "&nbsp" . "</td>" . 
	"<td><font size=2 face=Arial, Helvetica, sans-serif> " . "&nbsp" . $row['custfield4'] . "&nbsp" . "</td>"  ; 
	echo "<td><font size=2 face=Arial, Helvetica, sans-serif> " . "&nbsp" . $row['custfield6'] . "&nbsp" . "</td>"  ;   
		echo  "<td><font size=2 face=Arial, Helvetica, sans-serif> " . " " . $row['address']   . "</td>"; 

if ($row['custfield5'] == "")
{
	echo	"<td><font size=2 face=Arial, Helvetica, sans-serif> " . " "  . "&nbsp" . "website" . "&nbsp" . " " . "</td>";

}
else
{
	echo	"<td><font size=2 face=Arial, Helvetica, sans-serif> " . " " .  "<a href=\"http://{$row['custfield5']}\" class= 'bodytext'>" . "&nbsp" . "website" . "&nbsp" . "</a>" . " " . "</td>";
}


	"</tr>";


}

echo "</table>";

 }

?>
        </p>
</p>
      <table width="95%" border="1" cellspacing="0" cellpadding="0">
        <tr>
          <td>&nbsp;  <?  $member_no  ?> &nbsp; </td>
          <td>&nbsp; Member Count  &nbsp;</td>
          <td>&nbsp;</td>
        </tr>
      </table>

[bpat1434]

Use [man]mysql_num_rows/man to get the number of members that were returned...

But $member_no doesn't print because you need to echo it 😉 If you have short-tags enabled, then you can use <?= $member_no ?> or you can use <? echo $member_no ?> or <?php echo $member_no ?>

But you don't have to count during the iteration if you just use [man]mysql_num_rows/man 😉

[rfigley]

Thanks, knew it was something simple.

[bpat1434]

Odd thing is, you already called that function earlier in your script 😉

Don't forget to mark this as resolved if it is.