Re: [PHP-DB] any php/Linux gurus out there?

2002-03-04 Thread Jason Wong
On Tuesday 05 March 2002 07:52, Peter Lovatt wrote: > Hi > > I am running the security upgrade and am getting the following error when I > run the RPM > The install is RH 7.0 and was pre-installed. I had assumed that the RPMs > from Redhat would match the pre installed version, as it was standard.

Re: [PHP-DB] any php/Linux gurus out there?

2002-03-04 Thread Ken Thompson
On Monday 04 March 2002 05:54 pm, Pedro M. S. Oliveira wrote: > you could complile the hole program instead of the rpm, just read > README.install from the php source tar file. > or you can install the other rpms that are lacking. > or even so, not such a good ideia, but you can force the installa

[PHP-DB] Re: php-db Digest 5 Mar 2002 01:49:55 -0000 Issue 1083

2002-03-04 Thread Frank Flynn
Without knowing what you are trying to do I get the impression you might be better off doing this via SQL rather than PHP. You say: > ...very large result sets, which are transferred to arrays, > and that does some extremely heavy lifting in terms of calculations on those > arrays. By design, it

RE: [PHP-DB] any php/Linux gurus out there?

2002-03-04 Thread Dan Brunner
Hello!! First uninstall your old version of php(php-4.0.6-9.7.0) Then install the new RPM If you're using the Red Hat update thingy... Or download the source and recompile it!! Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04,

Re: [PHP-DB] any php/Linux gurus out there?

2002-03-04 Thread Pedro M. S. Oliveira
you could complile the hole program instead of the rpm, just read README.install from the php source tar file. or you can install the other rpms that are lacking. or even so, not such a good ideia, but you can force the installationg using the command rpm -i --nodeps php or rpm -U --nodeps php

[PHP-DB] any php/Linux gurus out there?

2002-03-04 Thread Peter Lovatt
Hi I am running the security upgrade and am getting the following error when I run the RPM The install is RH 7.0 and was pre-installed. I had assumed that the RPMs from Redhat would match the pre installed version, as it was standard. I am a humble programmer (and part time sys admin!), rather t

[PHP-DB] Converting Image Data Directly from MySQL

2002-03-04 Thread Josh Trutwin
Hello list, I've been stumped on this for a while, I have a large project where I am storing image data in a MySQL db for reasons I will not get into. The images are displayed as thumbnails in a table which are hyperlinks to a large file. The larger file is stored in the db as a BLOB type in GI

Re: [PHP-DB] easy date format question

2002-03-04 Thread Dan Brunner
Hello!! it should be $today = Date("Y"-"m"-"d"); Dan On Friday, March 1, 2002, at 04:50 PM, [EMAIL PROTECTED] wrote: > should be simple as pie, of course, but i can't find a straightforward > syntax example in the documentation. i'm trying to change the PHP date > format to mysql's. > > my

Re: [PHP-DB] Tutorial?

2002-03-04 Thread Aron Pilhofer
Right. I store mine in the same db, and it gets inserted with the other data from the form. Before inserting, the script does a quick query, selecting all rows where the unique_id is equal to the current ID. since a new one is generated for each submit click, the answer will be zero on a proper in

RE: [PHP-DB] Tutorial?

2002-03-04 Thread Jonathan Hilgeman
This is another good idea. When reloading the page, have the script generate that unique ID, store it in a separate table AND put it in a hidden input. When the user submits, the database checks to see if the unique ID is in the database, and if so, the ID is deleted from the database, and the or

Re: [PHP-DB] Tutorial?

2002-03-04 Thread Aron Pilhofer
The easiest and best solution is to redirect to a new page after the submit. But I have had cases where it was necessary to have the submit code and the form on the same page. I agree totally with jonathan that a server-side solution is the way to go. To solve the problem (avoid clicking twice an

RE: [PHP-DB] Tutorial?

2002-03-04 Thread Richard Black
How about mixing the 2??? :-) Richy -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: 04 March 2002 16:51 To: 'Richard Black'; 'Jennifer Downey'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Tutorial? Javascript will functionally solve the problem, but since Javas

RE: [PHP-DB] Tutorial?

2002-03-04 Thread Jonathan Hilgeman
Javascript will functionally solve the problem, but since Javascript is an optional piece of the browser that can be turned off/on, and functions differently in different browsers, it's definitely far from fool-proof. You could get it working 99.9% in IE and Navigator, but then have it fail in ano

RE: [PHP-DB] Tutorial?

2002-03-04 Thread Richard Black
I've also seen something similar implemented using javascript (i guess - never looked into it in any detail) The online bank I use does this. Basically, when I click a submit button, the button is replaced by an image (like a greyed out submit button) which has the caption Submitted. Clicking thi

