Re: [PHP] MySQL and PHP

2002-01-18 Thread DL Neil
Brandon, Please do some 'homework': Will the native query run from the MySQL command line, or in a admin tool? Have you tried varying the number of fields? What are the column specifications? In and amongst this you might like to check where you should have spaces (a) for legibility

Re: [PHP] Generating a new line in a text file

2002-01-18 Thread DL Neil
Chris, \n = *nix \r = Mac \r\n = PC (now that you've 'dropped' MS Notepad into the conversation...) The simplest M$ tools content themselves with black blocks (apparently not being interested in your comfort), but the more sophisticated tools will sometimes oblige... =dn - Original

Re: [PHP] checking the content?????

2002-01-18 Thread DL Neil
Dani, Am slightly confused/finding the question ambiguous. Could you provide the code you have so far, and the relevant column specification(s)? Could be simple or complex! =dn - Original Message - From: Dani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 18 January 2002 12:22 Subject:

[PHP] Re: [PHP-WIN] command line are -c doesn't work on win2k?

2002-01-18 Thread DL Neil
Jeff, The following batch files works for me (WinNTWS 4.0 SP6a):- cd c:\program files\php php.exe -q c:\.path.\w.php c:\.path.\webute.log NB the first line reflects my PHP config - your mileage may vary! Of course the other possibility is to add the PHP folder into the PATH environment

Re: [PHP] command line are -c doesn't work on win2k?

2002-01-18 Thread DL Neil
Mike and Jeff, what about the [EMAIL PROTECTED]? is it failing on a 'bad' email address? or maybe putting everything in variables and trying mail($to,$subject,$message); =there's a difference between the way PHP talks to an SMTP server (using mail()) on Win32 compared to *nix - which can

Re: [PHP] Re: [PHP-WIN] command line are -c doesn't work on win2k?

2002-01-18 Thread DL Neil
is already in the PATH variable... I'm not doing anything different that http://bugs.php.net/bug.php?id=6742 ,but for some reason the -c doesn't make a difference... Jeff. Dl Neil [EMAIL PROTECTED] wrote in message 0d4f01c1a00e$87036ee0$2916100a@jrbrown">news:0d4f01c1a00e$87036ee0$

Re: [PHP] command line are -c doesn't work on win2k?

2002-01-18 Thread DL Neil
path Look for php.ini file in this directory PHP is case sensitive (whereas Windows is not). Where is the .ini file? (not the PHP.exe file) Does this help? =dn - Original Message - From: Jeff D. Hamann [EMAIL PROTECTED] To: DL Neil [EMAIL PROTECTED]; mike cullerton [EMAIL PROTECTED

Re: [PHP] command line are -c doesn't work on win2k?

2002-01-18 Thread DL Neil
Jeff, FWIW my system is set up to hold PHP in C:\program files\php, which is where the php.exe can be found. PHP.ini is supposed to be in c:\winnt isn't it? =dn - Original Message - From: Jeff D. Hamann [EMAIL PROTECTED] To: DL Neil [EMAIL PROTECTED]; mike cullerton [EMAIL

Re: [PHP] Display a mesagge and redirect (newbie)

2002-01-17 Thread DL Neil
Alternatively, remember that HTML has this built in (and PHP outputs a HTML page): move c) before a) implement it using a meta tag in the HTML page HEAD section d) will then happen after the defined time period Regards, =dn - Original Message - From: Jon Farmer [EMAIL PROTECTED] To:

Re: [PHP] Display a mesagge and redirect (newbie)

2002-01-17 Thread DL Neil
Niklas, No good, since meta starts counting when page is first opened, so Don't think this is applicable - When is the page opened: after the script reaches the meta, or after the script concludes and the web server sends the page to the browser? If the latter, then the speed of the

Re: [PHP] fixing mail for broken Outlook

2002-01-16 Thread DL Neil
Hank, You say just text and text/plain. What do you mean by mungs the formatting? What formatting in plain text? =dn I've got an app that sends emails, not complicated emails, their just text, the mail text is stored in text files on the server so they can be edited independant of the code,

Re: [PHP] Mulitple Attachments using php

