memory size exhausted error - Too much info back from query - what to do?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Gregory.Spencer@lycos.co.uk

    memory size exhausted error - Too much info back from query - what to do?

    Hi there,
    Using PHP and MYSQL I changed one of my MySQL search queries to allow a
    situation where the user gets much more information returned then
    previously

    However, it has now given me the error message:

    Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to

    allocate 42 bytes) in /usr/share/pear/DB/mysql.php on line 290

    OK I understand what this means (I assume) that the program is trying
    to
    allocate more memory to return my query result but it wont let it.

    However, I need this query to return this info, so what can I do?

    Any help / explanations appreciated.

    Kind regards

Working...