[PHP-DB] LDAP

Hello all, I've got a problem with PHP and LDAP. Every times, i want to connect to the serveur: I've got an error. It's "call to undefined funcion ldap_connect" ! I have tried the php manual example but the error is the same... I think i've forget to put something like ./configure --ldap chen i

[PHP-DB] email and groupware integration

How to integrate email and groupware? is there any scripts to grep email and output to forms or databases. Thx for your help __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

[PHP-DB] 2 mysql connections to same server?

connection for session handling and another one for normal database interaction. But connecting to the same server (different database) a second time kinda overwrites my previos connection and gives back the same resource id. Thanks for help, Tom -- PHP Database Mailing List (http://www.ph

Re: [PHP-DB] cookie problems

://www.php.net/manual/en/function.setcookie.php if you still can't get it working, let us know... Tom At 23:40 10/07/2001 -0700, you wrote: >HI, >my guess is is that the cookies will be killed the NEXT time you run this >script. > >Ken >- Original Message - >Fro

Re: [PHP-DB] Row order

Cookie or session? A little extreme, but if you don't want it in the url then that's the only other way I can think of to remember a variable when the page is refreshed.. Tom At 13:09 11/07/2001 +0200, you wrote: >Hello! > >I have this little problem sorting a search

[PHP-DB] Re: NEXT - PREVIOUS coding

Hi, what about other possibilities to do this ? Tom U¿ytkownik "Manuel Lemos" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello Pranot, > > On 16-Jul-01 06:09:33, you wrote: > > > >hi.. friends > &g

[PHP-DB] Protecting php scripts from source being downloaded

the above? Or just hid the password somehow? Im using IIS 5.1. thanks tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Protecting php scripts from source being downloaded

ors. so u can inclue the page > perfectally.. & when people try to look @ it, it will say it doesnt exist. > > Neil > > - Original Message - > From: Tom <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 09, 2002 8:00 AM > Su

[PHP-DB] Updating a value usins MsAccess db?

or in UPDATE statement., SQL state 37000 in SQLExecDirect in c:\inetpub\wwwroot\dbtest.php on line 19 thanks --tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Damn Cookie

what is probably happening is that your file, page.html is setting the variable user_name to a value at some point in the script. The URL you gave effectively is the same as making the first two lines of the file read $user_name='name'; $password='password'; Hence if a subsquent line in the scrip

Re: [PHP-DB] pop up windows

r on the server would run first, and replace the echo statement with the value of $users, and then return the javascript for the users machine to process, ie the user in this case would recieve the following (assuming $user="bjorn"): alert('bjorn'); Hope this helps, Tom On

Re: [PHP-DB] insert into mysql

ter data of some sort? If not (i.e. > if ID is an int) then remove the single quotes. > A trivial point this, but if you insert values in ' into a mysql int column then MySQl still treats it as intended. THey aren'

Re: [PHP-DB] Migrating MySQL Table Data

ows) 2.1. extract the fields from the currently selected row 2.2. INSERT this into your new table 2.3 go onto the next row 3. Once all are done, drop the unwanted columns from your old table Inelegant ,yes, but it will work! If you want more help, contact me OL Tom On Sun, 4 Feb 2001, phobo wrot

[PHP-DB] Recursive photo gallery removal problem.

ISAM; uniqueid is the id of the folder. gallery is the folder depth (0=photo, 0=main folder, 1=sub folder level 1, 2==sub folder level 2...) location is the folder this sub-folder is located in Seems this code may be fairly complex. I've made about three attempts, with no success and I fi

[PHP-DB] Re: Recursive photo gallery removal problem.

