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!
By using MYSQL_BOTH, you'll get an array with both associative and number indices. Using MYSQL_ASSOC, you only get associative indices (as mysql_fetch_assoc() works), using MYSQL_NUM, you only get number indices (as mysql_fetch_row() works).
It is repeating because you have a loop within another loop. If you place the code from news_mini.php where you have included it, you will see the news_mini.php is inside the while loop from news_inc.php
You will probably be able to combine everything into one page, which will be more efficient. Try this?
I am guessing that there are multiple entries in the news table for each type, but you only want the type line displayed once for each type?
Therefore you should either do SELECT DISTINCT type in your first query to get just one row for each different type, or for greater efficiency do a single query like f1nutter suggests but with one modification