2002-01-16 Thread DL Neil
Sam, I know I hear you all groan with this topic... I know this topic has been asked before... But looking through the archives there have been a lot of advice, URLs, classes given out, yet I haven't really found anything that can easily be implemented so that I can send muliple

[PHP] Re: [PHP-DB] Re: [PHP] mysql_insert_id?

2002-01-16 Thread DL Neil
Hi Martin, 2 because the (function argument) controlling feature is the connection, it is not possible for another concurrent user to 'steal' your ID or influence the ID returned to you - it's all yours! Ok, assume you are correct, but what if you are using persistent connections (ie

Re: [PHP] mysql_insert_id?

2002-01-16 Thread DL Neil
Hi Jimmy, 2 because the (function argument) controlling feature is the connection, it is not possible for another concurrent user to 'steal' your ID or influence the ID returned to you - it's all Ok, assume you are correct, but what if you are using persistent connections (ie

Re: [PHP] mysql_insert_id?

2002-01-16 Thread DL Neil
Hi Jimmy, the only problem i can think of might occur with pconnect is, last_insert_id() will return you the last inserted ID from previous 'session', not current 'session'. to prevent this, you should call last_insert_id() only when your INSERT query executed succesfully. =Of course

Re: [PHP] mysql_fetch_row - how do I fetch a specific row?

2002-01-16 Thread DL Neil
Phil, After I make a queryhow do I fetch a specific row from that query ?? =isn't the purpose of the query to return specific results? =dn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

Re: [PHP] fixing mail for broken Outlook

2002-01-16 Thread DL Neil
? There is a difference between *nix, Windows, and Mac with line ends being represented by LF, CRLF, or CR. =Regards, =dn On Wed, Jan 16, 2002 at 04:29:03PM -, DL Neil wrote: Hank, You say just text and text/plain. What do you mean by mungs the formatting? What formatting in plain text? =dn I've

Re: [PHP] mysql_insert_id?

2002-01-16 Thread DL Neil
Jimmy, However it is also possible that in order to save time the LAST_ID information is built into the resultset coming back from the INSERT - thus when mysql_insert_id() is called PHP would not need to go back to MySQL/last_insert_id(). yes, what you said could be true also. Well,

Re: [PHP] mysql_insert_id?

2002-01-15 Thread DL Neil
Hi Wee, Is it possible that I would get the wrong ID (Not the ID I just inserted in Auto_Increment field) by using mysql_insert_id function if someone is also inserting record at the same time? How does mysql_insert_id work accurately? =A couple of things here: 1 if the field is defined as

Re: [PHP] mysql_insert_id?

2002-01-15 Thread DL Neil
Hi Wee, Is it possible that I would get the wrong ID (Not the ID I just inserted in Auto_Increment field) by using mysql_insert_id function if someone is also inserting record at the same time? How does mysql_insert_id work accurately? =A couple of things here: 1 if the field is defined as

Re: [PHP] Time Zone Offset?

2002-01-13 Thread DL Neil
Marvin, I'm using the PHP date() function on my site, but since my hosting company (Pair Networks) is on the East Coast and I'm on the West Coast, everything shows as three hours later (for most of my visitors, anyway). Pair tells me there's no setting I can make on my account to change the

[PHP] Re: [PHP-DB] Re: [PHP] convert yyyy/mm/dd to mm/dd/yyyy, how?

