PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Todd_Z wrote:Timvw, that works perfectly, however, it takes sooo long to do. The load time for the page is unacceptably long. Is there anyway to do this much faster? Would it be better if i just caved and did it in php?
Are you using this SQL in a PHP app? If you are, the you can couple mysql_num_rows with the result, read that into a var and echo that var throughout your app instead of running this query over and over again. Also, what you are looking for might be better selected from an OUTER JOIN instead of an INNER JOIN.