Improved Code.

No need to use $new_prods_content variable to store html and then echo it.
We can do it directly.
Also no need for $num_new_products since its only used once and so we can make directly comparison if (tep_db_num_rows($new_products_query) > 0) {