Re: [PHP] only one at atime

2006-10-31 Thread Ahmad Al-Twaijiry
We have a virtual stock exchange site (for learning purpose) we put all the bids and offers in a table and every minute we run the php script to make the exchange but my customer want to make it less than 1 minute On 10/31/06, Ed Lazor [EMAIL PROTECTED] wrote: On Oct 30, 2006, at 10:14 AM,

Re: [PHP] only one at atime

2006-10-31 Thread Ahmad Al-Twaijiry
BTW: we use PDO functions to connect to the database and we also made the tables innodb type so if we use $dbh-beginTransaction(); is it will be safe to run the script more than one in the same time ? On 10/31/06, Ahmad Al-Twaijiry [EMAIL PROTECTED] wrote: We have a virtual stock exchange

Re: [PHP] only one at atime

2006-10-31 Thread Richard Lynch
On Tue, October 31, 2006 4:50 am, Ahmad Al-Twaijiry wrote: we use PDO functions to connect to the database and we also made the tables innodb type so if we use $dbh-beginTransaction(); is it will be safe to run the script more than one in the same time ? It should be safe from the

Re: [PHP] only one at atime

2006-10-31 Thread Ed Lazor
On Oct 31, 2006, at 2:29 AM, Ahmad Al-Twaijiry wrote: We have a virtual stock exchange site (for learning purpose) we put all the bids and offers in a table and every minute we run the php script to make the exchange but my customer want to make it less than 1 minute I can tell there's

[PHP] only one at atime

2006-10-30 Thread Ahmad Al-Twaijiry
Hi everyone, I create a php script that will run every minute (by cronjob) and update some database tables (php 5, database mysql 5, tables type innodb) the problem is that I want this script to run only one at atime (only one process from this script can run ) for example, if the cronjob

Re: [PHP] only one at atime

2006-10-30 Thread Brad Bonkoski
Ahmad Al-Twaijiry wrote: Hi everyone, I create a php script that will run every minute (by cronjob) and update some database tables (php 5, database mysql 5, tables type innodb) the problem is that I want this script to run only one at atime (only one process from this script can run ) for

Re: [PHP] only one at atime

2006-10-30 Thread Richard Lynch
On Mon, October 30, 2006 12:14 pm, Ahmad Al-Twaijiry wrote: I create a php script that will run every minute (by cronjob) and update some database tables (php 5, database mysql 5, tables type innodb) the problem is that I want this script to run only one at atime (only one process from this

Re: [PHP] only one at atime

2006-10-30 Thread Ed Lazor
On Oct 30, 2006, at 10:14 AM, Ahmad Al-Twaijiry wrote: Hi everyone, I create a php script that will run every minute (by cronjob) and update some database tables (php 5, database mysql 5, tables type innodb) the problem is that I want this script to run only one at atime (only one process