Page 1 of 1

Using LIMIT and WHERE clause

Posted: Tue Mar 28, 2006 8:45 pm
by GeXus
Is it posible to use a LIMIT with a WHERE clause? This is my code and it works fine, just not with the where..

Code: Select all

SELECT * FROM products LIMIT $limitvalue, $limit WHERE title LIKE '%$q%'
Thanks!

Posted: Tue Mar 28, 2006 8:57 pm
by feyd
Limit clauses follow where clauses. Not vice versa.