Hi, Ok I 've two questions :)

1) I've to limit the results to a specific range (It's something like a spider search, where the user can select the page (and range) to display). Ok for that I use the limit expression:

SELECT * from tblads where x=y limit 10,10;

Well this displays the ads from 10 to 20

Ok but now I need to know what was the row count if wouldn't limit the result (It's normal that the user wants to know how many ads his query returned).

If possible I don't want to requery because the query can be very complicated and slow.

ok :)

2) When I do a SELECT *,some_slowfunction(x) from tblads join xx on w=y where n=s;

:)

Now what I want to know is: Is the some_slowfunction(x) function calculated before the where applies to the table?!

Or is the some_slowfunction(x) calculated on the resulting table?!

Last would be a lot faster of course, that's what I need to know :)

I hope someone can help me out :)

btw: I use php

Thanks in advance