COUNT(*) Error... I think?

chads2k2

Hey thanks for viewing this. I have a problem (amoung many 😉) Which I am sure someone here knows. Check this out ::

$sql7 = "select COUNT(*) from brokers where status='Active'";
$brokernumber = mysql_query($sql7);

Connection and everything is ok and connected correctly. So don't worry about that. Yes the table is named brokers and there is a field named status and yes atleast one has Active in it. Now I tried to do a
<?php
echo "$brokernumber";
?>

All the other COUNT(*)'s I have done like this work fine... But when I do two more it just gives me this saying "Resource id #10" where the variable is. Great.. Now what does this mean? The other ones I did I added together and got the answer and put it back out. I have tired doing:

$sql7 = "select COUNT(*) from brokers where status='Active'";
$brokernumber = mysql_query($sql7);
$brokernumbers = $brokernumber;

<?php
echo "$brokersnumbers";
?>

Still no luck. Do I have to add something to it to get an accurate reading out of it? Thank you very much and have a great day!

Chad R. Smith

chads2k2

$sql7 = "select COUNT(*) from brokers where status='Active'";
$numberofbrokers = mysql_query($sql7);
$finalbroker = $numberofbrokers + 0;

That gives me 10! There is 1 (ONE) broker in there that has Active status. I forgot to mention I have SSHed into the box and ran the query from the mysql> prompt and it returned 1. So I know that its the right syntax and such. SO.. I have no idea now.

Chad R. Smith

chads2k2

Here is how you do it:

$sql1 = "select COUNT() from brokers where status='Active'";
$result1 = mysql_query($sql1);
while ($row = mysql_fetch_array($result1)) {
$finalbrokers = $row['COUNT()'];
}

<?php
echo "$finalbrokers";
?>

The reasons for this is because MySQL acts like its its own field. So when I was trying to call it out then it just said no. It numbers itself by how many SQL statements it has to make. So when I got 10 is because it was the 10th SQL statement on the page. So that is how it all works.

Chad R. Smith

spectre013

try doing your query this way

<?
$sql1 = "select COUNT(*) as finalbroker from brokers where status='Active'"; 
$result1 = mysql_query($sql1); 
while ($row = mysql_fetch_array($result1)) { 
$finalbrokers = $row[finalbroker']; 
} 

<?php 
echo "$finalbrokers"; 
?>

mrmufin

$sql = "select COUNT(*) from brokers where status='Active'"; 
$result = mysql_query($sql); 
if($result) {
	// You're dealing with a single row 	result. No need for the while() loop:
	$row = mysql_fetch_row($result);
	$active_brokers = $row[0];
}

chads2k2

hey. Thanks everyone and nice to see you Mr.Muffin I remember you from the old forum. Yes I figured it out and it works. Thanks though!

Chad