Re: More frustration with MySQL and PHP

On Jan 21, 2008, at 3:02 PM, Eric Butera wrote:

On Jan 21, 2008 2:57 PM, Jason Pruim <japruim@raoset.com> wrote:

Today, I found a bug in my software which I was originally happy to find since that means there's one less that I have to worry about... 3 hours later while trying to figure out how to fix it I wish I never found it! Here's the deal, I have a file that exports the records in the database to excel, which works perfectly, except for 1 small thing... If you search the database first, it exports just those records. Basically what I need to do is allow people the choice of either exporting just certain search criteria, or the entire database without having to logout/login each time. I have tried using HTTP_REFERER to grab weither the user is coming from search.php (My search script) or directly from the index.php site which would mean they want the entire database. Nothing I have done has been successful, I either get just the search criteria exported, or I get the entire database depending on which version I try it from. Anyone have any ideas? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com japruim@raoset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Is there any obvious reason why you cant say export.php?set=all or export.php?set=search and make your export work off that?

The only reason is I hadn't even thought of that... Now with that small change it works just fine! I try so hard to NOT rely on the wealth of info available here, but you guys don't make it easy!! :)

-- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com japruim@raoset.com