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

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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

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
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

Site Timeline