Re: [PHP-DB] What is the most efficient way to store SELECT results

Robert wrote: I want to store the results of a SELECT query in order to be able to page through those results and allow the user to select one, see it in more details and then return to the original list of results. What's the usual technique for doing this? place a get variable after the

Re: [PHP-DB] What is the most efficient way to store SELECT results

I'm not I was clear in my question. A query returns 1,000 rows from the table. I want to store the entire result of that query in order to be able to create separate pages to return the results rather than all on one page e.g. Page 1 2 3 4 ... . Not sure if it's important but I'm using

Re: [PHP-DB] What is the most efficient way to store SELECT results

Many sites just requery the database on each page and just return the relevant results. If you are using mysql, you can use LIMIT in your query to restrict the results for a specific page. You can also do something in similar in Oracle using nested queries and row ids. If the query is slow, you

[PHP-DB] Autorunning a file

Is there anyway to auto execute a PHP file? I'm working on a script that tracks activity and IPs of visitors, and then at a certain time daily emails me the results. Any idea of a way to do this? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Autorunning a file

Alexander wrote: Is there anyway to auto execute a PHP file? I'm working on a script that tracks activity and IPs of visitors, and then at a certain time daily emails me the results. Any idea of a way to do this? Use cron if you're on a linux/bsd based system or scheduled tasks if you're

Re: [PHP-DB] Autorunning a file

Alexander, Assuming you are on a *nix machine and php is installed in /usr/local you could schedule a cron job with the command: /usr/local/bin/php phpfile.php where phpfile.php is the file you want to execute. Hope this helps. Thanks, --Dustin Alexander wrote: Is there

[PHP-DB] insert several data for one customer

Hi, All, I have problem to insert several data for one customer. description: the customer buy some product example: customer= jojo. he buy= hat,coffee and milk problem: i confused for inserting data to mysql, because i just can insert only one product to mysql, i have already use an array

[PHP-DB] Fwd: insert several data for one customer

-- Forwarded message -- From: Fahmi Basya [EMAIL PROTECTED] Date: Oct 10, 2007 12:06 PM Subject: insert several data for one customer To: php-db@lists.php.net Hi, All, I have problem to insert several data for one customer. description: the customer buy some product example: