Drupal 6 Pager not working
Solved this problem by correcting the fourth argument of pager_query function i.e $product_count_query. 

Pager query takes the fourth argument as an SQL query to count the number of matching records.It should a valid sql query.