[SOLVED] couting records

[DrTrans]

$query2 = "COUNT * FROM property WHERE Owner_ID = '$ownerid'";
$result2 = mysql_query($query2);
        
print"<b>Amount of Properties Owned:</b> $result2";

 

Basically i want it to count how many times it finds that match and display a number.

[merck_delmoro]

try this

$query2 = "SELECT * FROM property WHERE Owner_ID = '$ownerid'";
$result2 = mysql_query($query2);

echo "<b>Amount of Properties Owned:</b>".count($result2);

[DrTrans]

That gives a value of "1" but i know in the database there are 7 records.

[kickstart]

Hi

 

Try this:-

 

$query2 = "SELECT COUNT(*)  FROM property WHERE Owner_ID = '$ownerid'";
$result2 = mysql_query($query2);
if ($row(mysql_fetch_array($result2))) print"<b>Amount of Properties Owned:</b> ".$row[0];

 

All the best

 

Keith

[merck_delmoro]

my mistake the one that I count is the query not its records inside the query the Post DrTrans was correct

[DrTrans]

Neither of these solutions have worked

[DrTrans]

in responce to kick:

 

Fatal error: Function name must be a string

 

 

[kickstart]

Hi

 

Err, doh.

 

$query2 = "SELECT COUNT(*)  FROM property WHERE Owner_ID = '$ownerid'";

$result2 = mysql_query($query2);

if ($row = mysql_fetch_array($result2)) print"<b>Amount of Properties Owned:</b> ".$row[0];

 

Sorry.

 

All the best

 

Keith

[DrTrans]

Thanks man, I completely didnt even notice the = was missing either.. Im sitting here like WTF

Thanks ..