[PHP-DB] INNO tables - will I have problems?

2004-10-13 Thread Julian Madle
Hi, I'm prety new to PHP and MySQL (but have many years of Perl and ASP programming). I need to code a PHP version of one of our ASP products - in looking through the MySQL manual, I find that it supports cascades when using INNO tables. This is very close to our Access/MSSQL database in ASP,

Re: [PHP-DB] INNO tables - will I have problems?

2004-10-13 Thread Gerard Samuel
Julian Madle wrote: I obviously have no control of which ISP and end-user may choose, although our product will specify that Linux, PHP4, and MySQL4 (or higher) are installed. The manual says that these are built-in on version 4.0 and above - I just need real-world confirmation from people with

Re: [PHP-DB] INNO tables - will I have problems?

2004-10-13 Thread jon
To quote the Mighty Gerard Samuel [EMAIL PROTECTED]: Julian Madle wrote: I obviously have no control of which ISP and end-user may choose, although our product will specify that Linux, PHP4, and MySQL4 (or higher) are installed. The manual says that these are built-in on version 4.0 and

Re: [PHP-DB] INNO tables - will I have problems?

2004-10-13 Thread dpgirago
[EMAIL PROTECTED] 10/13/2004 12:11 PM To: [EMAIL PROTECTED] cc: Subject: Re: [PHP-DB] INNO tables - will I have problems? To quote the Mighty Gerard Samuel [EMAIL PROTECTED]: Julian Madle wrote: I obviously have no control of which ISP and end-user may choose, although our

Re: [PHP-DB] INNO tables - will I have problems?

2004-10-13 Thread Gerard Samuel
[EMAIL PROTECTED] wrote: If the minimum requirement of mysql is version 4, then you will have no problems, as INNODB is the default type in mysql 4.x.x -- InnoDB is included by default in mysql 4 but the default is still MyISM. I looked over the manual, and I believe that you are correct. The

Re: [PHP-DB] INNO tables - will I have problems?

2004-10-13 Thread dpgirago
right, so after you define the fields of the table, you add type=innodb simple as that dave Gerard Samuel [EMAIL PROTECTED] 10/13/2004 02:34 PM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [PHP-DB] INNO tables - will I have problems? [EMAIL

[PHP-DB] MySQL, Multiple tables, and Multipage form using sessions

2004-10-13 Thread Stuart Felenstein
Can anyone, someone please point me in the right direction. I have a multi page form, so at the last page I want to insert all data into database. Basically I'm trying to go from 0 - 90 , meaning my skills are less the basic. And this seems like a big task. Couple of other things. 1-There would

[PHP-DB] PHP versions - Development server live server...

2004-10-13 Thread Peter Borcherds
Hi all, First of all, apologies if this is posted more than once...I'm having trouble with my newsreader!! I am running Win XP Pro as my development machine - at present I have PHP 4.3.4 installed on this machine. My question is...my two web hosts for my PHP hosting have PHP 4.3.2 PHP 4.3.4

Re: [PHP-DB] PHP versions - Development server live server...

2004-10-13 Thread Robby Russell
On Wed, 2004-10-13 at 21:04 +0100, Peter Borcherds wrote: Hi all, First of all, apologies if this is posted more than once...I'm having trouble with my newsreader!! I am running Win XP Pro as my development machine - at present I have PHP 4.3.4 installed on this machine. My question

RE: [PHP-DB] PHP versions - Development server live server...

2004-10-13 Thread Peter Borcherds
Hi Robby, Thanks for the swift reply! Okay, so it should be fine to install the 4.3.9 version then - okay...now I assume I should hold-off on the 5.0.2 release then...? -Original Message- From: Robby Russell [mailto:[EMAIL PROTECTED] Sent: 13 October 2004 22:01 To: Peter Borcherds Cc:

RE: [PHP-DB] PHP versions - Development server live server...

2004-10-13 Thread Robby Russell
On Wed, 2004-10-13 at 22:06 +0100, Peter Borcherds wrote: Hi Robby, Thanks for the swift reply! Okay, so it should be fine to install the 4.3.9 version then - okay...now I assume I should hold-off on the 5.0.2 release then...? Peter, Yes, if you build PHP5 code, it's very possible it will

RE: [PHP-DB] deleting multiiple records from database

2004-10-13 Thread Bastien Koert
echo out the sql just before you execute it when doing the delete, ensure that the values that you are expecting to be deleted are being deleted bastien From: Adil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] deleting multiiple records from database Date: Wed, 13 Oct 2004 16:11:36

RE: [PHP-DB] MySQL, Multiple tables, and Multipage form using sessions

2004-10-13 Thread Bastien Koert
If you are usiing the INNOdb table type/engine in the mysql db, it supports transactions. you can wrap the entire set of sql statement in a transaction and they would get executed as one block. If any fail, then the whole thing is rolled back. This DOES NOT work with the myISAM table types.