hatrickpatrick Posted November 5, 2007 Share Posted November 5, 2007 This is the second part of my problems with a top ten list: I'm making a site for guitar effects. I'm trying to make a list of the top ten effects pedals, based on how many effects settings (patches) people have submitted for each pedal. There are two tables, pedals and patches: I want it to select patches and find out which "pedal_id" is most common, then select that pedal ID from pedals, echo some tuff, then do the query again, except search for the SECOND most popular value, echo it, then the third, echo it, etc etc etc Anyone know if this is possible? Link to comment https://forums.phpfreaks.com/topic/76095-getting-data-from-a-table-based-on-the-results-from-another/ Share on other sites More sharing options...
cooldude832 Posted November 5, 2007 Share Posted November 5, 2007 Probably an easier way but this will work <?php $id = "The Field you are counting"; $q = "Select ".$id." From `Table` Order by ID Desc"; $r = mysql_query($q) or die(mysql_error()); $temp = ""; $counts = array(); while($row = mysql_fetch_array($r)){ if($row[$id] != $temp){$counts[$row[$id]]++;} $temp = $row[$id]; } print_r($counts); ?> see what the $counts has for you. Link to comment https://forums.phpfreaks.com/topic/76095-getting-data-from-a-table-based-on-the-results-from-another/#findComment-385188 Share on other sites More sharing options...
hatrickpatrick Posted November 5, 2007 Author Share Posted November 5, 2007 Hang on a sec, what exactly does that code do? Doesn't look like it's what I need, since logically my list has to have 2 querys (one to find out the most popular product_id, then the other to search for that product_id in the other table...) Link to comment https://forums.phpfreaks.com/topic/76095-getting-data-from-a-table-based-on-the-results-from-another/#findComment-385219 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.