adding parameters to LIMIT clause of a SELECT

[yasser64]

I have the following prepared statement:\[code\]$sql = "PREPARE stmt_name FROM 'SELECT I.item_id, I.name , I.price, I.discounted_price, I.thumbnail_photo FROM item I JOIN sub_category SC ON I.sub_category_id = SC.sub_category_id JOIN category C ON C.category_id = SC.category_id WHERE C.category_id = ? LIMIT ?,? ' ; SET @p1 = categoryId; SET @p2 = firstItem; SET @p3 = items_per_page; EXECUTE stmt_name USING @p1,@p2,@p3; "\[/code\]which i changed to the following(wihtout using prepared statement)\[code\]$sql = 'SELECT I.item_id, I.name , I.price, I.discounted_price, I.thumbnail_photo FROM item I JOIN sub_category SC ON I.sub_category_id = SC.sub_category_id JOIN category C ON C.category_id = SC.category_id WHERE C.category_id =' . (int)$categoryId;\[/code\]I want to add parameters to the LIMIT clauseIve gone through some sites, and it seems that adding parameters to the LIMIT clause in a select statement can be done only by using prepared statements. Can I have your opinions and suggestions please?Thanks!