Count script only returns 0

[patk570]

I am trying to do a count of all types in there(hardware and software) I thought i had the correct structure...but I guess i am wrong...

$count = mysqli_query($mysqli, "SELECT COUNT(*) AS total_count FROM assets WHERE cust_id=$custID AND (asset_type='hardware' AND asset_type='software') ");
echo mysqli_error($mysqli);
$count = mysqli_fetch_object($count);
$count = $count->total_count;

any help would be great..

[patk570]

Fixed it:

$count = mysqli_query($mysqli, "SELECT (SELECT COUNT(*) FROM assets WHERE cust_id=$custID AND asset_type='hardware') + (SELECT COUNT(*) FROM assets WHERE cust_id=$custID AND asset_type='software') AS total_count");
echo mysqli_error($mysqli);
$count = mysqli_fetch_object($count);
$count = $count->total_count;