NYCPHP Meetup

[Phil Powell]

John Lacey wrote:

>
> prolly got a Cartesian product in the query... 


Actually, some of the queries could be producing Cartesian products, but 
there are those that simply have this:

SELECT id, fname, lname, gpa, major, minor FROM interns ORDER BY lname, 
date desc

For queries such as these (this is one of the queries that has on 
occasions thrown the Fatal Error upon attempt to use mysql_query() upon 
this statement (occurs in about 5 different scripts now).

Phil

>
> that'll eat the 8MB
>
> Hans Zaunere wrote:
>
>>> The following occurs when we query records on the 'interns' table:
>>>
>>> Fatal error: Allowed memory size of 8388608 bytes exhausted (tried 
>>> to allocate 40 bytes) in ../intern.inc on line 1135
>>
>>
>>
>> Show me line 1135 and a couple lines surrounding it - I bet this isn't a
>> MySQL error.
>>
>> See http://us3.php.net/ini_set and search the page for memory_limit -
>> notice it's 8M by default.  Thus, it's probably a PHP error and sloppy
>> code.
>>
>> H
>>
>> _______________________________________________
>> talk mailing list
>> talk at lists.nyphp.org
>> http://lists.nyphp.org/mailman/listinfo/talk
>>
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
>


-- 
Phil Powell
Web Developer
  ADNET Systems, Inc.
  11260 Roger Bacon Drive, Suite 403
  Reston, VA  20190-5203
Phone: (703) 709-7218 x107   Cell: (571) 437-4430   FAX: (703) 709-7219
EMail:  Phillip.Powell at adnet-sys.com      AOL IM: SOA Dude