BadGoat Posted September 5, 2007 Share Posted September 5, 2007 Hi! I am trying to count the # of instances where an ID appears in a table. I have a city table where each city has an id and a region id, a region table where the region has an id. I want to be able to count the # of cities are in a region by id. Everything I've tried is either 0 or 4, no clue how I got 4, even though I verified that none of the regions had only 4 cities. Here's a bit of code, where I'd been trying to get it to work. <tr> <td>'.$row['region'].' contains '; $query1 = "SELECT SUM(region_id) AS totalcons FROM e_city WHERE region_id = '$region_id'"; $result = mysql_query($query1); $r = mysql_fetch_array($result); echo number_format($totalcons); echo' Cities.</td> </tr> Please point me in the right direction. Thanks! Link to comment https://forums.phpfreaks.com/topic/68111-solved-how-to-count-the-if-instances-an-id-is-in-a-table/ Share on other sites More sharing options...
lemmin Posted September 5, 2007 Share Posted September 5, 2007 If you just count the results that have that region id, wouldn't that be correct? "SELECT count(cityid) as citycount FROM cities WHERE regionid = 1"; Link to comment https://forums.phpfreaks.com/topic/68111-solved-how-to-count-the-if-instances-an-id-is-in-a-table/#findComment-342356 Share on other sites More sharing options...
BadGoat Posted September 6, 2007 Author Share Posted September 6, 2007 OK, I see that COUNT is the right choice. Now when I want to echo the count, is it this? echo count($citycount); Link to comment https://forums.phpfreaks.com/topic/68111-solved-how-to-count-the-if-instances-an-id-is-in-a-table/#findComment-342887 Share on other sites More sharing options...
supanoob Posted September 6, 2007 Share Posted September 6, 2007 no i think it would be echo "$count"; Link to comment https://forums.phpfreaks.com/topic/68111-solved-how-to-count-the-if-instances-an-id-is-in-a-table/#findComment-342890 Share on other sites More sharing options...
sasa Posted September 6, 2007 Share Posted September 6, 2007 echo $r['citycount']; Link to comment https://forums.phpfreaks.com/topic/68111-solved-how-to-count-the-if-instances-an-id-is-in-a-table/#findComment-342898 Share on other sites More sharing options...
BadGoat Posted September 6, 2007 Author Share Posted September 6, 2007 sasa, you rock! Link to comment https://forums.phpfreaks.com/topic/68111-solved-how-to-count-the-if-instances-an-id-is-in-a-table/#findComment-342902 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.