No solutions or feedback? :( -Tom Reed [EMAIL PROTECTED] "Tom Reed" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I designed a photo gallery system, in which I allow users to create > recursive photo "folders." The trouble I am having is being

[PHP-DB] New To PHP

I ma trying to learn PHP and am having difficulty with understanding it. Is there a good PHP creator that will create PHP which will let me specify what all I need to have done so that I can go back and try to figure out just how it all fits together? Thanks, Tom KI8IZ http://www.wooster

RE: [PHP-DB] New To PHP

be gladly accepted. Thanks, T At 08:11 AM 4/15/04 -0400, Galbreath, Mark A wrote: I found Lerdorf and Tatroe's "Programming PHP" (O'Reilly 2002) extremely helpful in understanding the "why" of PHP. Mark -Original Message- From: Tom Cloyes [mailto:[EMAIL PRO

Re: [PHP-DB] New To PHP

ogether? Thanks, Tom KI8IZ http://www.wooster-isp.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ___ Sent by ePrompter, the premier email notification software. Free d

[PHP-DB] mysql multi-row insert limitations?

gt; Enter's three rows in the database? -tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Basic Doubts

xt and the text box on the page. 4. I also want to check the validation of text(numerical or text) Any example script would be helpful. thanks in advance. - Do you Yahoo!? Yahoo! Tax Center - File online by April 15th Tom KI8IZ http://www.wooster-isp.net -- PH

Re: [PHP-DB] New To PHP

hotscript codes also helps you understand the logic of it. Mike On Apr 15, 2004, at 12:53, Tom Cloyes wrote: I ma trying to learn PHP and am having difficulty with understanding it. Is there a good PHP creator that will create PHP which will let me specify what all I need to have done so that I can go

[PHP-DB] Posting Data to MySQL

one advise how they code large forms like that and if you know of any software to make it easier? I've searched Google for hours and checked loads of Database scripts on sites like Hotscripts, but can't find anything. Thanks, Tom

[PHP-DB] Date Select

How can I query a MySQL table to get the latest results from a date field? Basically, I am inserting several records at a time at the end of each week. I want to have a page that displays the results for the last week only. The date format in the field is -MM-DD

RE: [PHP-DB] Date Select

Jeffrey, Thanks for this, I've just realised that it's always the same no of inserts, so perhaps I should just order by date then my previous sort field and then limit the result to 20? (It's all 20 results that I need displayed) Thanks, Tom -Original Message- From: [

[PHP-DB] Best table structure

have one row for all 81 variables ($name, 20 x Position, 20 x Artists, 20 x Titles, 20 x Labels.) I know that the latter will be easier to query. Also, without maintenance, the size of the table for the current method will get extremely large. Will that affect server performance? I am still a newbie, so plain explanations would be most appreciated. Thanks very much in advance. Tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] newlines to BR tag

ne codes >may repeat severaltimes and should be changed > to only one SINGLE newline and after read >from DB it will be easily coverted to BR tag >by nl2br($foo) func. Instead of using nl2br you could just use $foo=preg_replace("/(\r\n)+/","",$foo). --- Tom Cri

[PHP-DB] Need simple example for making an odbc connection

I am very new to php and I need a simple example for connecting and retrieving from an odbc connection. The code I am maintaining currently accesses MySql using the built in functions for it, but I need to access DB2 and Access databases. Thanks - Tom -- PHP Database Mailing List (http

[PHP-DB] left joins and mysql

Hi, I am trying to do a left join on a "master" table, but I don't want to pull all the records from this table. Can anyone tell me the syntax for using a WHERE or equivalent on the master table before left joining the slave table? Is this possible, or do I have to pull all the records from the

[PHP-DB] Filesystem functions and mysql

Hi, I'm working on a website for a local tennis group, and we are raising money to offset website costs through sponsorships. I have created some 15 and 30 second GIF's for the sponsors, and would like to create a function that loads the files in random order when the page is opened. I am creati

[PHP-DB] Re: [PHP] New Question...tables

e data out of a table, and, ideally format the html into a table for display. Have them enter the data as a comma delimited list like this: [table] Name,Address,City,Country Tom,Home,Brisbane,Australia ... [/table] Then you could parse looking for [table] and work on the data after till [/table

[PHP-DB] Problem after upgrading to PHP 4.2.3

I recently upgrade to PHP 4.2.3 and started having problems with one of my applications. I have a PHP application that interfaces to a MySQL DB (version 3.23) all running on an Apache web server (1.3) under Linux 7. Up until doing the upgrade, everything had been working fine. Now on a daily ba

[PHP-DB] Re: [PHP] Enum table entry

so you can serialize it as is and store it. Playback is simple too '; } Un-checked boxes are not returned in the post and checked ones return Yes I think. -- regards, Tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re[2]: [PHP] Enum table entry

> table. Some of you people are pretty freakin' smart. :) JN> One note though, when you pull the serialized data out, you may have to JN> stripslashes before unserialize... JN> $school = unserialize ( stripslashes ( $row['school'] ) ); JN> Tom Rogers wrote: >&

Re: [PHP-DB] php/mySQL and html

is however appropiate in your code $users_state = "AK"; //(for the sake of argument) //create array of states (better way of making the form $states = array("AK","AR",); $numstates=count($states); echo(" $currstate");//finish the tag } echo("");

[PHP-DB] displaying multiple results only one time...

d, build an array of Prod_IDs used. then run the second query and put a condition in that only displays if the returned Prod_ID is not an element of the array. which of these solutions would be more efficient? and are there any more ele

RE: [PHP-DB] imap problem

h the --imap flag (I think, something like that) although I had no end of trouble getting this to work, Regards Tom Hodder -Original Message- From: vipin chandran [mailto:[EMAIL PROTECTED]] Sent: 20 June 2001 18:54 To: [EMAIL PROTECTED] Subject: [PHP-DB] imap problem Hi, I am devel

[PHP-DB] Compile MySQL 3.23.39 problem after installing PHP 4.06

Hi: After I have successfully installed PHP 4.06 then I want to upgrade my MySQL 3.23.37 to 3.23.39 using source method. After downloading and tar, Then I type "./configure --prefix=/usr/local/mysql" During make process.Error occurs.Here's some warning message: In file included from /usr/inc

[PHP-DB] perl fork() in PHP?

Can I do something similar to the perl fork() in php and if so, does anyone know of any examples of this. regards Tom Hodder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

Re: [PHP-DB] Which state and country?

This can give a fair idea of where that person has come from, and if they are international then the country may be obvious. I would be very surprised if you could collect meaningul information about which state they are tho. In my experience, however, lots of hosts turn off reverse DNS lookups...

RE: [PHP-DB] Submiting forms to mySQL

the javascript onSubmit events to manage which form gets what. Regards Tom -Original Message- From: James Wharton [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 20:36 To: [EMAIL PROTECTED] Subject: [PHP-DB] Submiting forms to mySQL I would like to have a three frame webpage. The data entry woul

[PHP-DB] MySQL Database Locking - needed?

any on-line documentation on this? 3) What other problems could arise if this was implemented? Thanks all Tom Peck -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators

Re: [PHP-DB] HTML question

Is /htdocs/ your web root? If it isn't the browser loading up the page would not have access to /www/img/backgroundimage.jpg. If it is - try removing the space after the .jpg in your body tag. Tom At 15:51 10/07/2001 -0700, you wrote: >Hello, pure HTML server question: > &

Re: [PHP-DB] Re: MySQL Database Locking - needed?

.. Changing databases seems a little extreme - and not possible with our web host. Tom At 20:03 10/07/2001 -0300, you wrote: >Hello, > >Tom Peck wrote: > > > > Hi > > > > The company I work for has recently developed a Car Dealer type site, which > > acts as a

Re: [PHP-DB] HTML question

some basic html tutorials or something :-) Tom At 16:19 10/07/2001 -0700, you wrote: >HI, thanks >not sure what the web root is. >first dir I see on FTP is / so is that the root? >and it contains a whole bunch of dirs including htdocs >htdocs contains dirs: img (pics)

Re: [PHP-DB] Re: MySQL Database Locking - needed?

first closes his browser before updating the car? How can that text file be automatically erased? I think I'll just assume that this wont be a problem, and if someone overwrites someone elses edit then too bad.. :-) Tom At 16:30 10/07/2001 -0700, you wrote: >Tom Peck wrote: > >

Re: [PHP-DB] HTML question

tag: (for /www/) or (for /www/ and /www/util/) or (for /www/util/) Tom At 16:38 10/07/2001 -0700, you wrote: >I Looked up the root..sorry > it is DOCUMENT_ROOT .. /htdocs/www >so I guess browsers think they are starting out at /htdocs/www and can't go >below to get a

Re: [PHP-DB] Re: MySQL Database Locking - needed?

Ahhh, ok a good idea. I will think about it some more. Thanks Tom At 16:55 10/07/2001 -0700, you wrote: >Tom Peck wrote: > > > > > >How about writing a text file that would be your "lock" file, rather > > >than depending upon MySQL to do it for you? &

Re: [PHP-DB] RE: trash last message ,this ones right I think

util folder, then you have to use: http://www.consumergrapevine.org/img/background.jpg";> So that the browser can reach the image file. Tom At 17:30 10/07/2001 -0700, you wrote: >Hello again, > DOCUMENT_ROOT is.. /htdocs/www >I have a php file ( showdatabases.php

Re: [PHP-DB] RE: trash last message ,this ones right I think

Yes that is correct. Your main site root is: /htdocs/www/ And your sub site (util) root is /htdocs/util/ These are two different sites from the browser's point of view. Neither site will have access to anything below the root folder (from the browser). Tom At 18:02 10/07/2001 -0700

[PHP-DB] Re: trash last message ,this ones right I think

Perhaps you could consider using the webserver config (in Apache it would be the httpd.conf file) to do the dirty work. Create and alias (in the /util/ domain) for "img" that points to the "/hdocs/www/img/" location - voila! YMMV HTH Tom Henry Ken Sommers w

Re: [PHP-DB] RE: trash last message ,this ones right I think

http://www.yourdomain.com/www/index.php or wat eva.. not very nice.. Tom At 18:26 10/07/2001 -0700, you wrote: >Thanks again, >why couldn't the main root be /htdocs/ >? >ken >- Original Message - >From: "Tom Peck" <[EMAIL PROTECTED]> >To: "

Re: [PHP-DB] LOAD DATA LOCAL ERROR

I may be not understanding properly without checking your MySQL syntax, but should it not be "C:\WINDOWS\Desktop\db.txt"? Tom At 08:53 10/07/2001 -0500, you wrote: >Every time I use the command > >LOAD DATA LOCAL INFILE "C:WINDOWS:Desktop:db.txt" INTO TABLE

[PHP-DB] Oracle Client Libraries?

is apparantly no longer running. Anyone? Thanks. Tom Tsongas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Oracle Client Libraries?

sions' section. I'm 'guessing' I only need to restart Apache now to activate the extensions. In my scenario, php and Apache are on my local NT server while the Oracle database is on a Solaris box. Anything else I need to know? Thanks in advance. Tom Anthony Carlos

Re: [PHP-DB] Need a shopping cart

f you are setting up a shopping cart site. Tom At 18:46 11/07/2001 -0700, you wrote: >Can anyone direct me to a shopping cart package (preferrably in PHP, >although PERL would possibly work) which utilizes either an MS Access >database or flat files? I've found several shopping c

Re: [PHP-DB] pulling my hair out

ual/en/function.setcookie.php If that still fails to work then your PHP config must be awry.. Tom At 21:16 11/07/2001 -0700, you wrote: >I have one script that looks like this: > >setcookie ("logged_in", "yes", time() - 3600); >setcookie ("logged_user_nam

Re: [PHP-DB] pulling my hair out

Stupid html e-mail... That code may not come through properly... copy it from the site, as what's below is only half complete. Tom At 16:23 12/07/2001 +1200, you wrote: >Brad > >Try this: >-- >$status = 0; >if (isset($myTstCky) && ($m

RE: [PHP-DB] Need a shopping cart

Matthew So what's so funny about installing MySQL on a NT system that is already running Perl and PHP? I think it makes perfect sense :-). Tom At 00:52 12/07/2001 -0400, you wrote: >Everyone suggesting "Easy! Just install Mysql!" makes me laugh... :) > >Jeff-- I

RE: [PHP-DB] NEXT - PREVIOUS coding

rough and readysomething like this should work... $pagesize = 20; $page = $page ? $page : 1; $pages = ceil(mysql_num_rows( $results ) / $pagesize ); mysql_data_seek( $results, ($page - 1) * $pagesize ); while( ($row = mysql_fetch_object( $results )) && ( $counter++ < $pagesize) ) { //

RE: [PHP-DB] Re: enum !!

First normal form (1NF), A table in which the intersection of every column and record contains one, and only one, value. -Original Message- From: Hugh Bothwell [mailto:[EMAIL PROTECTED]] Sent: 16 July 2001 19:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: enum !! "McShen" <[EMAIL PR

Re: [PHP-DB] who's logged on / how to I find out about other sessions

y to count the users whose time of last access was within 30 mins of now. Hope this makes sense, Tom > Hi, > > I'm writing a bbs/messageboard system and am trying to figure out how to tell > what other users are logged on. > > I know I could store the info in a table in my

RE: [PHP-DB] cancel <20010723135436.90722.qmail@pb1.pair.com>

What was all that about~?? -Original Message- From: Christian St-Pierre [mailto:[EMAIL PROTECTED]] Sent: 23 July 2001 16:02 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] cancel <[EMAIL PROTECTED]> This message was cancelled from within Mozilla. -- PHP D

[PHP-DB] writing an Oracle blob to file system?

I need to pull oracle blobs out of the database and write them to the file system (Solaris). Has anyone had any success doing this? Tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

Re: [PHP-DB] Limit Select Field Characters?

left(timestamp,6) - Original Message - From: "Jeff Oien" <[EMAIL PROTECTED]> To: "PHP-DB" <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 11:33 PM Subject: [PHP-DB] Limit Select Field Characters? > I have a timestamp field that looks like this > 0109011754 > but I only want to comp

Re: [PHP-DB] phpMyAdmin: delete table

> Don't know about phpAdmin, but in straight PHP, after you've connected to > database, etc. > > $sql = "drop table tablename"; > $result = mysql_query( $sql ); Do yuo use PHP anyway? the comment on that was probably it. Otherwise, if you ahve command line access to mysql then the above SQL (DRO

Re: [PHP-DB] #usr showing up

why is that line in there at all? The fact that the file has a .php extension and is going thru apache is enough... delete it and php should work fine. - Original Message - From: "Vipin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 02, 2001 12:48 PM Subject: [PHP-DB]

[PHP-DB] mail problem with ... Unbalanced '<'

print '$subject = '.$subject."\n; print '$this->mime = '.$this->mime."\n"; $to = "Tom Hodder" <[EMAIL PROTECTED]> $subject = htrheht $this->mime = This is a MIME encoded message. --=_ab31b283

Re: [PHP-DB] Valid resource

is $file the result of a fopen? - Original Message - From: "Wilmar Pérez" <[EMAIL PROTECTED]> To: "PHP List" <[EMAIL PROTECTED]> Sent: Monday, August 06, 2001 5:31 PM Subject: [PHP-DB] Valid resource > Hi guys. > > I'm getting the following error and have no idea what the hell it means:

[PHP-DB] OCI support not functioning

.conf accordingly so I know php is running. However, any time I attempt to utilize oci8 functions like ocilogon, I get 'undefined' function errors. These php scripts work on my W2K system running PHP4 with Apache. Any ideas folks? Did I miss a step? Thanks in advance! Tom -- PHP D

[PHP-DB] How to tell if a mysql table is locked

I have a crontab job that locks a mysql table as it needs to process the information in it only once. But subsequent scripts don't timeout, they just sit and wait. Is there any way of telling if a mysql table is locked? Thanks Tom Hodder -- PHP Database Mailing List (http://www.ph

[PHP-DB] Oracle CLOBs and carriage returns

chInto($sql_comments, $row, OCI_ASSOC+OCI_RETURN_NULLS)) { $lob_data = $row["COMMENTS"]->load(); echo $lob_data; } I know the information is stored correctly since a SQL query from the command line works properly and all formatting is displayed. Any thoughts? Tom -- PHP Database

Re: [PHP-DB] Oracle CLOBs and carriage returns

Thanks Anthony. The tags worked perfectly! Tom Anthony Carlos wrote: > Tom: > > I suspect that your problem is with the HTML, not the CLOB itself. Have you > tried echoing $lob_data in between tags or using the nl2br function in > PHP? It converts nl's to tag

[PHP-DB] SELECTS from multiple tables

the SELECT candidates.ID as canID, client_ID as cliID to the queries. Regards Tom Hodder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

[PHP-DB] Re: Show abbreviated article

For your problem it might look like $sql = SELECT field1, field2, SUBSTRING(blobfieldname,0,160) FROM articles where ( BTW I usually assume prox 8 chars per word for something like this so 20 wds x 8 char = 160 chars total BUT you might have lots of esoterica in there and might want to adjust

RE: [PHP-DB] mail function

check that you have either specified [mail function] ; For Win32 only. SMTP = mail.myserver.com ; For Win32 only. sendmail_from = [EMAIL PROTECTED] or the sendmail path here; ; For Unix only. You may supply arguments as well (default: 'sendmail -t -i'). ;sendmail_path = /usr/bin/sendmail o

[PHP-DB] Re: mcrypt, postgres, only returning half the data

for encoded data. And - try skipping the add slashes step - what happens??? Good luck, Tom Henry John Starkey wrote: > Hello all > > I'm working on encoding some data going in and decrypting coming out of postgres. >I'm adding slashes going in and stripping them coming out

Re: [PHP-DB] Include

Yes that is correct. On a security point of view therer is something extra you can do.. when using require you can require files that are outside the web tree...by this I mean are not accessible thru the internet. So if you site was in /home/web then you could setup a directory, say /home/web_v

[PHP-DB] phpMyAdmin (well mySQL) and listing DB's

s all the dbs. Anyone have any advice? TIA, Tom Tom Carter Web Architect roundcorners ltd. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] ORA-12541: TNS:no listener error

is accurate. Is there something new I have to do with 9i? Tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: ORA-12541: TNS:no listener error

ibclntsh.so.8.0 corresponding to the older oracle library. If you create a symbolic link to the oracle 9 library as follows: ln libclntsh.so.9.0 libclntsh.so.8.0 it will compile and build. Tom Joe Casey wrote: > What module did you build PHP with? We tried rebuilding PHP 4.06 with oci8 > afte

[PHP-DB] Accessing Oracle 9i locally

(SID = etrack9i)))"; $connection = ocilogon("system","manager",$db); How should the above look if its a local connection? Tom Tsongas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

[PHP-DB] Tablename issue..

SQL error: [ISAM]No data found, SQL state S00 in SQLExecDirect in c:\inetpub\wwwroot\test8.php on line 14 but removing the spaces from the tablename and updating the php fixes it.. any ideas? $sql2 = odbc_exec($conn,"SELECT Character_Field FROM ABC - Table"); Thanks, -Tom -- PH

Re: [PHP-DB] Tablename issue..

8 database. Thanks - Tom "Ryan Marrs" <[EMAIL PROTECTED]> wrote in message EA9290E62E6CD311859200805F85164902FB13DE@EXCHANGE">news:EA9290E62E6CD311859200805F85164902FB13DE@EXCHANGE... > Try putting Brackets [] around the spaces. This will typically fix the > problem,

[PHP-DB] Error inserting CLOB

T) or die("Couldn't execute statement."); $clob->save($comments); // Commit Statement $result = OCICommit($connection); The SQL statement works fine when I remove the CLOB portion so I know the rest is correct. HELP Tom Tsongas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] implementing php with IBM branded apache

What OS are you running on it? I've used php on an rs6000 while at IBM. worked fine, I didn't install it tho, but I don't think they had any problems. HTH, Tom - Original Message - From: "Marc Grober" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

Re: [PHP-DB] SQL combine to summations queries?

> Hello, > > I don't understand the following, who can help? > > I have got two queries: > SELECT SUM(fielda) FROM table1 > and > SELECT SUM(fieldb) FROM table2 > > I thought this would be the same as: > SELECT SUM(fielda.table1),SUM(fieldb.table2) FROM table1, table2. > But, itn't, why? I

Re: [PHP-DB] Backups, best practices

> you can get command line zip/compression packages for windows, although for > *some* reason, as far as i know, not a command line version of winzip - the > big one! err.. please correct me if I'm wrong, but isn't pkzip exactly that? or more exactly, winzip is a windows interface to it? it cert

Re: [PHP-DB] USA Attacks

now isn't the time for these kind of discussions, and nothing can excuse the death of all those innocent people. America as a nation is far from innocent however, I agree with you on that Lars. My sincerest condolances to all those involved. Let's just hope that the crazy man bush doesn't do any

Re: [PHP-DB] db's war

e job. Well, there's my ha'penny's worth. Anyone want to start a DB2 / Oracle debate? (JOKE been there done that, neither won) Tom - Original Message - From: "Sommai Fongnamthip" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 18,

[PHP-DB] Appending to a CLOB

ent is not a valid OCI8-Connection resource in /www/htdocs/Etrack/oracle_update.php on line 66 Couldn't parse statement. Help!! Tom Tsongas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] MySql special characters (éàôï)

Hi ! My question is pretty simple. How do I specify a language for MySQL ? I cannot retreive (or correctly insert, i'm not sure) any accentuated characters (french canada) from my database with php, ODBC or the mysql client. I may be a little off-topic, but it's pretty important for me to be able

[PHP-DB] php bulletin/dicussion board

Hi, can anyone recommend a good php discussion/bulletin board thats free, as I need to choose one and have been over whelmed by the variety available. Cheers Tom Hodder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

[PHP-DB] Database Security

you send us. Thanks for your time Tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: FW: [PHP-DB] How to install PHP-DEV package for PDO_OCI

It's in php-devel. To find out what package something is in you can ask yum # yum provides phpize and it will tell you php-devel.i386 5.1.4-1updates Matched from: /usr/bin/phpize /usr/lib/php/build/phpize.m4 Choy, Wai Yew wrote: Hi, Any kind soul o

Re: [PHP-DB] Compare a given value with multiple values field

If you have the literal string "3,31,11,10" in a field in your table then you can 'search' for numbers in the string like this: SELECT * FROM table WHERE CONCAT(',', tablefield1, ',') LIKE '%,3,%' I don't know if it's the best way of doing it but it works for me. Natalie Leotta wrote: I'm not

Re: [PHP-DB] Probleme with MySQL queries

Hi , For this situation , you should print out the SQL statement to check the value of the variable "$var" . -- From: "David DURIEUX" <[EMAIL PROTECTED]> Sent: Wednesday, September 03, 2008 5:07 PM To: Subject: [PHP-DB] Probleme with MySQ

[PHP-DB] Mysterious 5 second delay on sybase_connect()

aviour? Cheers, Tom Lloyd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Mysterious 5 second delay on sybase_connect()

May 2012 13:00 To: Tom Lloyd Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Mysterious 5 second delay on sybase_connect() On Thu, May 24, 2012 at 10:51 AM, Tom Lloyd wrote: > Hi there.  I'm working on a PHP-driven project on Debian Squeeze that > connects to an instance of Microsoft SQ

RE: [PHP-DB] Mysterious 5 second delay on sybase_connect()

carries on doing what it was doing. Why would it be doing a DNS lookup for the IPv6 address of its own hostname? And more urgently, how can I stop it? -Original Message----- From: Tom Lloyd Sent: 24 May 2012 16:26 To: 'Matijn Woudt' Cc: php-db@lists.php.net Subject: RE: [PHP-DB]

RE: [PHP-DB] Mysterious 5 second delay on sybase_connect()

nsswitch seems to be OK, but it wasn't aliased to localhost for ipv6. I've fixed that now (and knocked back the ipv6 precedence in /etc/gai.conf) and it seems to be behaving... Still doesn't explain to me why it was looking itself up in the first place... Weird :/ -- Tom

  1   2   >