Warning missing argument

[masprema]

When I try to place an order I get this message:

Warning: Missing argument 4 for splitpageresults() in /hsphere/local/home/ramram/suryatrading.com/catalog/includes/classes/split_page_results.php on line 24

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.products_id' at line 1

 

select count(*) as total p.products_id

 

I have no idea what to do. Can anyone help?

Thank you,

Pickett

[masprema]

this solution was suggested, but doesn't help

 

 

$offset = ($max_rows_per_page * ($current_page_number - 1));

if($offset<0)

{

$offset=0;

}

$sql_query .= "limit" . $offset .", " . $max_rows_per_page;

}