[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' respective

[PHP-DB] What is the proper way to use mysql db on a multipage site?

2003-09-24 Thread Daevid Vincent
I've been coding with PHP and mySQL for years. And this part has never sat right with me and finally I'm getting the nerve to ask how the pros out there do this... What I do is have a "db.php" file that contains: $db = mysql_connect ("localhost","username","password") or die ("Co

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

2003-09-24 Thread Martin Marques
El Mié 24 Sep 2003 18:15, Ignatius Reilly escribió: > Yeah, banking is too serious a business in Argentina, as everybody knows, > to entrust to MySQL. Uhmmm. Are you a bond holder? You should have stated it as an irony, if that was the case. Else, it's very unclear what you are trying to express.

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

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

2003-09-24 Thread Martin Marques
El Mié 24 Sep 2003 17:27, [EMAIL PROTECTED] escribió: > > 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

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

SV: [PHP-DB] Problem with sessions on FreeBSD 4.4

2003-09-24 Thread Lars Rasmussen
Yes, i found out about it when my costumers wrote to me that the system did'nt work (webshop). I tried to look in my source (that is 9MB don't think you want me to mail it to the list). But of course i tried to make a simple session script from the manual, and it works on two other servers, and th

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

2003-09-24 Thread Martin Marques
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 for a ver

Re: [PHP-DB] Curious code behavior inside/outside function

2003-09-24 Thread CPT John W. Holmes
From: "Karen Resplendo" <[EMAIL PROTECTED]> > I can't get odbc call to work inside of a function. It works on the outside, then I pass the recordset and fieldname to the function to use the data. I would like to just have the whole odbc stuff inside the function. Am I missing something obvious? T

[PHP-DB] Curious code behavior inside/outside function

2003-09-24 Thread Karen Resplendo
I can't get odbc call to work inside of a function. It works on the outside, then I pass the recordset and fieldname to the function to use the data. I would like to just have the whole odbc stuff inside the function. Am I missing something obvious? This is the error I get for the odbc_do line:

Re: [PHP-DB] Problem with sessions on FreeBSD 4.4

2003-09-24 Thread CPT John W. Holmes
From: "Lars Rasmussen" <[EMAIL PROTECTED]> > I have some problems with sessions, it seems that when i have this in my > httpd.conf > > AllowOverride All > Options All > > > Sessions don't work. > > But as soon as i comment it out, it works just fine again. > > I don't really know what to do here,

[PHP-DB] Problem with sessions on FreeBSD 4.4

2003-09-24 Thread Lars Rasmussen
Hi All, I have some problems with sessions, it seems that when i have this in my httpd.conf AllowOverride All Options All Sessions don't work. But as soon as i comment it out, it works just fine again. I don't really know what to do here, and i hope that you can help me. Thanks a lot. //Lars

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: [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] 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 numb

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

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... HTH Ignatius _ - Original Message -

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 t

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 t

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 a

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 o

[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 e

[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

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] 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 b