Re: [PHP-DB] Unsubscribe me please

2012-09-19 Thread Paul Clark
Unsubscribe me too leckyt...@gmail.com On 19 September 2012 23:43, Graham H. wrote: > Hi, > > I tried unsubscribing from the list, but I was unsuccessful, I believe > because when I subscribed I cleverly added +php to the end of my email > address (for Gmail filtering). > > Could I be removed pl

Re: [PHP-DB] MSsql madness

2011-06-24 Thread Paul Wilson
please remove me from this list On Fri, Jun 24, 2011 at 3:02 PM, Troy Oltmanns wrote: > Hey php-dbers, > > I have a helper script that connects to an MSsql database to select > retailer > location information, which is then processed into mysql statements to be > inserted into another remote dat

[PHP-DB] Re: [PHP-WIN] Select the specific user data from the database

2010-09-06 Thread Paul Vatta
CREATE_WHO = SUBSTRING_INDEX(USER(),'@',1);". - DML statements are now applied against the view, and not against the underlying table. This depends on the user who is logged in to the DB though. Hope this helps, Paul On 6 September 2010 19:38, Richard Quadling wrote: > > On 5 Septem

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Paul Hollingworth
Thanks for the code Eric, it seems to loosely provide the functionality that I'm after. Just out of interest though, is there no other way to find the next result row in an object apart from dumping it into an array? Thanks, Paul Eric Lee wrote: On Sat, Feb 13, 2010 at 3:26 AM, Paul

[PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Paul
ld do: next($obj); if($obj["bar"] == "something") { //do things } prev($obj); Is there an equivalent to object? I've tried the above method, but nothing happens. I've also tried type casting it to an array, without success. Is there anyway to iterate through this?

[PHP-DB] Issue 45979: PHP code attached

2009-02-20 Thread Paul Will
Hi, This is the code for the above issue: The values passed are unimportant as they are for test purposes only. Everything seems to work OK except that the frame info shows an apparent spurious connection using the apache2 process userid. this is the calling page

[PHP-DB] PHP5: Initial connection to the MySQL server is carried out using the apache webserver userid

2009-02-20 Thread Paul Will
MySQL server proceeds normally and the database is read OK and the pages are correctly compiled. The phpinfo() function also shows that the indexes apparently contain the correct values. Thanks in advance for any help. Paul Will -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PDO::TIME_ZONE and or Initializing Query

2007-12-20 Thread Paul Rogers
It would be helpful if the time zone of a session could be specified at the time of the connection. This would avoid the overhead of a separate database query and round-trip to the database server when a single, non-default time zone is needed for the duration of the connection. Naturally there is

[PHP-DB] cPanel db Creator script

2007-07-20 Thread Paul Smith
create_db.php?db=$db_name"; } ?> Thanks in advance to anyone who has a clue how to solve this!!! Paul.

[PHP-DB] Unable to Send Mail

2006-03-15 Thread Paul Anderson
Please forgive me if this comes through twice. I am a new subscriber and the first send did not seem to work. We recently moved all our websites to a new server using php 4.3.10. We are having problem with ONE function. Any time a php script or form is supposed to send a response or email to us

[PHP-DB] Test

2006-03-15 Thread Paul Anderson
New user test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] test

2006-03-15 Thread Paul Anderson
new user test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] test

2006-03-15 Thread Paul Anderson
new user test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] test

2006-03-15 Thread Paul Anderson
new user test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] first record not displayed

2006-01-23 Thread Paul Bern
ed. The number of records returned ($nrows) matches what I get from MySQL and the first record gets displayed (using PHPMyAdmin). Even if I change the select to pull only certain records, the very first one d

[PHP-DB] If (test against a regex)

2005-09-28 Thread Paul Ohashi
advance, Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Security and MYSQL databases

2005-06-16 Thread Paul R. Strong
Here's a few payment processors. Some of them are located in United States and others in United Kingdom. Haven't tried all of them personally, but many professionals have recommended them. PayPal is still the best way to go because of its low cost. VeriSign is probably the most secure of all but

