When using the UPDATE lsql_CatLinks SET CategoryID = 'new_id_number_for_category' WHERE CategoryID = 'old_cat_id_number' statement to move links from one category to another the following problem occurs:

• The browser does not show you the number of links in either category; rather it returns zero links the new directory and still the same value for the old
• After repairing tables and re-building, the static html pages still show the new category as having zero links, even the the new links are in fact in there.

Can someone tell me how to correct the number of links in the category tables, and how I could use this statement to move links and not upset the category counts?

Perhaps a two sql statement process to move links:

1. The statement above; followed by
2. UPDATE lsql_Category SET Number_of_Links....... not sure how to do this one
   
   
   I am assuming the Number_of_Links field in lsql_Category needs to be altered for each Category somehow when the move is done.
   
   
   Thanks in advance