Re: [PHP-DB] PHP functions independant executions

2004-10-16 Thread lists
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] PHP functions independant executions

2004-10-16 Thread Matthew Perry
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 Datab

Re: [PHP-DB] MySQL nested subqueries

2004-10-16 Thread lists
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, visit:

[PHP-DB] MySQL nested subqueries

2004-10-16 Thread Matthew Perry
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] Question: Putting separate form elements into an array

2004-10-16 Thread Graham Cossey
> > > 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 skil

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

2004-10-16 Thread Stuart Felenstein
See interspersed: --- Graham Cossey <[EMAIL PROTECTED]> wrote: > 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. > You can just as easily store the arrays in your

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

2004-10-16 Thread Graham Cossey
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.) This would pass the form values as arrays which you can then iterate through in your script. $skills = $_POST['skill']; $skys = $_POST['sky']; $sl

[PHP-DB] Re: Subject: Form Processing

2004-10-16 Thread Neil Smith [MVP, Digital media]
Sure you can Ron : Just give each submit button the same name, but a different ID in the html eg When the user presses one of the buttons, look into the $_POST array and check if the value is set, for example switch ($_POST["submit"])) { case 'Delete' : // Delete actions he

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

2004-10-16 Thread Stuart Felenstein
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 skill3sky

[PHP-DB] Re: downloading from database

2004-10-16 Thread Torsten Roehr
"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

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

2004-10-16 Thread Torsten Roehr
"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 http://pear

RE: [PHP-DB] Form Processing

2004-10-16 Thread Bastien Koert
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: "P

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

2004-10-16 Thread Stuart Felenstein
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

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

2004-10-16 Thread Graham Cossey
Stuart, you are calling your rollback function only if $result is false. This check you are performing at the end of performing your 3 queries, each of which update $result. The net result here is that you will only call rollback() if the 3rd query results in false. I would create another functio

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

2004-10-16 Thread Stuart Felenstein
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 ,

Re: [PHP-DB] MySQL max records

2004-10-16 Thread Bastien Koert
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

2004-10-16 Thread =?iso-8859-1?q?Mart=EDn_Marqu=E9s?=
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). Usin

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

2004-10-16 Thread Stuart Felenstein
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

2004-10-16 Thread =?iso-8859-1?q?Mart=EDn_Marqu=E9s?=
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 quer

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

2004-10-16 Thread Stuart Felenstein
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 wouldn'