[PHP-DB] Re: SQL or array ?

2005-04-24 Thread Paul Reilly
arking the different options? What tools are there to do this? Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SQL or array ?

2005-04-23 Thread Paul Reilly
> explain the phrase "big array." I guess everything is relative! We're talking about 300-500 items here. Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] SQL or array ?

2005-04-23 Thread Paul Reilly
seem very efficient. Would it be better to just create a big array at the start of my script with all this data in? That would seem more efficient, and hence faster way of doing it? Any feedback appreciated. Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

[PHP-DB] supporting multiple databases...

2005-01-30 Thread Paul Chvostek
of SELECTs and even the db connect functions called from config variables. This seems elegant on the surface, but make for highly obtuse code. Is there a preferred method of handling this issue, or does everybody just roll their own? -- Paul Chvostek

[PHP-DB] RE: php-db Digest 16 Jan 2005 13:41:28 -0000 Issue 2777

2005-01-17 Thread Paul Cooper
From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: php-db Digest 16 Jan 2005 13:41:28 - Issue 2777 Date: 16 Jan 2005 13:41:28 - php-db Digest 16 Jan 2005 13:41:28 - Issue 2777 Topics (messages 38151 through 38154): Re: Integrating Interbase.so and PHP 38151 by: Doug Thom

[PHP-DB] RE: Assistance on Query

2005-01-17 Thread Paul Cooper
Hi People, I would like some assistance on the following scenario. I have to pull out all records for a particular userid (easy enough) and then only show those entries where the follwing occurs. These records from the table will contain either an entry in the services_type field or the non_service

Re: [PHP-DB] Re: Date Conversion

