Mysql: Possible errors in queries "WHERE...IN" , "ORDER BY..." and "LIMIT" -

as have observed have put ambiguous title question, not realize (by lack of deep knowledge) if true problem or not.

let's start short description:

here select products:

    $select_prod = "select * product product_id in ($some_array)"; 

after here define pagination stuff:

    $query_page = mysql_query($select_prod);     $product_total = mysql_num_rows($query_page);              $page_rows = 4;             $last = ceil($product_total/$page_rows);             if ($page < 1) {                 $page = 1;              } elseif ($page > $last) {                $page = $last;              }             $limit = 'limit ' .($page - 1) * $page_rows .',' .$page_rows; 

and prepare render

    $page_query = mysql_query($select_prod . $limit);        $results = array();     while ($array_filter = mysql_fetch_array($page_query)) {             $results[] = $array_filter;             } 

until point flowing easily, , products listed wanted, in random order.

i have tried include "order price asc" @ end of first query this:

    $select_prod = "select * product product_id in ($some_array) order price asc"; 

but strange reason fails list products error:

    warning: mysql_fetch_array() expects parameter 1 resource, boolean given... 

i've had several hours in trying find problem, , forum seems final try me, after let them order want to.

you need print out full query directly before execution. try instead:

$select_prod = "select * product product_id in ($some_array) order price asc "; 

or, change limit line have space before limit.

what believe problem the lack of space before limit. snippet in ()limit 100 valid sql. snippet in () order price asclimit 100 not valid sql.