Re: [PHP-DB] PHP/Apache not totally closing MySQL connections

about 5 of these sockets hanging around while new connections continued to >appear. that's because you're running more than one apache process, the number of closed sockets should be proportional to the number of apache processes (as set by httpd.conf). -- Andreas D Landmark /

Re: [PHP-DB] PHP/Apache not totally closing MySQL connections

ck.) What is the problem here really? MySQL isn't chewing resources, Apache isn't chewing resources, the fact of the matter is that you're seeing closed sockets, sockets that will be reused when apache+php reconnects to MySQL. The only intriguing part about your post is that the

Re: [PHP-DB] date help

ce 19700101 or use your rdbms' datefield (most of them've got one). (I always prefer seconds as it's IMHO the easier to do calculations with) -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. --

Re: [PHP-DB] Access with PHP on Linux?

ow they're doing at the moment, but anything that tries to imitate something undocumented is a no-no in my production environments). -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mail

Re: [PHP-DB] Executing a shell script HELP!

get it working. =)"; > } > using `s doesn't work quite like they do in BASH (and many other scriptlanguages) use passthru() or something instead... I can't really see why you're doing this in PHP as BASH would be much more efficient... and to some extent easier, no

Re: [PHP-DB] guys here is my problem in a simpler way:)

y.options[x].text > > if(y=="Printers") > open("store1.php","newwindow") >} > > > > Why don't you pass the value along with the URL? open("store1.php?myvalue=wooosh", "newwindow") (and ofcourse use your pretty little function

RE: [PHP-DB] Huw do I perform update? I missed the accual code bi t.. sorry

cat_status' WHERE newscat_id='$newsid'"; What does mysql_error() say, and have you tried the query on the command line to get and exact pinpoint where the error is? (okay I admit I haven't even looked at the query as this sounds like a stupid mistake that could

Re: [PHP-DB] delete multiple entries from a database using PHP

ious "DELETE FROM " (tip: do not try that on useful information ;-) -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] random created numbers and letters

ave it up to the reader to decide how to create a password-fish out of a row of numbers... -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

RE: [PHP-DB] warning/error

result and $rseult) and the last time is reserved for special occations... to find out which either post code or DO SOME TESTING BEFORE POSTING! -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database

Re: [PHP-DB] Individual Lines of text

es of this text file and store them into a mysql database >line by line. > >Cheers if the lines are exactly as you describe them (ie. comma-separated) read the file line by line and use the explode() function to create an array of each line and flush it to the db of your choice... -

Re: [PHP-DB] Fatal Error

nning such an old version in the first place, why not put in a nice request and try to get them to recompile php (and perhaps move to version 4). -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database M

Re: [PHP-DB] about Printer()

ing game! -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To con

Re: [PHP-DB] Re: php and WAP?

y click) it's the end-user and not the developer who has to bother with it. Most WAP-serviceproviders provide their clients with http-gateways, and if not there are some free ones aswell that proxy user-requests and translate the http content to wml on the fly. -- Andreas D Landmark / noX

Re: [PHP-DB] include_path

php' (include_path='') in >/home/sites/site92/web/mall/confirmregistration.php on line 3 > > > > > > and my script is: > > > > > session_start(); > > require("connect.php"); > > ?> > > > > > > -- An

Re: [PHP-DB] php Please help

e, php-install would have been the list you should have posted to). -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] mysql errors....

please, pretty please.thanks > > >bwise We can't see them from here either, so you better post some code to illustrate your problem... -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. --

Re: [PHP-DB] When would it be 'good' to store binary data in a DB?

in databases is certainly one of the easier solutions. What you didn't write though, is how you use these files... (I didn't see the word 'PHP' mentioned in your post though...) -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, wh

Re: [PHP-DB] Connect to MySQL through Proxy?

(usually 1.0 and 1.1), mysql uses it's own protocol and has no means to communicate over http... Get your sysadm to open or map some ports for you so you can use mysql native, otherwise you'd have to do a dump and then import that on the other server, which would not be a 2-way sync...

Re: [PHP-DB] auto fill field with value from another

> >thanks, > >bill hollett subselects are nasty to implement in mysql (due to the fact it doesn't support them very-well/at-all depending on your viewpoint). but it is doable... -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake tim

Re: [PHP-DB] static or dynamic "printer-friendly" webpages?

time something changes, and requires an amount of work proportional to the number of pages, which could create a living hell somewhere down the line, especially if you have more than one webmaster. *dynamic-dynamic-dynamic* ;-) -- Andreas D Landmark / noXtension Real Time, adj.: Here

