Re: [PHP-DB] Closing curly brackets?

2002-04-15 Thread Marius Ursache
a good tutorial for code formating is c and c++ style guides ( http://www.cs.umd.edu/users/cml/cstyle/ ) a good code editor is vim (http://www.vim.org). Jennifer Downey a écrit : Thank you Paul, I have asked about atutorial on proper code formatting and got back a tutorial that was

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-15 Thread Marius Ursache
your posts are here. i don't think you could do this in other way. if is possible i'm curios about it too. Jennifer Downey a écrit : Hi all, I'm not sure if my first post showed up so I am going to post it again and I apologize if it shows up twice. Is there a way to delete a record from

Re: [PHP-DB] Extracting the essence!

2002-04-15 Thread Lisi
How about: $test= preg_replace ($search, $replace, $dokument); while (list ($key, $val) = each($test)) { if ($key == 0 || $key == 3) { //do nothing } else { echo $key = $val; } } Let me know if this works. -Lisi At 11:24 PM 4/14/02 +0200, #Linux wrote:

[PHP-DB] Re: LOBS with CURSOR_SHARING=FORCE gives core dump

2002-04-15 Thread John Lim
According to Thies, this is an Oracle bug. A quick workaround which I just tested is to execute an alter session before updating the LOB, and restore cursor_sharing=force after the update. ALTER SESSION SET cursor_sharing=exact Bye, John Prince [EMAIL PROTECTED] wrote in message [EMAIL

[PHP-DB] Re: Delete from mysql table is there a way to....

2002-04-15 Thread phplists
I'm not sure how to change DELETE statements in this fashion, but is there a way maybe to run an OPTIMIZE TABLE query every so often in your PHP script.. I don't imagine you'd want it running too often since it locks the table you run it on, but maybe on the reload of $PHP_SELF or something.. It

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-15 Thread Jason Wong
On Monday 15 April 2002 08:46, Jennifer Downey wrote: Hi all, I'm not sure if my first post showed up so I am going to post it again and I apologize if it shows up twice. The first post did show up. This is purely a MySQL issue. Is there a way to delete a record from a mysql table without

[PHP-DB] Re: Delete from mysql table is there a way to....

2002-04-15 Thread phplists
Maybe if you ran the delete query, then the optimize table query immed after, it wouldn't take such a long time.. I would imagine if you had quite large tables though, it could still take some time.. And if users are connecting over the internet, you don't want too may delays.. If the user

Re: [PHP-DB] Insert select does not insert all rows.

2002-04-15 Thread andy
the statement is executed directly on the server without php just mysql any other ideas? thanx, Andy insert into geodata_backup.provinces_test (country_code,province,province_id) select country_code, name, province_id from import.provinces_update_imported Olinux [EMAIL PROTECTED] schrieb

[PHP-DB] Cross DB application

2002-04-15 Thread Arcadius A.
Hello ! I'm planning to write a database application for MySQL, and then port it to PostrgeSQL. Is there any library or class that could help me to write/maintain just one source code for both MySQL and PostgreSQL ? Thanks. ARcadius -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] newsletter

2002-04-15 Thread its me
hi guys, i wanna make a news letter as follows: i sell items within certain categories,so whenever a buyer is registered he choose some categories to contribute to my newsletter with: whenever a new item is added within this category i send him an email with that. i'm storing the mails in

Re: [PHP-DB] Cross DB application

2002-04-15 Thread Andrew Hill
ARcadius, You may use an abstraction library such as PEARDB or ADODB, or simply the unified ODBC functions. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software Hello ! I'm planning to write a database application for MySQL, and then port it to PostrgeSQL. Is

Re: [PHP-DB] Insert select does not insert all rows.

2002-04-15 Thread Maureen
I'm curious, if this is not using php, why are you posting to the php-db mailing list? Why not post to the mysql mailing list? Just a thought. andy [EMAIL PROTECTED] said: the statement is executed directly on the server without php just mysql any other ideas? thanx, Andy insert

RE: [PHP-DB] Cross DB application

2002-04-15 Thread Gurhan Ozen
Hi Arcadius, If you know Object-oriented programming , you can write a class that includes both MySQL and PostGreSQL functions and you can inherit from that class. Or, you can just stick all mysql, postgresql functions in a functions.php file and include that file to be able to use the functions.

[PHP-DB] Pdf display from Blob

2002-04-15 Thread [EMAIL PROTECTED]
We are using Interbase 6.01 as SQL-Server and PHP4. The Interbase table was created an populated with a Delphi - Programm. Everything is working. Our problem is now to display the PDF Content out of Blobs. Text - Blobs are working with ibase_blob_echo() Outputting PDF-Blobs without MIME-Header

[PHP-DB] Re: Saving DB Resuts to a file

2002-04-15 Thread Ray Hunter
Chris, You will want to use the file i/o functions to write to a file and save the db info to a file. http://www.php.net/manual/en/function.fwrite.php Ray BigDog Hunter Chris Payne [EMAIL PROTECTED] wrote in message

[PHP-DB] Arrays

2002-04-15 Thread Alex Francis
I am trying to insert event dats into a database and to make sure the user puts the date in the correct format. I am now trying to collect the information from the three fields and insert it into one field. code as follows: $eventdate = array (eventyear, eventmonth, eventday); when I insert it

Re: [PHP-DB] Arrays

2002-04-15 Thread Steve Cayford
Your $eventdate variable is an array, not a string so you can't just drop it into an sql query string like that. If you have separate fields in the db for year, month and day then you probably want something like: $query = insert into ... values ( ... , '$eventdate[0]', '$eventdate[1]',

[PHP-DB] database table layout help

2002-04-15 Thread Barry Rumsey
I am setting up a music info site and have decided on the follow tables ( not to sure weather to add the mp3 part). The one main question I have before starting to make the tables is weather mysql_insert_id() would be able to handle this with the way I have it ? :Artist id artist_name :Album

Re: [PHP-DB] Arrays

2002-04-15 Thread Alex Francis
Got it now, Thank you -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may contain legally privileged information. Unauthorised recipients are

[PHP-DB] Re: Cross DB application

2002-04-15 Thread Manuel Lemos
Hello, Arcadius A. wrote: Hello ! I'm planning to write a database application for MySQL, and then port it to PostrgeSQL. Is there any library or class that could help me to write/maintain just one source code for both MySQL and PostgreSQL ? I think your best (if not the only) option in

[PHP-DB] Re: LOBS with CURSOR_SHARING=FORCE gives core dump

2002-04-15 Thread Prince
I don't think this is the bug with oracle as I was able to do the same with C program having OCI calls. John, I am aware of this work-around. But this requires some changes in the application. What I would like to have is, set the parameter in the system level (init.ora or alter system) and no

Re: [PHP-DB] Cross DB application

2002-04-15 Thread Manuel Lemos
Hello, Andrew Hill wrote: ARcadius, You may use an abstraction library such as PEARDB or ADODB, or simply the unified ODBC functions. Andrew, you always suggest ODBC as a good solution for portable database application development, but AFAIK it is not a good solution at all because for

[PHP-DB] Re: [PHP] Re: Cross DB application

2002-04-15 Thread Manuel Lemos
Hello, James Cox wrote: I'm planning to write a database application for MySQL, and then port it to PostrgeSQL. Is there any library or class that could help me to write/maintain just one source code for both MySQL and PostgreSQL ? I think your best (if not the only) option in PHP

[PHP-DB] Definitive answer for large scale registration/authentication

2002-04-15 Thread Brad Hubbard
Can I get some feedback on the conventional wisdom as to the best solution for high volume registration and authentication of users accessing a secure site? I have worked before with database/session based methods as well as htaccess. Which is preferred? Are there alternatives? Thanks for the

[PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-15 Thread Manuel Lemos
Hello, Brad Hubbard wrote: Can I get some feedback on the conventional wisdom as to the best solution for high volume registration and authentication of users accessing a secure site? I have worked before with database/session based methods as well as htaccess. Which is preferred? Are

Re: [PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-15 Thread Brad Hubbard
On Tue, 16 Apr 2002 14:01, Manuel Lemos did align ASCII characters thusly: Probably the fastest way to keep session profile information is by serializing the data array into a string that will be encrypted and then stored in cookie. The security weakness of this method is that if the secret

Re: [PHP-DB] Re: Definitive answer for large scale registration/authentication

2002-04-15 Thread Manuel Lemos
Hello, Brad Hubbard wrote: On Tue, 16 Apr 2002 14:01, Manuel Lemos did align ASCII characters thusly: Probably the fastest way to keep session profile information is by serializing the data array into a string that will be encrypted and then stored in cookie. The security weakness of

[PHP-DB] Re: database table layout help

2002-04-15 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... I am setting up a music info site and have decided on the follow tables ( not to sure weather to add the mp3 part). The one main question I have before starting to make the tables is weather mysql_insert_id() would be able to handle

Re: [PHP-DB] Delete from mysql table is there a way to....

2002-04-15 Thread Lisi
What exactly does it mean when a table becomes fragmented? How do you know when it's happened and something should be done? All the docs and books talk about how bad it is but I'm still confused on what this is and when it happens. Thanks, -Lisi At 05:00 PM 4/14/02 -0700, Jennifer Downey