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

2004-10-17 Thread Stuart Felenstein
Not exactly sure what I did here. there are 5 skill textfields name skill[] then the years sky[] then the last used slu[] I was following the format of my other arrays, so stored them list this: if ( empty( $_SESSION['l_skill'] ) ) { $_SESSION['l_skill']=array(); } if ( is_array( $_REQUEST['sk

Re: [PHP-DB] MySQL max records

2004-10-17 Thread ApexEleven
thanks a lot, that's just about what i needed to hear On Sat, 16 Oct 2004 11:00:25 -0400, Bastien Koert <[EMAIL PROTECTED]> wrote: > 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 h

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

2004-10-17 Thread H. J. Wils
Hi everybody, For quite a while i'm struggeled with my session. It doesn't seem to work, can anyone help me? This is my code: page 1: session_start(); $_SESSION["test"] = "tryin..."; if (isset($_SESSION["test"])) { echo "next page"; echo "".session_id(); } page 2: session_start(); if (isset($

[PHP-DB] session

2004-10-17 Thread H. J. Wils
sorry, forgot to change the subject :), just to be sure here is my question again.. Hi everybody, For quite a while i'm struggeled with my session. It doesn't seem to work, can anyone help me? This is my code: page 1: session_start(); $_SESSION["test"] = "tryin..."; if (isset($_SESSION["test"])

Re: [PHP-DB] session

2004-10-17 Thread Brad Bonkoski
I believe you need to pass the session variable along to the next page... Something like: On page 1: if session is set { $s = SID; echo "Link"; } - Original Message - From: "H. J. Wils" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 17, 2004 9:38 AM Subject: [PHP-D

Re: [PHP-DB] session

2004-10-17 Thread H. J. Wils
hey thanx it works, but why is that? i mean, session are there to save data which te user cant see... isnt there another way to pass the SID? i have the feeling passing the SID trhough the url-paramters is harming the security, am i right? From: "Brad Bonkoski" <[EMAIL PROTECTED]> To: "H. J.

Re: [PHP-DB] session

2004-10-17 Thread Brad Bonkoski
Look at the URL when you pass it? It does not show anything, in fact the session is still using cookies or other means to tansfer the data. You should also be able to sniff the data being passed by the URL and not see any of the session data. - Original Message - From: "H. J. Wils" <[E

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

2004-10-17 Thread Stuart Felenstein
Changed my direction somewhat but keep getting a parse error and although I know where it is , I can't seem to figure out what I need to do to make it syntax correct: This is how I am passing the arrays: if ( empty( $_SESSION['l_skill'] ) ) { $_SESSION['l_skill']=array(); } if ( is_array( $_REQU

RE: [PHP-DB] MySQL nested subqueries

2004-10-17 Thread Bastien Koert
4.1 is supposed to handle them, how well is another issue bastien From: Matthew Perry <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL nested subqueries Date: Sat, 16 Oct 2004 18:30:56 -0500 Anyone know when there will be a version of MySQL that can handle nested subqueries? -Mat

RE: [PHP-DB] PHP functions independant executions

2004-10-17 Thread Bastien Koert
you can execute scripts as cron jobs. what is the OS? Note that for cron jobs you should not have browser based output...any output, errors, etc should be sent to a file. bastien From: Matthew Perry <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP functions independant executions

[PHP-DB] unexplained delay between db connection and db write operations

2004-10-17 Thread keith brickey
A php script that creates tables exhibits a 3 minute delay when invoked over the Internet that is not evidenced when invoked using the ISP account where the server resides. A timer function records elapsed time for each operation and reports the elapsed times at the end of the script. The followin

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

2004-10-17 Thread Antoine
On Wed, 13 Oct 2004 15:26:12 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > 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 PROTE

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

2004-10-17 Thread Graham Cossey
Stuart, what does your echo($query) line output? I would hazard a guess that your quotes are wrong and you are not getting what you expect. What is &LUID? I believe you will need to execute an INSERT query within each "for($i=0; $i > This is how I am trying to get them into the database: > > $qu

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

2004-10-17 Thread Graham Cossey
Stuart, now I'm confused. You seem to be posting slightly different versions of problems relating to the same script(s) on 2 lists. What is the current situation? Iterating through the 3 arrays or inserting into MySQL? Graham > -Original Message- > From: Stuart Felenstein [mailto:[EMAIL

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

2004-10-17 Thread Stuart Felenstein
Sorry about the two lists. The echo's are fine. The problem was iterating through the 3 arrays. Stuart --- Graham Cossey <[EMAIL PROTECTED]> wrote: > Stuart, now I'm confused. > > You seem to be posting slightly different versions > of problems relating to > the same script(s) on 2 lists. > >

RE: [PHP-DB] unexplained delay between db connection and db write operations

2004-10-17 Thread Bastien Koert
So you have local code executing against a remote server? And you have the proper accounts and authentication, and direct acccess to the machine? Could this be an issue where users/aapilcations are still locking the old table before the drop command is issued? What is the current load on the ma

[PHP-DB] backing up off of web host

2004-10-17 Thread Matthew Perry
The MySQL database on my web host has only non-sensitive information. How bad an idea is it to have a backup copy emailed to me at a designated time so I don't have to depend on myself and the host for backups? I am worried this cheep web host will go out of business and take my backups with hi

[PHP-DB] CMS Translation Systen: DB Desiging

2004-10-17 Thread bruno b b magalhaes
Hi everone, I am building a multilingual content management systen, and I am studying the best way to have the content translated, with minimal Database queries and load. So I have: CONTENTS contentId contentCreationDate contentModificationDate translationId contentStatus CATEGORIES categoryId

Re: [PHP-DB] backing up off of web host

2004-10-17 Thread lists
Matthew Perry wrote: The MySQL database on my web host has only non-sensitive information. How bad an idea is it to have a backup copy emailed to me at a designated time so I don't have to depend on myself and the host for backups? To qunatify how "bad of an idea" depends on how valuable your da