RE: [PHP-DB] Tutorial?

2002-03-04 Thread Jonathan Hilgeman
Hi Jennifer, I'm guessing the purpose of this would be to keep people from double-clicking and submitted information twice, possibly making an application deduct payment twice or something important similar in nature. The best way I've found of accomplishing the goal of keeping people from clicki

Re: [PHP-DB] optimization (another tack)

2002-03-04 Thread Aron Pilhofer
Messagethanks! "Ray Hunter" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Here is general information on postgres: http://www.ca.postgresql.org/docs/aw_pgsql_book/index.html Here is an optimization file included: This was not written by me!!! Let me

RE: [PHP-DB] optimization (another tack)

2002-03-04 Thread Hunter, Ray
Title: Message Here is general information on postgres: http://www.ca.postgresql.org/docs/aw_pgsql_book/index.html   Here is an optimization file included:  This was not written by me!!!   Let me know if you have questions...s Ray Hunter Firmware Engineer ENTERASYS NETWORKS -Ori

RE: [PHP-DB] optimization (another tack)

2002-03-04 Thread Hunter, Ray
If you are using php and a database you can add more memory to the script and optimize the database. I only use postgres databases for all my large data so I can let you know how to optimize postgres... Ray Hunter Firmware Engineer ENTERASYS NETWORKS -Original Message- From: Aron Pi

[PHP-DB] optimization (another tack)

2002-03-04 Thread Aron Pilhofer
Let me try this again more generally. I am trying to optimize a function in PHP that handles very large result sets, which are transferred to arrays, and that does some extremely heavy lifting in terms of calculations on those arrays. By design, it iterates through each possible combination of two

RE: [PHP-DB] PHP + Oracle + Redhat Linux Stupid Question Maybe? Sorry

2002-03-04 Thread Andrew Hill
Jason, Or you can use ODBC, as per the HOWTO at www.iodbc.org, which eliminates the ned to install the Oracle client and enables you to develop applications independent of database. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink

[PHP-DB] PHP, Oracle and multipage transactions

2002-03-04 Thread luny
Hello, is there a way to store an Oracle session in a PHP session so the transaction would carry over from one page to another? Initially I thought that using OCIPlogin and storing the connection variable into a PHP session would solve it, but it wasn't the way I had hoped it to be.. Seems that w

Re: [PHP-DB] WHERE clause

2002-03-04 Thread Aron Pilhofer
MySQL is very well documented as well. www.mysql.com, click on documentation. "Dl Neil" <[EMAIL PROTECTED]> wrote in message 160001c1c356$2f629c40$c200a8c0@jrbrown...">news:160001c1c356$2f629c40$c200a8c0@jrbrown...; > Jennifer, > > > Wondering do I have to have the WHERE clause in a select query?

[PHP-DB] Sybase multiple result sets

2002-03-04 Thread Craig Andrews
Hi, I am porting an application which currently makes use of the ODBC PEAR DB object to use the SyBase DB object instead. However, there does not seem to be a way to retrieve multiple result sets using the SyBase object. The transfer to SyBase, and indeed the stored procedure which generates

[PHP-DB] Re: WHERE clause

2002-03-04 Thread Ralph Friedman
In article <[EMAIL PROTECTED]>, Jennifer Downey wrote: > $b=mysql_query( SELECT * FROM my_table) <-can I use something like this > or do I have to put WHERE in the statement? > you only need a "WHERE" clause when you want to limit the result set from the query. If you want or need to retriev

Re: [PHP-DB] Retrieving a date.

2002-03-04 Thread Ralph Friedman
In article <[EMAIL PROTECTED]>, Ken Thompson wrote: > Great, that explains better than "most" of the tutorials I've read. > It is unfortunate that most if not all reference documentation expect the > reader to have a college degree just on their subject in order to understand > "wot in 'ell" th

Re: [PHP-DB] WHERE clause

2002-03-04 Thread DL Neil
Jennifer, > Wondering do I have to have the WHERE clause in a select query? > $b=mysql_query( SELECT * FROM my_table) <-can I use something like this > or do I have to put WHERE in the statement? Hate to answer a question with a question, but what happened when you tried typing this query i

Re: [PHP-DB] Tutorial?

2002-03-04 Thread Markus Lervik
On Sun, 2002-03-03 at 08:18, Jennifer Downey wrote: > Can anyone point me to a good tutorial on how to disable a submit button > once clicked? > preferably in php. If I understood the question; wouldn't this produce the desired result? VALUE="whatever"> If $disabled is set, the button is rend