keevitaja Posted November 2, 2011 Share Posted November 2, 2011 there are 3 tables campaigns id int cp_contacts id int campaign_id int cp_friends id int cp_contact_id i need to retrieve all rows from campaigns and add how many contacts campaigns has total and how many friends total connected to campaigns thrugh contacts . i can get out the cp_contacts count with left join. can anyone help me? Link to comment https://forums.phpfreaks.com/topic/250314-need-help-with-mysql-query/ Share on other sites More sharing options...
Wiro Blangkon Posted November 2, 2011 Share Posted November 2, 2011 Hello Keevitaja, Can you (1) show us the join you use and (2) tell us in simple, non-MySQL, English what information you want to retrieve from the database? Wiro Blangkon. Link to comment https://forums.phpfreaks.com/topic/250314-need-help-with-mysql-query/#findComment-1284400 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.