2002-01-13 Thread DL Neil
Rasmus, I have held several datetime-related conversations with people recently, and another series about 'when'/whether to use PHP or MySQL functionality. Here you are, the man of PHP, advising Sander to use MySQL functionality! (and in marked contrast to the (biased) advice one might expect

Re: [PHP] Invalid Email Characters

2002-01-13 Thread DL Neil
Alexis, Could anybody confirm exactly which characters, if any, are NOT valid in an email address. =such rules of the Internet are laid out in documents called RFCs (initially they are Requests for Comment but once adopted become ...) You are looking for RFC822 (although there are others

Re: [PHP] multiple replaces...

2002-01-12 Thread DL Neil
Yes, I thought about that. But, what should I do when the markers are absolutely NOT in any sequence. =sequence would matter if it was possible that one of the markers could replace some text and that replacement subsequently became the marker for a further replacement ... nightmare=recursion!

Re: [PHP] Re: Parsing SAR output with PHP.

2002-01-11 Thread DL Neil
Or checkout the sql import facilities offered by your choice of database to 'convert' the data from log to db-tbl, then set up your analysis in PHP+SQL separately. =dn - Original Message - From: Martin Wickman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 11 January 2002 09:08 Subject:

[PHP] Re: [PHP-DB] Re: [PHP] need help looping through each record with a query -stumped

2002-01-10 Thread DL Neil
Brian, first off, Martin your suggestion looks great but I don't think its SQL syntax is supported by MySQL. It's a good start though - gives me something to work with :) =until it is tried, you won't know! From an SQL point of view it looks ok. In fairness to Martin, from the 'further

Re: [PHP] does this work?

2002-01-10 Thread DL Neil
Erik, Two suggestions: 1 check out mysql_fetch_assoc(), and 2 make use of AS to 'set' the variable names (carried through from MySQL to PHP). Regards, =dn - Original Message - From: Erik Price [EMAIL PROTECTED] To: Rick Emery [EMAIL PROTECTED]; PHP [EMAIL PROTECTED] Sent: 10 January

Re: [PHP] counting with dates (help!)

2002-01-07 Thread DL Neil
RE: [PHP] counting with dates (help!)Hi Sander, (and Chris, and Martin) $today = date(Ymd, mktime(0,0,0, date(m),date(d),date(Y))); $last_week = date(Ymd, mktime(0,0,0, date(m),date(d)-7,date(Y))); echo ($today - $last_week); The result is a number like 8876 (20020107-20011231 = 8876) But

Re: [PHP] configuring sever to send mail (Win2k)

2002-01-04 Thread DL Neil
CJ, i have a problem using the mail function on my server. win2000 Pro IIS 5.0 PHP Version 4.0.6 i'm not sure if it's a configuration problem with IIS or i'm missing something in the php.ini file. The pre-requisite is that the php.ini file points to a visible SMTP server. Please

Re: [PHP] Formats with PHP

2001-12-29 Thread DL Neil
Hey Steve, Im need to generate an email and Im trying to keep the exact spacing I use when I define the body of the email. When the email is sent and i view it with Outlick Express or simply use Pine, the spacing is all out of wack. (Too many spaces here, not enough spaces there) I think

Re: [PHP] how to create html tables in php

2001-12-29 Thread DL Neil
Hi Sander, I made a database with bookmarks, these bookmarks are catogarized by type. Now I want to display those bookmarks in tables by category. This works already fine. The only problem I have is that the tables are very difficult to handle. I want to make 4 tables in a row (so that

Re: [PHP] Weird database stuff.

2001-11-13 Thread DL Neil
Third db question today: do folk know there is a (lightly loaded) '[PHP-DB] list' with some v.competent members? Hi Alexander, - Original Message - Let me start by laying out some facts: SELECT e.NAME AS customer, g.NAME AS driver_lastname, g.FIRSTNAME AS driver_firstname,

Re: [PHP] mail() with mailing lists problem

2001-11-13 Thread DL Neil
Rudolph, Mail() is v.finicky! Windows machines need more than the \n - what are you running? Have you tried putting some string of characters into the (text) msg body? Can you send us a copy of the actual email msg showing the headers etc (output as received at the POP/IMAP server) - after

Re: [PHP] Re: mail() w/ mailing lists

2001-11-12 Thread DL Neil
Is is advisable that I mail lots of users from a database via one call to mail() ? why not make a loop and send to one email at a time. if you have over 1000 I would use something else than mail(), ex direct to smtp with sockets. Henrik, It is my opinion (too?) that mail() is

Re: [PHP] Attachments again

2001-11-12 Thread DL Neil
Hi Sjoerd, When i send a dynamic HTML newletter, which contains newsitems in the database I now send the e-mail with a link to the image on the webserver. What i would like to do is instead of linking the image, send the image as a sort of attachment. So an internetconnection is not

Re: [PHP] Date help (no not that kind)

2001-11-11 Thread DL Neil
Hi Sundog, Can help you with dates (but no, if you want that kind you'll definitely not be wanting my advice...) - Original Message - I am trying to determine if todays date ($today) is within a week ($startcheck) of a given date ($dob). This is what I have so far. $todaydate =

Re: [PHP] Re: Questions about php.ini

2001-11-03 Thread DL Neil
Would the annotated manual LXV. PHP options information be of any use? =dn - Original Message - From: jennyw [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 03 November 2001 03:18 Subject: [PHP] Re: Questions about php.ini This is a dedicated server, and I have several sites on it.

Re: [PHP] Incoming mail to PHP as Apache module

2001-11-03 Thread DL Neil
Maybe I should be posting this on the Procmail list but someone here might have a non-Procmail solution. I'm trying to get a PHP script to process incoming email. The script will lookup a database and do something depending on the mail headers. I'm running on a FreeBSD virtual server account

Re: [PHP] regular expression

2001-11-01 Thread DL Neil
Wow, there are some long and curly ways to use RegExp-s aren't there? I'm not very good at them (and I hear that they can be expensively inefficient) so I tend to look elsewhere. Check out pathinfo -- Returns information about a file path array pathinfo (string path) pathinfo() returns an

[PHP] Re: [PHP-WIN] 4.0.6 mssql.dll Extension load failure

2001-11-01 Thread DL Neil
Mike, We have PHP installed as an ISAP module on our W2K IIS5 server and its operational with no problems - phpinfo() runs just fine. But - When I uncomment the php_mssql.dll extension in php.ini I get an error when PHP starts up saying it cannot find the .dll file. The extension

Re: [PHP] mail() extra headers not working

2001-11-01 Thread DL Neil
I am trying to ad extra headers to email's I am sending through php. I want to ad Reply-To: and Bounse-To: addresses. But when add them useing the forth feild of the mail() funtion. mail($recipient,$msubject,$message,Reply-To: $sender); but for some reason when I send this e-mail it puts

[PHP] Utility script: dates

2001-11-01 Thread DL Neil
Somewhere on my travels around the many PHP/script sites, I'm sure that at one time I noticed a date-display utility. I cannot find it again. Please would someone point the way... What I'm looking for: displays a form with a variety of date/time fields, user enters a date/time into various

Re: [PHP] spliting results into 2 colomns

2001-10-31 Thread DL Neil
I have following code, sorry it's pretty big for posting, i want to split the output into 2 colomns, been trying almost all still can't get it working Harik, First off, have you checked the manual (http://uk.php.net/manual/en/function.mysql-result.php) and the recommendations against the

Re: [PHP] lesson in NOT how to run your php website ...

2001-10-30 Thread DL Neil
I teach law at a university .. I also run the website here ... Thankfully Tasmania is not considered part of Australia. :) *troll bait away* =but are you trolling for bad lawyer jokes to wind up brendan, or inviting the rest to take on the Aussies? =Tasmania advertises itself as the

[PHP] PHP templates vs XML

2001-10-29 Thread DL Neil
In an on-again-off-again desultory style, I keep trying to find the time to study template systems - and quite separately see if I can find a practical use for XML. The idea of a template system is that the HTML code/presentation of the final view to the user/browser, can be devised/maintained

[PHP] Displaying please wait

2001-10-29 Thread DL Neil
Is there someone 'up' on the way Apache works who can offer some comment please? Th how do I display 'please wait' question was asked by someone (else) last week. The standard answer is no - server-side PHP assembles an HTML page, and when it is completed the whole page is transmitted from

Re: [PHP] how to recognize local or server execution?

2001-10-28 Thread DL Neil
John, Netscape! Differences between servers AND differences between browsers AND differences between in-browser and command-line operations! Isn't life fun? Like you I'm messing around with some of these differences as part of a bid to 'convert' an existing set of scripts from browser i/f to

Re: [PHP] HELP: Syntax Needed

2001-10-28 Thread DL Neil
Jokes aside, I still don't get it. =the word it is part of the difficulty everyone faces in thinking about whether they could help or not - what it is, is not apparent 1 there is a problem with a mysql_pconnect() call, and 2 there is a problem with a mysql_query() call. Which one is it? =the

Re: [PHP] switch-statement overrides use of global arrays?

2001-10-28 Thread DL Neil
Imar, The global array is being defined in the mainline, but not populated. What happens if you set element 0 to some value (to take up some storage space first) and then try the switched function calls? When you say Alas, this also emptied the array each time I went from one function to

Re: [PHP] Replace text

2001-10-27 Thread DL Neil
Hello guys function replace_text_smiley(){ global $comment; // To add a relation between a text smiley a an image smiley do this: // $faces[text smiley here] = img tag to image smile here; $faces[:)] = IMG SRC=\emoticons/smile.gif\; $faces[:P] = IMG SRC=\emoticons/tongue.gif\;

Re: [PHP] command line option f -- how do i get the name of the file?

2001-10-27 Thread DL Neil
I am writing a script using php's command line ability and I am lost on how to work with a file when I don't kow what the file's name is. Example: script.php -f file In my script, how do I reference the file when I have no idea what it's name is going to be? The scrip will get

Re: [PHP] PHP File not found

2001-10-26 Thread DL Neil
THanks. Dl Neil [EMAIL PROTECTED] wrote in message 048001c15dab$d5c0fcf0$a516100a@jrbrown">news:048001c15dab$d5c0fcf0$a516100a@jrbrown... I have just set up PHP on my webserver (IIS 4 on NT4). I have set up the script mapping so that I can save php files as .html and php p

Re: [PHP] variable gets lost in function problem again...

2001-10-26 Thread DL Neil
I have an two dimensional array that is returned from code from an included file. I'm assigning parts of the array to variables ( $variable = $array[key][value]; ). This works fine and can be printed until I send it through a function eg. ( ereg_replace( , _, $variable); ). After this,

[PHP] Debugging aids (after the style of: Error management)

2001-10-26 Thread DL Neil
Don't you like the side-benefits of this list, eg that someone comes up with a question that gets your thought processes running or suggests an idea you'd not otherwise come up with!? So further to the question: How can I know the line and the file from where a function has called. I already

Re: [PHP] how to recognize local or server execution?

2001-10-26 Thread DL Neil
Mark, Backing John's question up by one iteration: is there a PHP environment variable which can be used to distinguish between code being run from the command line and code being run in a browser? - and the Million dollar question, sorry make that the M$ question: will it also work under

Re: [PHP] how to recognize local or server execution?

2001-10-26 Thread DL Neil
, this will contain the query string. $argc Contains the number of command line parameters passed to the script (if run on the command line). In case you have any parameter hope this helps... and this should work on windows too. - Original Message - From: DL Neil [EMAIL PROTECTED

Re: [PHP] Re: Loading message

2001-10-25 Thread DL Neil
I suspect that PHP does all of it's work and, only when complete, will it send the generated html to the client. No matter what you try and do there's no way you can output the progress of your script to the browser while it is still being parsed. I could be wrong, but this is my

Re: [PHP] Re: is there a commandline php.exe interpreter?

2001-10-25 Thread DL Neil
John A. Grant [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I've installed ActivePerl, which gives me a way to run .pl files, i.e. : c:\ perl someprogram.pl Does the Win32 php installation give me a command-line interpreter like that? [...]

Re: [PHP] PHP File not found

2001-10-25 Thread DL Neil
I have just set up PHP on my webserver (IIS 4 on NT4). I have set up the script mapping so that I can save php files as .html and php processes them. This works fine until someone goes to a page that doesn't exist - instead of getting the customised error 404 page (i.e. the page you

Re: [PHP] Truncating Lines

2001-10-25 Thread DL Neil
Please define long, and perhaps think of that in the context of the RFC ?822 is it? =dn - Original Message - From: BT News [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 25 October 2001 17:38 Subject: [PHP] Truncating Lines Hi, I have the following code, which reads in an html file

Re: [PHP] Package mechanism

2001-10-24 Thread DL Neil
I have a need for a package mechanism like that provided by TCL. We write a lot of code in reusable libraries and often encounter the situation in which an application uses a particular library but requires at least version X or greater. The require(), require_once(), etc. functionality

Re: [PHP] Package mechanism

2001-10-24 Thread DL Neil
Douw, It's kind of eerie the way your reply appears in my email before I can see my intervening post!!!??? Perhaps you're just more important than me (bow, scrape, simper...) Thanks for the feedback and additional ideas. =HTH I had also though that it might be necessary to separate out the

Re: [PHP] how do i give optional arguments to functions??

2001-10-24 Thread DL Neil
On Wednesday 24 October 2001 19:14, Richard S. Crawford wrote: The default value for $image parameter was missing: function top ($image=defaultvalue) { if ($image==defaultvalue) echo blah blah blah; else echo blah blah $image blah; } If the default value can be

Re: [PHP] mktime() problem

2001-10-23 Thread DL Neil
I'm running 4.0.6 on a Solaris 8 box. The output given by echo mktime(0,0,0,1,1,1970); is 3600. Shouldn't it be 0? My box's locale is set to the UK defaults, so as I write this we are in daylight savings (GMT+1). Would this make a difference? (I have already tried echo

Re: [PHP] mktime() problem

2001-10-23 Thread DL Neil
: DL Neil [mailto:[EMAIL PROTECTED]] Sent: 23 October 2001 13:54 To: Fairbairn,J,James,IVLH4 C; php-general Subject: Re: [PHP] mktime() problem I'm running 4.0.6 on a Solaris 8 box. The output given by echo mktime(0,0,0,1,1,1970); is 3600. Shouldn't it be 0? My box's locale is set

Re: [PHP] str_replace binary safe??

2001-10-22 Thread DL Neil
Hi folks, following problem appeared on PHP 3.0.16 on LINUX I have a binary file, where I want to replace some letters I do the following: $filename = xyz.sdc; $fd = fopen( $filename, r+b ); // also tried r $x=filesize( $filename ); // this shows the correct filesize 22528 byte $contents

Re: [PHP] str_replace binary safe??

2001-10-22 Thread DL Neil
following problem appeared on PHP 3.0.16 on LINUX I have a binary file, where I want to replace some letters I do the following: $filename = xyz.sdc; $fd = fopen( $filename, r+b ); // also tried r $x=filesize( $filename ); // this shows the correct filesize 22528 byte

Re: [PHP] Re: Annotated PHP Manual

2001-10-20 Thread DL Neil
Khalid Hazmi wrote: How I can download the current Annotated PHP Manual??? There is no such thing... AFAIK. = Yasuo Ohgaki Yasuo: Yes there is (and VERY useful it is too), check out the range of PHP documentation available from http://www.php.net/docs.php Khalid: Unlike some other

[PHP] Re: [PHP-DB] variable operators in queries

2001-10-19 Thread DL Neil
Is it possible to put variable operators in queries? =I can see no reason why not - you're not actually putting the 'variable' in the 'query', just using a PHP-variable to build a PHP-string which will be sent to MySQL as a SQL query... I tried this (the real variable comes from a form)

Re: [PHP] Re: executing script at specified time

2001-10-18 Thread DL Neil
The answer cron refers to *nix OpSys. It is the name of a demon/daemon that kicks of commands/jobs at a pre-specified time and/or on a regular basis. M$ spell it at. Was that your question? =dn - Original Message - From: Lucas Chan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 18

Re: [PHP] IMAP Question

2001-10-18 Thread DL Neil
Is it possible to use imap_mail() on php 4.0.6 on NT machine? Maybe anyone has dll for this. Yes Val. It is possible. See related thread/discussion list: [PHP-WIN] Help on using mail() function =dn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED]

Re: [PHP] parsing a string

2001-10-18 Thread DL Neil
John, Two inter-dependent problems: 1 a means of identifying a cipher within the text 2 a means of replacing the cipher with HTML code 1 there are a limited number of graphics formats (.GIF, .JPG, .PNG, etc) and the number you are prepared to contemplate may be even shorter. Thus it would not

[PHP] PHP Filesystem functions/reference table

2001-10-18 Thread DL Neil
Isn't it fun when people asking questions on the list spark off your own thoughts/inspiration!? Has anyone seen a tabulation of the functions in (manual: IV Function Reference XXVI. Filesystem functions) that shows which functions [don't] work under what conditions? eg Col1: function name,

<    1   2   3