RE: [PHP-DB] Working with large datasets

2011-10-10 Thread Thompson, Jimi
I really think that you should try running it from the command line and see what the issues are. Get both Apache and php out of the way. I've seen some PHP scripts use up all the file handles (OS limit) even on a 64 bit server when they start doing complex things with data sets. If it

[PHP-DB] Having a DUH Moment with mysql_fetch_array

2005-05-09 Thread Thompson, Jimi
Ok, I'm a PHP newbie and I'm having a problem. All I want to do is parse some information out of a database and send someone and email stating that their posting has been approved. I've verified that my SQL is indeed returning the correct value for $key, but when I go to fetch the array

[PHP-DB] Query for Most Recent Entry

2004-07-02 Thread Thompson, Jimi
Hi, I'm trying to figure out how to write a MySQL query that will return the highest primary key a table. Thanks, Ms. Jimi Thompson, CISSP Manager, Web Operations Cox School of Business Southern Methodist University What kind of peace do we seek? Not a 'Pax Americana' enforced

[PHP-DB] SQL Statement

2004-05-18 Thread Thompson, Jimi
For some background, I've been tasked with building a marketing tracking application by the PHB's who think that being able to write SQL means you can code. I know how to get data into a database and I can do thing with it once it's in there, but this is one of my first attempts at extracting