[PHP-DB] mySQL vs pgSQL | php vs others

2003-09-24 Thread nabil
Dear all; I have been using Mysql for a long time, but I have a benchmark Q. Is pgsql , better ? faster ? more reliable than mysql ? any comment ? Some people say that php is not for a very big enterprise, banking , application !! they said that java or even .NET is better ... I m against that

Re: [PHP-DB] mySQL vs pgSQL | php vs others

2003-09-24 Thread Lester Caine
I have been using Mysql for a long time, but I have a benchmark Q. Is pgsql , better ? faster ? more reliable than mysql ? any comment ? I've only ever used Interbase and now Firebird. Latest release is due any day and is FAST. Some people say that php is not for a very big enterprise, banking ,

[PHP-DB] Storing Session Variables

2003-09-24 Thread dpgirago
Just wondering... Is there a limit to the number of session variables one can create/store ? Or is the limit imposed by the size of the file ? I'm on a Windows 2000 machine, and the variables are being saved in notepad. David

[PHP-DB] update db with variables

2003-09-24 Thread Robbie Staufer
Hi, I'm writing an application that will display the contents of a db in the browser, including the db-assigned id number. The user can then enter the id number in a form and the browser will display the record corresponding to that id number, with the data in editable text fields. The user

Re: [PHP-DB] Storing Session Variables

2003-09-24 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] Is there a limit to the number of session variables one can create/store ? Or is the limit imposed by the size of the file ? Size of file is only limit, although you should impose a practical limit yourself. If you need to ask this question, you're probably relying on

RE: [PHP-DB] update db with variables

2003-09-24 Thread Griffiths, Daniel
put some single quotes around $value in your SQL statement. -Original Message- From: Robbie Staufer [mailto:[EMAIL PROTECTED] Sent: 24 September 2003 16:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] update db with variables Hi, I'm writing an application that will display the contents of

Re: [PHP-DB] update db with variables

2003-09-24 Thread CPT John W. Holmes
From: Robbie Staufer [EMAIL PROTECTED] I'm writing an application that will display the contents of a db in the browser, including the db-assigned id number. The user can then enter the id number in a form and the browser will display the record corresponding to that id number, with the data

Re: [PHP-DB] Storing Session Variables

2003-09-24 Thread dpgirago
Define 'too much' please... David CPT John W. Holmes [EMAIL PROTECTED] 09/24/2003 10:29 AM Please respond to CPT John W. Holmes To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: [PHP-DB] Storing Session Variables From: [EMAIL PROTECTED] Is there a limit to the number

Re: [PHP-DB] update db with variables

2003-09-24 Thread Ignatius Reilly
Quotes missing around $value. Try instead: mysql_query( UPDATE tablename SET {$name} LIKE '{$value}' WHERE ID={$id}) Of course, even though the code does not show, you have properly validated user input before firing this query...blink/ HTH Ignatius _ - Original

Re: [PHP-DB] Storing Session Variables

2003-09-24 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] CPT John W. Holmes [EMAIL PROTECTED] From: [EMAIL PROTECTED] Is there a limit to the number of session variables one can create/store ? Or is the limit imposed by the size of the file ? Size of file is only limit, although you should impose a practical

Re: [PHP-DB] update db with variables

2003-09-24 Thread Robbie Staufer
Thanks to all. Single quotes around '$value' did the trick. Robbie CPT John W. Holmes wrote: From: Robbie Staufer [EMAIL PROTECTED] I'm writing an application that will display the contents of a db in the browser, including the db-assigned id number. The user can then enter the id number

Re: [PHP-DB] Storing Session Variables

2003-09-24 Thread dpgirago
Get serious for a second here... Why not explain why you're asking this question? If you're going to store a huge amount of data in a session, explain why. OK. Today I'm working on a prototype GUI for a medical setting ( the production GUI will be done in C++, I believe). The GUI must keep

Re: [PHP-DB] Storing Session Variables

2003-09-24 Thread Viorel Dragomir
You don't have too worry about the overload of the server. I presume that you don't have a genuine 486DX4 with 66Mhz. The windows is lowsy on this machines. : vio- - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 7:20 PM Subject: Re:

RE: [PHP-DB] mySQL vs pgSQL | php vs others

2003-09-24 Thread Gary . Every
El Mié 24 Sep 2003 07:24, nabil escribió: Dear all; I have been using Mysql for a long time, but I have a benchmark Q. Is pgsql , better ? faster ? more reliable than mysql ? Maybe not faster in FTS, but surely MORE reliable!!! any comment ? Some people say that php is not

Re: [PHP-DB] mySQL vs pgSQL | php vs others

2003-09-24 Thread Ignatius Reilly
Yeah, banking is too serious a business in Argentina, as everybody knows, to entrust to MySQL. Ignatius _ - Original Message - From: Martin Marques [EMAIL PROTECTED] To: nabil [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:24 PM Subject:

[PHP-DB] Maintains a persistent connection

2003-09-24 Thread ascll
Greetings, Could I use the PHP to maintain a persistent connection with MySQL database? My persistent connection here should work in this way: - 1) Using the .php file the retrieve data from Table_A that contain 2 fields 'Field_A' and 'Field_B', with the value 'Value_A' and 'Value_B'