[fraggle]

this is my query

$query = "select f1,f2 FROM tablename ORDER By f3 DESC, RAND() limit $offset, $limit WHERE f5='$search'";

result
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource

if i remove the WHERE f5='$search' it works fine, but i need to narrow the results by matching f5 with $search

Thanks in advance

[NeverMind]

the answer is easy
because LIMIT should be the last thing in your query.

PHP Code:

$query = "select f1,f2 FROM tablename WHERE f5='$search' ORDER By f3 DESC, RAND() LIMIT $offset, $limit"; 

[fraggle]

that did the trick, but now my pagination does not work, page 2 onwards has no results?? it pulls back the correct number of pages/links that there sould be....but noting appears.
and if i remove the Where condition - it works perfectly, I get pages and pages of results

Help........

[NeverMind]

are you sure that $search and $offset are passed to the next pages?
also, why would you use RAND() in the ORDER BY ?

[fraggle]

they are if I leave out the WHERE condition

RAND() is there to give equal chance for results to be displayed(the records are contact details)

[fraggle]

anyone got any ideas?