[PHP-DB] Transactions - working but unsure about steps

My statements are all working but I'm not sure if things are set up correctly. I say this because at one point the first $query failed, yet the rest of inserts wre committed. Now I believe I need to set autocommit to 0 , yet the query failed due to a syntax error. Hence 0 records effected

Re: [PHP-DB] Transactions - working but unsure about steps

El Sáb 16 Oct 2004 09:52, Stuart Felenstein escribió: My statements are all working but I'm not sure if things are set up correctly. I say this because at one point the first $query failed, yet the rest of inserts wre committed. Now I believe I need to set autocommit to 0 , yet the query

Re: [PHP-DB] Transactions - working but unsure about steps

I think you are adding a conditonal /validaton statement as the constraint ? More then x characters will generate an error. My understaning is an error in mysql transaction will rollback should rollback the entire set of transactions. error handling for each statement- values will be coming from

Re: [PHP-DB] Transactions - working but unsure about steps

El Sáb 16 Oct 2004 11:36, Stuart Felenstein escribió: I think you are adding a conditonal /validaton statement as the constraint ? More then x characters will generate an error. I was tryiong to generate a validation that would fail with certain inserts (or modification of a register). Using

Re: [PHP-DB] MySQL max records

Have a look at some of the case studies at mysql.comthere are servers handling 50Million records with not problemsat a certain point it becomes more a hardware issue than a db server issue... bastien From: -{ Rene Brehmer }- [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [PHP-DB]

Re: [PHP-DB] Transactions - working but unsure about steps

See Interspersed: --- Martín Marqués [EMAIL PROTECTED] wrote: I was tryiong to generate a validation that would fail with certain inserts (or modification of a register). Using more then 25 characters in the second field would yield the same result. Got that and yes, for my pages , they

RE: [PHP-DB] Transactions - working but unsure about steps

I had that suspicion that I was only calling it for the last query. Thank you for confirming and for the code! Much appreciated. Stuart --- Graham Cossey [EMAIL PROTECTED] wrote: Stuart, you are calling your rollback function only if $result is false. This check you are performing at the

RE: [PHP-DB] Form Processing

yes, you can have multiple submit buttons, you would simply need to test for the value of that button on the server if ($_POST['submit']==delete){ //delete something } if ($_POST['submit']==update){ //update something } and so one hth Bastien From: Ron Piggott [EMAIL PROTECTED] To: PHP DB

[PHP-DB] Question: Putting seperate form elements into an array

Right now this seems something like solving a rubic's cube. While I process, I hope it's alright that i'm asking here. I think my quantity of posts have been high :) I have these form elements:(these are the names of the elements) skill1sky1 slu1 skill2sky2 slu2 skill3

[PHP-DB] Re: Subject: Form Processing

Sure you can Ron : Just give each submit button the same name, but a different ID in the html eg submit name=submit id=delete value=Delete / submit name=submit id=update value=Update / submit name=submit id=manage value=Management / When the user presses one of the buttons, look into the $_POST

RE: [PHP-DB] Question: Putting separate form elements into an array

Have you tried naming your form elements such as skill[], sky[] and slu[] ? (You could also use skill[1], skill[2], skill[3] etc... within your form.) Yes that makes sense. Good. This of course means you can build your form within a for loop (or similar). So to place 10 skill text

[PHP-DB] MySQL nested subqueries

Anyone know when there will be a version of MySQL that can handle nested subqueries? -Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL nested subqueries

Matthew Perry wrote: Anyone know when there will be a version of MySQL that can handle nested subqueries? -Matt http://dev.mysql.com/doc/mysql/en/ANSI_diff_Subqueries.html v4.1, but it isn't the stable release at this time. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] PHP functions independant executions

How do I get my PHP funcitons to execute independantly based on what time of day it is and not on the user? This may not be how PHP was designed but I would like to do things like send out an email to someone based on suchandsuch criteria, backup DB on regular schedule etc. - Matt -- PHP

Re: [PHP-DB] PHP functions independant executions

Matthew Perry wrote: How do I get my PHP funcitons to execute independantly based on what time of day it is and not on the user? This may not be how PHP was designed but I would like to do things like send out an email to someone based on suchandsuch criteria, backup DB on regular schedule etc.

[PHP-DB] Re: code example to store PHP session data in mySQL ?

Kalle [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi @ all, where can I find a working example that shows me how to implement PHPSESSION with MySQL as stor? tia Hi, I'm using PEAR's HTTP_Session in combination with PEAR::DB: http://pear.php.net/package/DB

[PHP-DB] Re: downloading from database

Adil [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hey everyone, I have a question about downloading from a mySQL database, running php on Apache. Basically right now I'm working on this file upload download tool. You login, see a list of files, (upload functionality works