Re: [PHP-DB] MySQL Error???

se auto_increment instead). Also check your code for any errors around the insert statement... codesnipplets would be fine if you want the list to track this down... -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and

Re: [PHP-DB] Storing Code in a db?

use a script to pull the function out of the database, write it to a file, and then include your newly written file... Which ofcourse would require a reload or 2 scripts. I'd stick with a couple of includes if I were you =). -- Andreas D Landmark / noXtension Real Time, adj.:

Re: [PHP-DB] upload problem ...

At 25.06.2001 09:41, you wrote: >hi, > >i have a site and need to write a script to upload / download files so the >database can be updated / backed up. > >i've tried setting up an machine but php gives an eror onthe server saying that the /php/tmp dir >cannot be written to by, i assume, the nobo

Re: [PHP-DB] News(article) code that using PHP and MySQL

t.net (or the links at php.net). -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mai

Re: [PHP-DB] flash

to the _wrong_ list! http://www.php.net/manual/en/ref.ming.php and http://www.opaque.net/ming/ *jeez-some people* -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mailing List (htt

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

ggest you try again with some fresh sources for the linux-source and check again that you pasted the complete error message, as a munged one would only be confusing. -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there

Re: [PHP-DB] MAIL from php

r php install hasn't compiled in support for the mail() command, it might have been disabled on purpose, ask your admin. -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mailing List

Re: [PHP-DB] Password Protect page

At 22.06.2001 11:23, you wrote: >I tried but to no avail, I was trying to >send the header to redirect if the password in the input box matches the >database password but it kept saying that the header was already sent.. I >tried Javascript aswell, doing a location.href = "URL" within the "if" >s

Re: [PHP-DB] Connecting to MySQL

e that you are allowed to connect (either in mysql.db or mysql.user). btw. it's always a good idea to use a different topic than a subject just discussed.. -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- P

Re: [PHP-DB] newbie: Trying to select a database in php

gt;D:\ASP\test\php\default.php on line 18 Spelling mistake I take it, the error refers to "msql" while you're using mYsql... -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mail

Re: [PHP-DB] how to "email article to a friend"

take into account when writing a email-article-to-a-friend function, just to be on the safe side... -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] Query in a function

wouldn't be available inside the function and you'd either have to make them global, or pass them to the function. That could explain why you can't connect... -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occur

Re: [PHP-DB] newbie: showing records from SQL

t simpler than you think... If you look in the annotated manual you'll probably find some examples there too. -- Andreas D. Landmark / noXtension PGP ID:0xB2BEAE80 / 4096bits Fingerprint:654B 3BCD 1130 9B3A 08BB AB1A BF72 841D B2BE AE80 -- PHP Database Mailing List (http://www.php.net/)

RE: [PHP-DB] Can't connect to local MySQL server through socket '/tmp/mysql.sock'

At 26.04.2001 20:53, you wrote: > > > I have this error > > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' > > > (111) > >sounds like MySQL is not running on your server.. ensure it's installed >properly and has actually started, i think typing > mysqladmin -p version >

Re: [PHP-DB] mail system

At 26.04.2001 16:20, you wrote: >I was wondering if anyone had any ideas on how I can setup a email system , >internal using php and mysql only .. No Imap Server, or POP. Can someone >please guide me in the right direction ,, this is email sysetm would be only >for registered members. I am setting

Re: [PHP-DB] MySQL for Billng Question

At 26.03.2001 22:21, you wrote: >how bout something like this. > >You have 3 columns >TOTAL_HOURS | UNPAID_HOURS | LAST_PAID > >when you are paid, update TOTAL_HOURS to add UNPAID_HOURS and clear [delete, >or set to zero] the UNPAID_HOURS column... LAST_PAID would be type = >timestamp, or date. >Y

Re: [PHP-DB] continuously view database updates.

;re dumping heavy work on the DB this should be fine, if we're talking high-performance time-critical and or high-load stuff here, you might wanna look at somethingelse... -- Andreas D. Landmark / noXtension PGP ID:0xB2BEAE80 / 4096bits Fingerprint:654B 3BCD 1130 9B3A 08BB AB1A BF72 841D

Re: [PHP-DB] newbie question on form..

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At 25.03.2001 22:36, you wrote: >Hello boys that's ok?? well >I have this question >I connect to a database (on interbase 6) and retrive some datas from a >table... >now i want to create a form where the input field show old datas into