Can somone help me with a function thank you

[jer001]

There is an error repeating only one of the specials continuing untill server drops please help thank you

 

Function to display Specials in a menu...

 

 

<!-- Specials Menu Bar 3 -->

 

<li class="menu3"><a href="#"><em></em>Specials</a>

<ul>

 

<?php

 

function tep_show_category_menu_special($parent_id) {

$row = 0;

$col = 0;

$special_sql = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC";

$categories_query_special = tep_db_query($special_sql);

 

 

 

 

 

while ($specials = tep_db_fetch_array($categories_query_special)) {

 

 

echo "<LI class='navigate'>";

echo "<a href='product_info.php?products_id=" . $specials['products_id'];

if($parent_id ==0 ) echo "";

echo "'>".$specials['products_name']."</a></li>";

tep_show_category_menu_special($specials['products_id']);

 

$col ++;

if ($col > 2) {

$col = 0;

$row ++;

}

}

 

 

}

 

 

 

tep_show_category_menu_special(0);

 

?>

</ul>

 

</li>

[jer001]

Sorry I was calling the function within the function i fixed it thank you

[ydhcxh]

wow,wrong calling the function within it's self