2004-08-18 Thread Paul
You might want to look into date conversion on the MySQL side: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Look for DATE_FORMAT(date,format) Paul On Wed, 18 Aug 2004 10:16:59 +0200, Torsten Roehr <[EMAIL PROTECTED]> wrote: > >"Ng Hwee Hwee" <[E

Re: [PHP-DB] MySQL denying access to...everything

2004-08-18 Thread Paul
Also, take care with the new password hashing: http://dev.mysql.com/doc/mysql/en/Password_hashing.html Paul On Wed, 18 Aug 2004 00:56:08 -0700, Peter Ellis <[EMAIL PROTECTED]> wrote: > This is a MySQL error on the server side - you need to make sure that > whatever user you

[PHP-DB] Connect to a ms access on a remote drive

2004-08-02 Thread Paul Kain
I am aware that theres a problem with connecting to an MS ACCESS DB on a remote drive. Anyoone how to do it correctly ? Please? :( -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] One or Many Databases?

2004-07-31 Thread Paul Burney
this question be any different if I were using PostgreSQL, MSSQL or DB2? Thank you in advance for any advice you can offer. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Tree structure - how to show only current branch ??

2004-03-30 Thread Paul Miller
Ya it has - that is a great script! -Original Message- From: Galbreath, Mark A [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 7:15 AM To: '-{ Rene Brehmer }-'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Tree structure - how to show only current branch ?? Already been done: http

RE: [PHP-DB] ?DHTML Layers with PHP?

2004-03-19 Thread Paul Miller
in a js include like this: With dynamic_page.php containing links like: I am not sure of a ready made php script that can do what you want, but I know it can be done. HTH - Paul -Original Message- From: Galbreath, Mark A [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 11:04 AM

RE: [PHP-DB] Automatically Refreshing png-Image'd Web Page

2004-03-19 Thread Paul Miller
header("Content-type: image/png") Echo image content Hopefully this sudo code is enough to get what I am trying to say. You might have some caching issues, but that is another issue. - Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Fri

Re: [PHP-DB] How to redirect after a valid login

2004-03-15 Thread Paul Burney
h = $file_system_location . '/includes:' . $current_includes_path; ini_set('include_path',$new_include_path); Hope that helps. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] How to redirect after a valid login

2004-03-12 Thread Paul Miller
That means you send some output before the headers were sent. That is a no no. For instance, this will not work: http://www.yahoo.com/";); ?> But this will http://www.yahoo.com/";); Echo "hello world"; ?> - Paul -Original Message- From: Larry Sandwic

Re: [PHP-DB] Connect to MySQL Database Using PHP

2004-02-28 Thread Paul Higgins
Thanks, I will try both suggestions. Much appreciated! Paul From: Mathias Hunskår Furevik <[EMAIL PROTECTED]> To: Paul Higgins <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] Connect to MySQL Database Using PHP Date: Sat, 28 Feb 2004 21:51:30 +0100 You can include a file with: $

[PHP-DB] Connect to MySQL Database Using PHP

2004-02-28 Thread Paul Higgins
would prefer not to do this. How can I connect to the database without having my sensitive information hard coded into the PHP? Thanks, Paul _ Find and compare great deals on Broadband access at the MSN High-Speed Marketplace. http

RE: [PHP-DB] What's wrong with this query?

2004-02-26 Thread Paul Fitz
You haven't done that a thousand times - the syntax is wrong :). You are using a combo of INSERT and UPDATE syntax there. Try INSERT INTO log (term, returns, time, date, ip) VALUES ('$search', '$arrayword',CURTIME(), CURDATE(), '$ip'); Cheers, Paul -

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Paul Miller
One way that I have found - but never used is... http://sqlrelay.sourceforge.net/ It can cache result sets in a file for later use. You can then use It does a whole bunch of other stuff too. I really need to install this and start working with it. - Paul -Original Message- From

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Paul Miller
should not store large amounts of data would be disk write/read speed per user. Can someone clarify this for me? - Paul -Original Message- From: Robert Twitty [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 12:34 PM To: Karen Resplendo Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB

RE: [PHP-DB] compiling oracle support

2004-02-12 Thread Paul Miller
I am using OCI-8 with Oracle 9i just fine. - Paul -Original Message- From: Adam Williams [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 9:13 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] compiling oracle support How do I compile PHP on Unix to have oracle 9 support. Looking

RE: [PHP-DB] Rules in a database

2004-02-06 Thread Paul Miller
I guess I did not pay attention that day in class, but that is cool. - Paul -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 9:14 AM To: DB list PHP; John Subject: Re: [PHP-DB] Rules in a database A bit of algebra first: any

RE: [PHP-DB] PHP Command Line

2004-01-29 Thread Paul Miller
php script.php %1 %2 %3 %4 And it is referenced as $argv[arg number] ... I think. To be sure, here is the link to that info: http://www.php.net/manual/en/features.commandline.php - Paul -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29

[PHP-DB] Wonder Program Question

2004-01-28 Thread Paul Miller
looking for one simple clean program that works a lot like my router or expensive routers I have used in the past. Some Foundry routers do this already and if I cannot do it server side I am going to consider that option. I am just wondering if any one knows of anything. Thanks, Paul Here is an

RE: [PHP-DB] Inserting querydata as default value in form

2004-01-28 Thread Paul Miller
Need some quotes Output will look like Instead of \ Which it probably looks like now. - Paul -Original Message- From: Georg Herland [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 12:05 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Inserting querydata as default value in

RE: [PHP-DB] php-db globals turned off

2004-01-27 Thread Paul Miller
you just use the extract function. Hope that is a bit clearer. - Paul -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 2:21 PM To: [EMAIL PROTECTED] Cc: 'Mignon Hunter'; [EMAIL PROTECTED] Subject: Re: [PHP-DB] php-db globals turned of

RE: [PHP-DB] Oracle and upper case field name

2004-01-27 Thread Paul Miller
the way I do it is with http://www.ytztech.com product SQL_AL.PHP which has a switch that will say all values are upper or lower. You can also create a simple wrapper function that will do the lower conversion. - Paul -Original Message- From: William Cheung [mailto:[EMAIL PROTECTED

RE: [PHP-DB] php-db globals turned off

2004-01-27 Thread Paul Miller
rod[] = $_POST['prod']; } With extract, if $_POST['prod'] is an array, then prod will be an array also. - Paul -Original Message- From: Mignon Hunter [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 2:09 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject

RE: [PHP-DB] php-db globals turned off

2004-01-27 Thread Paul Miller
Also, many legacy applications use the non $_POST variable definitions. A problem that I ran into. - Paul -Original Message- From: Mignon Hunter [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 1:47 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] php-db

RE: [PHP-DB] php-db globals turned off

2004-01-27 Thread Paul Miller
$_server and file upload params. The other option is change the php.ini file for that dir or globally. - Paul -Original Message- From: Mignon Hunter [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 12:56 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] php-db globals turned off How do

RE: [PHP-DB] Can anyone see what's wrong with this code?

2004-01-27 Thread Paul Miller
e($filedata, "$filename"); fclose ($fd); HTH - Paul -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 12:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Can anyone see what's wrong with this code? HI there Everyone, Finally fou

RE: [PHP-DB] Images stored in a db - how to get them?

2004-01-26 Thread Paul Miller
): = = THE FILE OPTION (local file system storage): = The GD library is for creating new images using specified parameters or editing an image. HTH - Paul -Original Message

RE: [PHP-DB] Stroring files as BLOBs in MySQL?

2004-01-26 Thread Paul Miller
One thing that is not a huge issue, just something to be aware of is the default 2mb limit in the php.ini file. It is easily changed if you want to upload bigger files. - Paul -Original Message- From: John [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 10:04 PM To: [EMAIL

RE: [PHP-DB] Results with ledger stripes?

2004-01-26 Thread Paul Fitz
Hi, You can use the modulus operator to create alternate colour rows. A bit simpler in code ;) See below - echo "DomainAverage Speed\n"; // Define count variable which is tested in loop $count = 1; while ($mongorow = mysql_fetch_array($mongo, MYS

RE: [PHP-DB] Database Abstraction Layer?

2004-01-21 Thread Paul Miller
. Either way adds a significant time to coding and product release initially. - Paul -Original Message- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:07 AM To: [EMAIL PROTECTED]; phpdb Subject: Re: [PHP-DB] Database Abstraction Layer? Hmm.. Thank

RE: [PHP-DB] Database Abstraction Layer?

2004-01-21 Thread Paul Miller
of success in the past. But it was never the DB calls that got me, it was the actually SQL. So I am building a swappable SQL library. The Propel solution would effectively negate me having to do that. - Paul -Original Message- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent

RE: [PHP-DB] Database Abstraction Layer?

2004-01-21 Thread Paul Miller
and any customizations are written in plain PHP. This will effectively that add SQL and DB dependence out of your mix. This is PHP5 also. HTH - Paul -Original Message- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 2:31 AM To: phpdb Subject: [PHP-DB

RE: [PHP-DB] Update problems

2004-01-20 Thread Paul Miller
You might want to use single quotes FirstName='$fname' $sqlupdate="UPDATE UserInfo SET ZNum='112763', FirstName='$fname', LastName='Short', TA='00', Building='1197', Room='112', Div=&#

RE: [PHP-DB] Re: Architecture Question - Opinion

2003-12-16 Thread Paul Miller
kend. call>SOAP client call--->SOAP server translation->DB call--Data call<-SOAP client acceptance<---SOAP server transmission<-DB response<-Base - Paul = I believe people are working on a SOAP extension to PHP in C, bu

[PHP-DB] Architecture Question - Opinion

2003-12-16 Thread Paul Miller
whole struct method and it is more complex. But the XML-RPC functions are written in C and the SOAP are in PHP. PHP 5 has better object orientation and new XML libs so the SOAP functions should run much faster, but still not native. What are your thoughts? - Paul

[PHP-DB] NEXTVAL Question

2003-12-11 Thread Paul Miller
works just fine. I have also tried: $sql = "select TEAM_SEQ.NEXTVAL from sys.dual"; $sql = "select TEAM_SEQ.NEXTVAL from dual"; all with the same results. I am running Red Hat AS, PHP 4.3, OCI8 Functions and Oracle 9i. - Paul -- PHP Database Mailing List (http://w

RE: [PHP-DB] Re: Oracle/PHP Issue

2003-12-05 Thread Paul Miller
Nope, that was not it? Still giving me the *** ORA-12545: Connect failed because target host or object does not exist *** error. Hm - Paul -Original Message- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 4:23 PM To: [EMAIL PROTECTED] Subject

RE: [PHP-DB] Splitting a string by a ,

2003-12-05 Thread Paul Miller
if the emails are in a CSV file, you can also use "fgetcsv" \n"; } } fclose ($handle); ?> - Paul -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 1:23 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Splitting a string

[PHP-DB] Oracle/PHP Issue

2003-12-04 Thread Paul Miller
TNS_ADMIN=/opt/ora9/product/9201/network/admin export ORACLE_DOC ORACLE_SID TNS_ADMIN Does anyone have any thoughts Thanks for any help, Paul ___ Paul Miller System-Wise pmillerATsystemDASHwiseDOTcom AT = @ DASH = - DOT = .

[PHP-DB] RE: Subject: Hitcounter works on production server but not on localhost

2003-11-20 Thread Paul Ihrig
relative path to FX_DataCounter/wcbecounter.txt as well Cheers - Neil. At 13:25 20/11/2003 +, you wrote: >From: "Paul Ihrig" <[EMAIL PROTECTED]> >Date: Wed, 19 Nov 2003 07:16:11 -0500 >Subject: works on production server but not on localhost > >hey guys.. >just

RE: [PHP-DB] works on production server but not on localhost :: fix

2003-11-19 Thread Paul Ihrig
how weird is this just had to uncheck "allow anonymous access". and keep checked "Integrated Windows authentication" just seems a bit silly... every thing works fine now. thanks for the help! will have better questions for you all in a day or so... -paul -- PHP Databas

RE: [PHP-DB] works on production server but not on localhost

2003-11-19 Thread Paul Ihrig
it's ntfs -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] works on production server but not on localhost

2003-11-19 Thread Paul Ihrig
ol password checked also Integrated Windows authentication checked. seems funky... i appreciate the help guys. -paul -Original Message- From: J.Veenhuijsen [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 8:27 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] works on productio

RE: [PHP-DB] works on production server but not on localhost

2003-11-19 Thread Paul Ihrig
nel -> Administrative Tools ->Internet Services Manager Click the "Default Web Site" on the list, directories will be shown Right click the directory the files reside and Select "Properties" You can give write permission to the directory here. HTH Mustafa - Original Me

RE: [PHP-DB] works on production server but not on localhost

2003-11-19 Thread Paul Ihrig
ok... im on xp running iis win i tried to figure out how to change permissions on files & did a few example but it never seemed to work. is there a free chmod tool? or a simple way to do it in windows? again, i am sure i sound noob, and am... thanks for the response. -paul -Orig

[PHP-DB] works on production server but not on localhost

2003-11-19 Thread Paul Ihrig
\WCBE\nav.php on line 26 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 27 any help would be great. thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problems building PHP with Informix support

2003-11-04 Thread Paul Gardiner
absolute ^%$"$! ;o) Regards, - Paul - - Original Message - From: "Daryl Biberdorf" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 01, 2003 8:54 PM Subject: [PHP-DB] Problems building PHP with Informix support > > I'm trying to get P

[PHP-DB] Using PHP to print using LP on Linux

2003-10-24 Thread Paul Fitz
Hi Guys, I suppose this isn't a database specific question, but it is the only PHP mailing list I am subscribed to. Trying to trigger a printer in the office hooked up to a Mandrake 8 box with PHP 4.3 to print a file remotely, using the 'lp' command. Uses a postscript template to create the t

[PHP-DB] Problem with SQL Anywhere 5.5 and PHP ODBC

2003-10-09 Thread Paul Ciba
php3) ! Paul Ciba [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP APACHE Database

2003-10-08 Thread Paul Ciba
php3) ! Paul Ciba [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MSSQL connection seems abandoned

2003-09-26 Thread Paul Yambor
Using PHP 4.3.1 MSSQL 7.0 Executing a Stored Procedure through the function mssql_query that returns a message of: "DELETE statement conflicted with COLUMN REFERENCE constraint... The statement has been terminated." causes the link to be unusable in executing function mssql_query again. Sql Ser

[PHP-DB] Category Listing

2003-09-21 Thread Paul B. \[pbcomm, aka WPD\]
ent 1 this way its easy to show dinamicaly where the user is (PHP: Database) by prividing index.php?dir=1&sub=1. What i want to do, is go 3 or 4 subs deep. I just wanted to get an idea on the best posible way of doing this. Thanks Paul B. -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] problems compiling with-informix

2003-08-19 Thread Paul Gardiner
I run Informix (SE7.25.UC4 - UC5 had a major bug) on RH8.0. It wouldn't run on RH9.0 because of the glibc 2.3.x conflict. I beleive Informix only supports glibc 2.2.x. at the moment. If it's possible, use RH8.0 as I know it works. - Paul - - Original Message - From: <[EM

Re: [PHP-DB] Database question

2003-07-03 Thread Paul Chvostek
tabase link identifier cannot be stored in a session variable and then re-used by another session. Check out http://www.php.net/features.persistent-connections for details. -- Paul Chvostek <[EMAIL PROTECTED]> it.canada

Re: [PHP-DB] Gnarley drop-down db problem

2003-06-11 Thread Paul
Please disregard. I found an idiotic typo in my code ;-) Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Gnarley drop-down db problem

2003-06-11 Thread Paul
both get the value from the query string and then send the changed value in the drop down. TIA, Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Optimize following Mysql-Query

2003-05-31 Thread Vaughn, Paul
going to match what is in the data exactly. - Paul -Original Message- From: Andr Sannerholt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 30, 2003 6:49 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Optimize following Mysql-Query Hi Everyone, I have the following Mysql-Query that retur

Re: [PHP-DB] File input from form not detected

2003-05-30 Thread Paul Burney
pen the temp file name, i.e., $_FILES["userfile"]["tmp_name"], usually something like /tmp/phpCcDfs. HTH. Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] File input from form not detected

2003-05-30 Thread Paul Burney
4.1 or above, you should probably be looking at the $_FILES array. - You must add an encoding type to the form -> enctype="multipart/form-data" HTH. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Optimize following Mysql-Query

2003-05-30 Thread Paul Burney
CT * FROM Firmennamen INNER JOIN Master ON Firmennamen.ID=Master.FN INNER JOIN Personen ON Master.NN=Personen.ID WHERE Personen.NAME LIKE '%$name%'"; Also make sure that you are indexing the fields that you are performing the joins on. HTH. Sincerely, Paul Burney <http://paulbu

Re: [PHP-DB] Modify php.ini setting in code

2003-05-27 Thread Paul Burney
vels in the hierarchy, each include call needs to be different. If your web host allows you to use .htaccess files and gives you override permissions, you can put this in the .htaccess file at the top level of your server. php_value include_path '/whatever/path/you/need/here:.' Sincerely,

Re: [PHP-DB] Session variables

2003-04-06 Thread Paul Burney
ld also do: $_SESSION = array(); Before the calls to unset and destroy. See the comments on this page for a bunch more information: <http://www.php.net/manual/en/function.session-destroy.php> HTH. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Oracle oci8

2003-04-05 Thread Paul Dymecki
Hello, I'm sure this question has been asked, but i was wondering if anyone has successfully gotten oci8 working with php on windows? I've been trying for quite awhile with no success. thanks for any help, Paul _ Pr

Re: [PHP-DB] naming conventions

2003-03-30 Thread Paul Burney
$query for the query, and $line for the returned record array. A lot of database classes use $db as the new object. Hope that helps. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP for apache logging to mysql

2003-03-28 Thread Paul Burney
aying with JPGraph to produce some nice charts). Cool. We'd love to see some of your results when they are usable. Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP for apache logging to mysql

2003-03-27 Thread Paul Burney
ould be welcome. :-) This gives the top servers in order of hits: select count(*) as hits,server_name from access_log_archive group by server_name order by hits desc; Note: If your server is busy, you should query from another "mirrored" table that isn't being accessed all the t

Re: [PHP-DB] Generating view of tree?

2003-03-27 Thread Paul Burney
;http://www.dbmsmag.com/9605d06.html> <http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm> Hope that helps. Sincerely, Paul Burney <http://paulburney.com/> Q: Tired of creating admin interfaces to your MySQL web applications? A: Use MySTRI instead. Version 3.1 now

[PHP-DB] mysql timestamps

2003-03-23 Thread Paul Sharpe
how do i change the format of a MySQL timestamp (i.e hh:mm:ss DD/MM/ instead of MMDDhhmmss) retrieved from a mysql database with php? thanks in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Gathering data from a database

2003-03-22 Thread Paul Burney
on 3/22/03 8:26 PM, Mike Delorme at [EMAIL PROTECTED] appended the following bits to my mbox: > $select = "mysql_select_db ($database)"; Remove the quotes around this. Actually, there is no reason to do the variable assignment either. Sincerely, Paul Burney <http:

Re: [PHP-DB] Re: deleting records using a checkbox

2003-03-20 Thread Paul Burney
he name element, but it works very well. Another idea is to use "id" elements for JavaScript / DOM interaction and reserve the "name" elements for php. That should work on any modern browser (sorry, no Netscape 4.x). HTH. Sincerely, Paul Burney <http://paulburney.

[PHP-DB] mysql_connect() problem

2003-03-17 Thread Indrajit Paul
Hi, I am using Apache 2 in Linux 8 .Whenever in my php script I want to connect to mysql through mysql_connect() function a error occured. My script is like that $linlid=mysql_connect("localhost","user1","user1")or die("Connections failed"); print "Connected successfully"; The script wri

Re: [PHP-DB] Real Killer App!

2003-03-16 Thread Paul Burney
applicable. Unless you're running out of memory? Or maybe the server can't handle all the connections? If so, you could try sleeping for a second every 10 times through the loop, etc, to slow down the process and maybe keep it from dying. Hope that helps. Sincerely, Paul Bur

Re: [PHP-DB] Real Killer App!

2003-03-13 Thread Paul Burney
mples/examples/examples/examples/e xamples/examples/somefile.html As far as apache is concerned, it is fulfilling the request with the examples.php file and php just sees a really long query_string starting with /examples. I'm sure that isn't your problem, but I've been bit by it a f

Re: [PHP-DB] receiving date elements from Access

2003-03-09 Thread Paul Burney
ge that data in criteria doesn't match. (free > translation) > The field Datumsfeld is a date field with the syntax DD.MM. (German way) Maybe you should try the date in the syntax the database uses, i.e., 12.12.2002? Sincerely, Paul Burney <http://paulburney.com/> -- PHP Dat

Re: [PHP-DB] file save part 2

2003-03-08 Thread Paul Burney
("\r\n", $_POST); If that doesn't help, send an example of what you want the data to look like. Sincerely, Paul Burney -- I'm inhaling Caesar's last gasp... http://paul.burney.ws/thoughts/caesars_breath.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] explode string variable

2003-03-08 Thread Paul Burney
"Willy-Brandt-Platz-5" > > I want to have an array that looks like this: > $variable_array[0] should be "Willy" > $variable_array[1] should be "Brandt-Platz" Wrong list since doesn't involve databases. Should be on PHP-General. That said, use strtok:

Re: [PHP-DB] query that finds when something is NOT IN a table

2003-03-06 Thread Paul Burney
ewrite the query with a JOIN, something like: SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.table1_id WHERE table1.sold=1 AND table2.table1_id IS NULL; (not tested) More info can be found here: <http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html> Hope that helps. S

Re: [PHP-DB] Help with a query

2003-03-03 Thread Paul Burney
MS? That is, perhaps session_id() or $customer_id is not giving a valid value. 3) Using the results of (2) above, have you input the query into another RDBMS client (i.e., command line version) to see what kind of errors are given. HTH. Sincerely, Paul Burney <http://paulburney.com/> --

  1   2   3   4   >