i am trying pagination for my search page results .
but i am getting errors because of more sql queries in scripts.
if there is one query i can get the results.
plz help in this regard.
i am attaching my codes below.
i have removed the pagination code from the code for below attachments and made it simple.