Hi,

When generating a LIST via SELECT AGAINST then LIMIT X, Y does not work.
That is if the SELECT statemenet is like:

SELECT ix_id, title, descpt FROM customers WHERE MATCH (title, descpt)
AGAINST('$find') LIMIT 90, 100

Rather than getting the results from 90 to 100 MySQL returns all 100 results!

So how can one pageinate in case of SELECT * AGAINST?

To put it another way, since MySQL returns all 100 values rather than from
90 to 100 only, how can we then effectively execute:

while ($result_chk_word = mysql_fetch_array($query_chk_word)) {

$url_id = $result_chk_word['ix_id'];
$title = $result_chk_word['title'];
$descpt = $result_chk_word['descpt'];

}


to list results for only 90 to 100?

Regards,