[PHP] IE Problems: disappearing text with 'Back' button

2002-11-26 Thread Andre Dubuc
A few people using IE have complained that when they click the 'Back' button to edit their registration form, all info is lost and they're presented with a blank form. I've read archives on this, and I really don't know what to do. The referring page starts with and I know the session variab

Re: [PHP] IE Problems: disappearing text with 'Back' button

2002-11-26 Thread Andre Dubuc
p for you a bit.. > > > > Hope that helps. Good luck. > > -Kevin > > > - Original Message - > From: "Andre Dubuc" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, November 26, 2002 12:29 PM > Subject: [PHP] IE Problem

Re: [PHP] problem with https

2002-11-27 Thread Andre Dubuc
Hi Vivek, If you are accessing https on localhost, you would need to enter: https://localhost/whatever_file You might want to check whether you have https enabled: check phpinfo() under 'Apache Environment'. [HTTPS ] should be "on" as well. hth, Andre On Wednesday 27 November 2002 10:14 am,

Re: [PHP] Problem uploading files other than text/plain ones

2002-12-02 Thread Andre Dubuc
Hi Wilmar, Check whether you have something similar: You'll definetly need that for antything other than text/plain ones.. Here's a some code that works for me (uploading jpgs): if ($_FILES["pix"]["size"] > 0){ if ($_FILES["pix"]["type"] == "image/jpeg"){ $pix_file = $

[PHP] Updating int4 field with multiple values

2002-12-06 Thread Andre Dubuc
I would like to update an int4 column with new values appended to the end (preferably with a delimiter such as @ or a comma). With PostgreSQl 7.2, I can't seem to add the number with a delimiter (it gives me a parser error at the delimiter). For example, If I update the field 'radd' that alrea

Re: [PHP] Updating int4 field with multiple values

2002-12-06 Thread Andre Dubuc
h glitches. An On Friday 06 December 2002 01:39 pm, you wrote: > On Saturday 07 December 2002 00:56, Andre Dubuc wrote: > > I would like to update an int4 column with new values appended to the end > > (preferably with a delimiter such as @ or a comma). > > > > With Po

Re: [PHP] Updating int4 field with multiple values

2002-12-06 Thread Andre Dubuc
de-ja vu (P) Pronunciation Key (du hhh) n . Foreign 1. Something unpleasantly familiar 2. 'Been-there-done-that' Don't you love it when you've set a field to a certain type, only to find out much later, after much coding, it's wrong? Thanks for the reminder. Guess it's back to

[PHP] SELECT with WHILE NOT

2003-01-25 Thread Andre Dubuc
Hi, Using PostgreSql 7.2 + PHP I am trying to do a SELECT that will choose all records except ones that have a certain id number. I can't seem to get the syntax to work. Here's the code: "SELECT * FROM rap WHERE NOT rsponsor = '{$_SESSION['sid']}' ORDER by rsname,rfname,rcountry,rcity DESC

Re: [PHP] SELECT with WHILE NOT

2003-01-25 Thread Andre Dubuc
or NOT IN ('{$_SESSION['sid']}') ORDER by > rsname,rfname,rcountry,rcity DESC LIMIT 20 > > -Original Message- > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 26 January 2003 11:28 AM > To: [EMAIL PROTECTED] > Subject: [PHP] SELECT with W

[PHP] IE 'Back' Button problem + SELECT dropdowns

2003-01-27 Thread Andre Dubuc
Hi, I've managed to get Windows IE to pick up on most of my $_SESSION variables once a user clicks the 'Back' button using the following code in the base form: 'value=' However, when I try this approach for a muliple SELECT dropdown box that is loaded by a 'require' statement, it doesn't pass

Re: [PHP] IE 'Back' Button problem + SELECT dropdowns

2003-01-27 Thread Andre Dubuc
On Monday 27 January 2003 11:46 am, 1LT John W. Holmes wrote: > > I've managed to get Windows IE to pick up on most of my $_SESSION > > variables > > > once a user clicks the 'Back' button using the following code in the base > > form: > > > > 'value= > ?>' > > > > However, when I try this approach

Re: [PHP] IE 'Back' Button problem + SELECT dropdowns

2003-01-27 Thread Andre Dubuc
Thanks John, I sort of thought that it should work. Will do as you suggest. Regards, Andre On Monday 27 January 2003 12:28 pm, John W. Holmes wrote: > > I tried to pick up the values from $_POST (as above). In Linux, it > > works: > > (i.e. I can pick them up, display them, and manipulate them

[PHP] Printing an image - insights needed!

2003-02-10 Thread Andre Dubuc
Hi, I have a very annoying little problem that someone might have an insight as to its cause. The opening page on my site has two small jpeg pixs (3.9KB) that display properly for any user. I have another page, with exactly the same code, and same jpeg pixs that displays properly as well. ";

Re: [PHP] Tryng To Prevent Caching on IE 5-6.0

2003-03-08 Thread Andre Dubuc
Hi Kurst, I don't know whether what I'm about to pass on will be of any help, or close to solving your problem, but perhaps the idea might lead you somewhere. I was faced with a problem: As my index page loaded, I had to test to see whether 'cookies' were enabled, without resorting to javascrip

Re: [PHP] strange behaviour with login page

2003-03-09 Thread Andre Dubuc
Hi Steve, Just out of curiosity, when you mention "implement a user authentication process where users can click on an external link to my site" are you using the https protocol? I had similar bizarre behavior with IE using a "Confirmation Required' script. Worked great at home (localhost), wi

[PHP] Eliminating space between HR and Image

2003-03-19 Thread Andre Dubuc
Hi, I've added an animated gif in the banner area of my site, and just above it, a horizontal rule to give added emphasis. The problem is, no matter what I do, I cannot get rid of an extra space that appears between the two. Is this a natural function? Is there some way of eliminating the space

Re: [PHP] Re: Eliminating space between HR and Image

2003-03-19 Thread Andre Dubuc
; should solve the problem > > like: > > <!-- > hr { > position: absolute; > top: 0px; > } > img { > position: absolute; > top: 8px; > } > --> > > > grace > michiel > > > "Andre Dubuc" <[EMAIL PROTECTED]> wrot

Re: [PHP] Re: Eliminating space between HR and Image

2003-03-19 Thread Andre Dubuc
;!-- > ### hr { > ### position: absolute; > ### top: 0px; > ### } > ### img { > ### position: absolute; > ### top: 8px; > ### } > ### --> > ### > ### > ### grace > ### michiel > ### > ### > ### "Andre Dubuc" <[EMAIL PROTECTED]&

Re: [PHP] Form Validation: Surnames with Apostrophe

2003-03-27 Thread Andre Dubuc
Hi, I made a little function that will allow allow "alphabetical character with apostrophe then more alphabetical characters then hyphen then more alphabetical characters (D'Agostino-Wong)". The downside is that it will automatically cap "von Hollander-Smith" function ucase_words($txt){

[PHP] Sorting db entries by Year-Month

2002-07-23 Thread Andre Dubuc
Apache 1.3.23 + PHP 4.1.2 + PostgreSQl 7.2 I have a guestbook that I would like to display the current month's entries. I can display all the entries before the current month, but i can't seem to figure out how to extract the currrent month's. Although the code below is a db issue, I don't kno

Re: [PHP] Sorting db entries by Year-Month

2002-07-23 Thread Andre Dubuc
rsion of PHP _and_ of Apache??? > > On Tuesday 23 July 2002 16:26 pm, Andre Dubuc wrote: > > Apache 1.3.23 + PHP 4.1.2 + PostgreSQl 7.2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Sorting db entries by Year-Month

2002-07-23 Thread Andre Dubuc
le WHERE MONTH(NOW()) = MONTH(your_column) ?? > > Or if PG stores dates in the Unix timestamp format, is the an equivalent > to date() that you can extract the month from the column and compare > them?? > > ---John Holmes... > > > -Original Message- > > From:

[PHP] RE: Sorting db Entries by Year-Month -- Solved

2002-07-23 Thread Andre Dubuc
Thanks to BigDog and John Holmes for their suggestions. I figured it out: it was rather easy, in hindsight, of course: Works as expected. Regards, Andre -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Sorting db entries by Year-Month

2002-07-23 Thread Andre Dubuc
> > > On Tuesday 23 July 2002 08:47 pm, you wrote: > > > What do you guys think? Should we tell him he's running a vulnerable > > > version of PHP _and_ of Apache??? > > > > > > On Tuesday 23 July 2002 16:26 pm, Andre Dubuc wrote: > > > > Apache 1.3.23 + PHP 4.1.2 + PostgreSQl 7.2 > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Session problem with https

2002-08-03 Thread Andre Dubuc
I've followed the threads on sessions, and discovered, to my horror, that I was passing the session id through cookies. Attempting to repair this 'problem' has been fun (with 200+ files). Somehow, the session variables are not passing through once they encounter an https page. I'm using the fo

[PHP] Session problem with https

2002-08-04 Thread Andre Dubuc
I've followed the threads on sessions, and discovered, to my horror, that I was passing the session id through cookies. Attempting to repair this 'problem' has been fun (with 200+ files). Somehow, the session variables are not passing through once they encounter an https page. I'm using the fo

[PHP] Code for db connection errors

2002-08-15 Thread Andre Dubuc
Suppose, during an attempted connection to a database, an error condition occurs, where the connection cannot be made. Is it advisable for such a message to be displayed to the User, or should such reporting be sent to a log of some sort. (I'm unclear of what use the message would be to the

Re: [PHP] Code for db connection errors

2002-08-15 Thread Andre Dubuc
On Thursday 15 August 2002 10:20 pm, Jason Wong wrote: > It's probably not very user friendly to display the raw error. You could > redirect the user to a generic error page saying something like "The site > is down for maintenance" or whatever. That's what I thought. So with your other idea of

Re: [PHP] Re: Code for db connection errors

2002-08-15 Thread Andre Dubuc
ie (error(0)); > > > function error ($code) { > switch ($code) { > case 0 : reportErrMsg($error[$code]); break; > ... > } > } > ?> > > i think ive would have done something like that... > > but im not the greatest expert on php :) > > regards &

[PHP] NS4.x / IE3.0 Browser Detection

2002-08-20 Thread Andre Dubuc
I need to differentiate between different versions of NS4, particularly the ones that are used by Mac. So far, I've used the following to detect variants: if(eregi("(Mozilla/4.[0-8][0-9])",$_SERVER['HTTP_USER_AGENT'])) However, I'm aware that it will not distinguish between PC and Mac-based NS

Re: [PHP] NS4.x / IE3.0 Browser Detection

2002-08-20 Thread Andre Dubuc
On Tuesday 20 August 2002 10:57 am, Lowell Allen wrote: > > From: Andre Dubuc <[EMAIL PROTECTED]> > > > > I need to differentiate between different versions of NS4, particularly > > the ones that are used by Mac. So far, I've used the following to detect > &g

[PHP] Simple Security Clarification

2002-08-21 Thread Andre Dubuc
In another thread [How do you protect individual files], Justin French stated: "In real short, you want to store the files outside your htdocs root (so they can't be served by http) . . ." My PHP setup serves files from DOCUMENT_ROOT=/var/www/html. If I place files in '/var/www/html/secure' wo

[PHP] Code for off-site Maintenance?

2002-08-21 Thread Andre Dubuc
Soon, I will be transferring my site to go on-line with my IP. Since I've never managed anything off-site, I have a very fundamental question: What are the usual procedures with respect to maintaining a site, that is, accessing the PostgreSQL database for corrections, deletions, etc? One idea

Re: [PHP] Simple Security Clarification

2002-08-21 Thread Andre Dubuc
On Wednesday 21 August 2002 08:15 am, Jay Blanchard wrote: > [snip] > In another thread [How do you protect individual files], Justin French > stated: > > "In real short, you want to store the files outside your htdocs root (so > they > can't be served by http) . . ." > > My PHP setup serves files

Re: [PHP] Code for off-site Maintenance?

2002-08-21 Thread Andre Dubuc
ike to > work on a mirror, test, test, test, upload, test. > > > Justin French > > on 21/08/02 10:11 PM, Andre Dubuc ([EMAIL PROTECTED]) wrote: > > Soon, I will be transferring my site to go on-line with my IP. Since I've > > never managed anything off-site

[PHP] Further Security Clarifications [was: Simple Security Clarifcation]

2002-08-21 Thread Andre Dubuc
My main files are located in /var/www/html (the 'DOCUMENT_ROOT' in Apache, according to php.ini). All sensitive files have been moved to '/var/www/secure', but now I can't access them! (According to php.ini, the PHP core 'doc_root=none'). I'm totally confused. If I understand this correctly, I

Re: [PHP] Further Security Clarifications [was: Simple Security Clarifcation]

2002-08-21 Thread Andre Dubuc
things to check - make sure you're using the full path, ie, > /var/www/secure/filename.php > > How are you including them? I use a > > require("/pathtofile/filename.php"); > > Works for me assuming I have the right permissions. > > Best Regards >

Re: [PHP] Further Security Clarifications [was: Simple Security Clarifcation]

2002-08-21 Thread Andre Dubuc
Thanks again Bob, First off, the site is still being debugged off-line, and part of the problem, as you suggested is my confusion over UNIX SERVER and the Apache Server. OK. Got that. What I'm trying to do: Any file that utilizes $_SESSION variables accessed through username/password validat

[PHP] Apostrophe in preg_match?

2002-08-27 Thread Andre Dubuc
I'm trying to get an apostrophe (and a dash, as well) to be included in a preg_match expression, but I don't know how to escape the characters. Numbers and special characters not allowed in 'Surname' Click 'Back' on your browser to re-enter information."); ?> Any help will be greatly appreci

Re: [PHP] Apostrophe in preg_match?

2002-08-28 Thread Andre Dubuc
Thanks DL, I've read that part of the manual. My original syntax was as you suggested [^a-zA-Z-'], but the PostgreSQl query barfed on the apostrophe. The preg_match works, but the db refuses to accept the apostrophe. Reading the postgresql docs, they suggest escaping the character, but since t

[PHP] Mail/Confirmation Script delivery problems

2002-08-30 Thread Andre Dubuc
After resolving other script problems, a new one has surfaced. The 'Guest Registration/Confirmation' script works as expected. It inserts a random id number, then fowards it to the guest's email address, and awaits confirmation (by clicking on the Confirmation URL). Postfix says that the mail

Re: [PHP] Mail/Confirmation Script delivery problems

2002-08-30 Thread Andre Dubuc
On Friday 30 August 2002 03:38 pm, you wrote: > On Saturday 31 August 2002 03:25, Andre Dubuc wrote: > > But checking the mailbox of '[EMAIL PROTECTED]' (and three others that > > I've sent it to) nothing shows up. Now, what's strange, it used to work > >

Re: [PHP] Mail/Confirmation Script delivery problems

2002-08-30 Thread Andre Dubuc
On Friday 30 August 2002 03:57 pm, you wrote: > On Saturday 31 August 2002 03:52, Andre Dubuc wrote: > > > What 'minor' changes did you make to $message? Does rolling back those > > > changes make it work again? > > > > I had just added another t

Re: [PHP] image manipulation

2002-09-01 Thread Andre Dubuc
Hi tux, For your second question, try: http://www.linuxfocus.org/English/July2001/article211.shtml It'll give some basci info on image manipulation using ImageMagick. Hth, Andre On Sunday 01 September 2002 01:19 pm, tux wrote: > Hey all, > > I was just wondering if anyone could recommend an

[PHP] Downloading php4.2.2.zip??

2002-09-03 Thread Andre Dubuc
I'm wonder whether I doing something wrong. I've tried, without any success, to d/l php 4.2.2.zip from all the US mirrors, the Canadian ones, Ireland, Australia, and even the main php.net site. I get as far as get_download . . . and nothing happens. Is there ftp access to get this file, o

[PHP] Re: Mail/Confirmation Script delivery problems

2002-09-03 Thread Andre Dubuc
Hi Richard, Thank you for continuing to research this problem. Just before the weekend, I talked to my IP about the problem I was having. He thought it was strange: suggested I look at my browser settings to see what was being passed. To make a long story short, he mentioned that with 'mailt

[PHP] SELECT dropdown from a db query?

2002-09-18 Thread Andre Dubuc
I'm trying to generate a dropdown SELECT list from a database query. So far, all I've managed to create is multiple one-item dropdowns for each database entry spread across the page. Bad -- very bad! I'd like normal drop-down SELECT behavior, but somehow the code escapes me. I've tried a bu

Re: [PHP] SELECT dropdown from a db query?

2002-09-18 Thread Andre Dubuc
: > Change to > > Sascha > > Am Donnerstag, 19. September 2002 03:34 schrieb Andre Dubuc: > > I'm trying to generate a dropdown SELECT list from a database query. So > > far, all I've managed to create is multiple one-item dropdowns for each > > d

Re: [PHP] SELECT dropdown from a db query?

2002-09-18 Thread Andre Dubuc
Thanks Jacob and Sascha, I would've struggled with that one for a day before I realized what was wrong. Thanks again -- it works great! Regards (and thanks yet again :>) Andre On Wednesday 18 September 2002 09:54 pm, Jacob Miller wrote: > Move outside the do-while loop: > > print ""; > > $ro

[PHP] Non-functioning db 'include'

2002-09-23 Thread Andre Dubuc
I've streamlined all files by using an include for db access. Everything works except the main registration file which is set to https. When I 'include' a file, the db access doesn't work: all other input that accesses the db does, except for one that first calls a 'randomizer' function, then

Re: [PHP] Non-functioning db 'include'

2002-09-23 Thread Andre Dubuc
u need to include using the full > http://www.yoursite.com/yourinclude.inc syntax or throw another copy of > your include db file in your directory for secure serving > > Not sure if this is what you are referring to but hope it helps > > On Mon, 2002-09-23 at 09:15, Andre Dubuc wrote: > &g

[PHP] $_SESSION[] and register_globals=on

2002-09-27 Thread Andre Dubuc
A short question: My IP informed me that they have register_globals=on in their php.ini. Is this going to cause problems with my scripts that were written using $_POST, $_SESSION, etc? Tia, Andre -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/uns

Re: [PHP] $_SESSION[] and register_globals=on

2002-09-27 Thread Andre Dubuc
Thanks John, I had been debating which IP Iwould use for my site. With the information you've provided, I will use the one that has register_globals=off. One re-write of all my code is enough. Besides, the purpose of the default 'off' behavior is precisely why I'm using $_SESSION's anyway.

[PHP] Htmlentities and Newlines?

2002-09-28 Thread Andre Dubuc
Perhaps I don't understand the use of 'htmlentities' too well, but I would like newlines to be retained/inserted into a db, and then if displayed, to produce a new line from a textarea. However, I want the possibility of dangerous html excluded (hence the use of 'htmlentities'). Is there some

Re: [PHP] Htmlentities and Newlines?

2002-09-28 Thread Andre Dubuc
On Saturday 28 September 2002 03:30 pm, John W. Holmes wrote: > > Perhaps I don't understand the use of 'htmlentities' too well, but I > > would > > > like newlines to be retained/inserted into a db, and then if > > displayed, to > > > produce a new line from a textarea. However, I want the possib

Re: [PHP] Htmlentities and Newlines?

2002-09-28 Thread Andre Dubuc
l show up in the textarea the same way > the user typed it. No having to explain what the are or where the > extra stuff came from. > > Then, to show a preview or whatever to the user, use > nl2br(htmlentities($text)) to send it to the browser. > > ---John Holmes... > &g

Re: [PHP] Htmlentities and Newlines?

2002-09-28 Thread Andre Dubuc
On Saturday 28 September 2002 07:55 pm, John W. Holmes wrote: > > Sorry about the ambiguity. What I'm trying to accomplish is close to > > what > > > you > > describe. However, before anything goes into the db (ie html chars, > > bad > > > commands, or anything from Mr.Hacker), I verify it. Someon

Re: [PHP] Htmlentities and Newlines?

2002-09-28 Thread Andre Dubuc
On Saturday 28 September 2002 08:19 pm, Sascha Cunz wrote: > > Hi John, > > > > Sorry about the ambiguity. What I'm trying to accomplish is close to what > > you describe. However, before anything goes into the db (ie html chars, > > bad commands, or anything from Mr.Hacker), I verify it. Someone

Re: [PHP] Htmlentities and Newlines?

2002-09-28 Thread Andre Dubuc
On Saturday 28 September 2002 08:32 pm, John W. Holmes wrote: > > -Original Message- > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, September 28, 2002 8:34 PM > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: Re: [PHP] Htmlent

Re: [PHP] Htmlentities and Newlines?

2002-09-28 Thread Andre Dubuc
On Saturday 28 September 2002 08:42 pm, John W. Holmes wrote: > > Short question: following your advice, what would the data look like > > in > > > the > > db if I typed in: > > > > Hi Sascha. > > Next line is doubled. > > > > Double. > > > > How would that appear iun the db? In mine,

Re: [PHP] Htmlentities and Newlines?

2002-09-28 Thread Andre Dubuc
On Saturday 28 September 2002 08:59 pm, John W. Holmes wrote: > > -Original Message- > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, September 28, 2002 9:00 PM > > To: [EMAIL PROTECTED]; 'Sascha Cunz'; [EMAIL PROTECTED] > > Subj

Re: [PHP] Htmlentities and Newlines?

2002-09-28 Thread Andre Dubuc
On Saturday 28 September 2002 09:13 pm, John W. Holmes wrote: > > -Original Message- > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, September 28, 2002 9:14 PM > > To: [EMAIL PROTECTED]; 'Sascha Cunz'; [EMAIL PROTECTED] > > Subj

[PHP] Using PHP to create tables?

2002-10-02 Thread Andre Dubuc
In order to get my site on-line, I need to upload all my files, and create a few PostgreSQL tables that the scripts rely upon. I've created a script that should create these tables, but in testing it, nothing happens - no tables are created. I wondering whether it's even possible to create the

Re: [PHP] Using PHP to create tables?

2002-10-02 Thread Andre Dubuc
are coding with it, I guess you should be able to > figure out the correct command > > Andrew > - Original Message - > From: "Andre Dubuc" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, October 02, 2002 2:44 PM > Subject: [PHP] Usi

[PHP] Getting the "From: admin@site.com" to work

2002-10-26 Thread Andre Dubuc
Perhaps some kind guru can spare me some time. I've tried to get the "From: " field pre-filled for a registration/confirmation email that I send out. I've managed to get the "To: ' field working great, but no matter where I stick the 'From:' code, it doesn't send the email. Any ideas what I'

Re: [PHP] Getting the "From: admin@site.com" to work

2002-10-26 Thread Andre Dubuc
Thanks John, I had the maual in front of me, but I didn't understand that you had to put the 'From:' stuff in a 'header'. That's why it wasn't working. I presumed (wrongly again) that 'headers' were optional, and I got sidetracked by the success of the "To:" field. Thanks for clearing that up.

[PHP] File Upload - Dwindling connection

2002-10-30 Thread Andre Dubuc
I'm having big problems with uploading jpeg pictures from a calling form. What happens is that the htpps connection begins (usaully at a very low transfer rate -- somewhere around 900 b/s, and then dwindles rapidly to 200 - 20 -10 b/s). The file doesn't appear in the upload or temp directory (fi

[PHP] Viewing jpegs problem

2002-11-08 Thread Andre Dubuc
While testing my site with various browsers, I've run into a viewing problem in IE6 and Mac/IE5.1. In IE6, all I see is a line (which would be the base of the picture), while in Mac/IE the output is 1" wide x 4" high and highly distorted. (that's why I set height to 'auto' - to allow for varyi

[PHP] Errant include file works everywhere but here

2002-11-09 Thread Andre Dubuc
I've run into a problem with an include file that I can't figure out why it's happening. Certain text files on my site are rather long. Originally, when these pages loaded, the menu structure would load first, followed by the text in a box to the right of the Menu. However, the long text fil

[PHP] Modifying the sort order of a query

2002-06-05 Thread Andre Dubuc
Apache 1.3.23 + PHP 4.1.2 + PostgreSQL 7.2 I have a query that sorts by name, country, and city, then pages in groups of 30 records. Originally, I had also coded two buttons: "Sort by Country', 'Sort by City' since I wanted to offer users the options of these choices. Unfortunately, these butt

Re: [PHP] Modifying the sort order of a query

2002-06-05 Thread Andre Dubuc
think that's what he > > was after. Just my 2c. > > > > Bogdan > > > > Miguel Cruz wrote: > > >Try a sub-select: > > > > > >SELECT * FROM (SELECT * FROM rap ORDER BY rcountry,rcity,rsname,rfname > > >DESC LIMIT 30 OFFSET 30) ORDER BY

Re: [PHP] Modifying the sort order of a query

2002-06-05 Thread Andre Dubuc
ect the results which are then sorted... I don't think that's > > what he > > > > was after. Just my 2c. > > > > > > Bogdan > > > > > > Miguel Cruz wrote: > > > >Try a sub-select: > > > > > > > >SELECT

Re: [PHP] Modifying the sort order of a query

2002-06-05 Thread Andre Dubuc
aintain the same 30 results in the new result set, like my previous > email mentioned... > > ---John Holmes... > > > -Original Message- > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 05, 2002 10:19 PM > > To: Miguel Cruz > > Cc

Re: [PHP] Modifying the sort order of a query

2002-06-05 Thread Andre Dubuc
> > Example page will really help here; maybe I'm just slow in visualizing > this. We can take this off the list if necessary, too. > > ---John Holmes... > > > -Original Message- > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday,

Re: [PHP] Modifying the sort order of a query

2002-06-05 Thread Andre Dubuc
all the pages... so that all pages know about but not always use > the queries ... so that you can have it sorted by any and everything you > want... > > > any way just a thought > > > cheers > Peter > > -Original Message- > From: Andre Dubuc [mailt

Re: [PHP] Modifying the sort order of a query

2002-06-06 Thread Andre Dubuc
Thanks Jay, Well, I went back to work on it, and with the combined suggestions from the list, it's working now. I just had to insert the sub-select on the called page as well. That seemed to be the problem. Thanks for your suggestion -- I used part of it. Regards, Andre On Thursday 06 June 2

Re: [PHP] How can i resize images after upload?

2002-06-06 Thread Andre Dubuc
Hi Ragnar, I had the same problem whenI wanted to display an uploaded image file. Unfortunately, Imagemagick isn't pre-compiled with Linux-Mandrake 8.2 distro. So I couldn't do it the usual way. However, I solved it in a very easy way. Since the file was referenced in my db, and the actual fil

[PHP] Switching from HTTPS to HTTP using PHP?

2002-06-10 Thread Andre Dubuc
After completing most of the coding for my site, I would like to use "https" for restricted areas that require login. In short tests, I've discovered that, yes, I can engage the encrypted mode while calling these pages, but I've also discovered that it stays in the "https" mode even when it pas

Re: [PHP] Switching from HTTPS to HTTP using PHP?

2002-06-10 Thread Andre Dubuc
https would be in it.) Sigh . . . more reading to do :> Regards, Andre On Monday 10 June 2002 02:28 pm, you wrote: > Isn't it just an issue of whether you call http: or https: ? > > -Original Message- > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > Sent: Monday,

Re: [PHP] Switching from HTTPS to HTTP using PHP?

2002-06-10 Thread Andre Dubuc
Thanks Ed, As you mentioned in your last lines, I'll have to specify the http protocol for the ordinary pages -- I hadn't done that yet. I assumed it would default to http; but, if I had thought about it, that wouldn't make sense. Unless told otherwise, https would not "know" that another prot

[PHP] Extracting from an Array

2002-06-12 Thread Andre Dubuc
I have a db field, type varchar, that is actually a 'date' string formatted as dd-mm-. I used type 'varchar' (rather than type 'date') since I had to accomplish other things with it. Now, however, I do need to extract the Year (the last four digits in the array). I've tried to access the a

Re: [PHP] Extracting from an Array

2002-06-12 Thread Andre Dubuc
gt; $sql = "select fieldname from tablename"; > $Results = mysql_query($sql, $DBLink); > $Row = mysql_fetch_array($Results); > $fieldname = $Row["fieldname"]; > $Date = explode("-", $fieldname); > $Year = $Date[2]; > > > -Original Message

Re: [PHP] Extracting from an Array

2002-06-12 Thread Andre Dubuc
or MySQL? Do you realize you can use > DATE_FORMAT() in your query to re-format the date back to dd-mm- if > you want to? Do you realize that if you ever wanted to sort by this > column, you'd be all messed up? It'll sort as a string, where "10" is > less than &quo

Re: [PHP] Extracting from an Array

2002-06-12 Thread Andre Dubuc
]; > } > ?> > > You know you could write a simple little script to convert this into the > correct format for a date column. > > If you want to do sorting by year, you can try this: > > SELECT date_column FROM table ORDER BY RIGHT(date_column,4) ASC > > ---John Ho

Re: [PHP] Extracting from an Array

2002-06-14 Thread Andre Dubuc
h your code. What value does $rexpiry have? What do you see > when you do print_r($Date) ?? Troubleshoot... > > ---John Holmes... > > > -Original Message----- > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 12, 2002 10:36 PM > > To:

Re: [PHP] Checking for NULL value in Database

2002-06-18 Thread Andre Dubuc
g for me do to a 'vacuum' of the db. Once I cleaned up the database, everything worked as expected. I guess I should vacuum more frequently? Btw, you wouldn't happen to know any 'timer' script that I can program for seconds? Regards, Andre On Tuesday 18 June 2002 03:5

[PHP] Limiting text inputs by character count?

2002-06-23 Thread Andre Dubuc
Is there a way to limit the number of characters that may be inputed into: a) a input b) a input I would like to control the maximum number of characters for each of these inputs. Any suggestions of where to look, or how to do it, if it's possible, would be greatly appreciate

Re: [PHP] Limiting text inputs by character count?

2002-06-23 Thread Andre Dubuc
Thanks Peter, That'll fix it. Regards, Andre On Sunday 23 June 2002 10:04 pm, you wrote: > for standard text input use > > that will > only allow 10 characters > > not sure if that will also work for text area's > > -Original Message- > From:

[PHP] Word Count function?

2002-06-24 Thread Andre Dubuc
Is there a function that counts the number of words in a string? I checked through the manual and archives using 'word count', and found nothing. I suppose it is possible to generate code that will accomplish this, using 'space' as the delimiting separator. But before I re-invent the wheel .

Re: [PHP] Word Count function?

2002-06-24 Thread Andre Dubuc
Thanks Dan, Does the job neatly! Regards, Andre On Monday 24 June 2002 06:01 pm, you wrote: > Andre: > > On Mon, Jun 24, 2002 at 05:29:16PM -0400, Andre Dubuc wrote: > > Is there a function that counts the number of words in a string? > > I don't recall there bei

Re: [PHP] ./configure with register_globals turned on?

2002-07-05 Thread Andre Dubuc
Hi Scott, I've come to this post a little late, but I had exactly the same problem. No matter what I set php.ini, phpinfo() would not show changes. If I recall correctly, the problem sort of 'disappeared' by itself. I finally resolved it by rebooting immediately after setting the new php.ini (

[PHP] How to set focus in a form field

2002-07-11 Thread Andre Dubuc
I have an annoying 'glitch' in the forms on my site: When a page loads, if it has a form on it, I would like the cursor to move to the first field, be 'set' - that is, I should see a cursor or blinking cursor in the first field. As it is now, on some pages, I either have to 'tab' to the first

Re: [PHP] How to set focus in a form field

2002-07-11 Thread Andre Dubuc
dre > > -Original Message- > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 11:26 AM > To: [EMAIL PROTECTED] > Subject: [PHP] How to set focus in a form field > > > I have an annoying 'glitch' in the forms on my site: >

Re: [PHP] Strong Web Hosts in Canada?

2002-07-17 Thread Andre Dubuc
Hi Dan, Try http://www.hub.org. Hth, Andre On Wednesday 17 July 2002 02:23 am, you wrote: > Hi Folks: > > A client of mine has a large series of high traffic, PHP/MySQL intensive > websites. They're looking for dedicated hosting in Canada. Any > recommendations? > > Enjoy, > > --Dan -- PHP

Re: [PHP] Loading a File into Variable - How??

2002-07-18 Thread Andre Dubuc
Hi Monty, I've been trying to do the same thing with no success. Would you be so kind as to show me how you finally did it? I'm not too clear what you meant by: "So, if I replace the filesize($filename) command with a hard-coded number, it works." Tia, Andre On Thursday 18 July 2002 04:28 pm

[PHP] Limiting repetitive file access

2003-11-15 Thread Andre Dubuc
Hi, Recently, a 'user' attempted to access a restricted area of my site repetitively (spanning five hours) entering the same url repetitively [probably by script]. A massive log file was generated. I would like to ban such behavior by limiting the number of successive 'get's a user can do (say

Re: [PHP] Re: Limiting repetitive file access

2003-11-16 Thread Andre Dubuc
On Sunday 16 November 2003 06:40 am, Manuel Lemos wrote: > Hello, > > On 11/16/2003 02:52 AM, Andre Dubuc wrote: > > Recently, a 'user' attempted to access a restricted area of my site > > repetitively (spanning five hours) entering the same url repetitively >

Re: [PHP] Sessions and AOL?

2003-11-16 Thread Andre Dubuc
On Sunday 16 November 2003 01:54 pm, R. Van Tassel wrote: > Hi everyone. I have a problem with a website that I don't understand. It > seems that people using AOL can't see certain sections of this website. > > It is a directory section where a drop-down menu exists, you select the > section you wa

Re: [PHP] Limiting repetitive file access

2003-11-16 Thread Andre Dubuc
On Sunday 16 November 2003 10:45 pm, David Otton wrote: > On Sat, 15 Nov 2003 23:52:31 -0500, you wrote: > >Recently, a 'user' attempted to access a restricted area of my site > >repetitively (spanning five hours) entering the same url repetitively > >[probably by script]. A massive log file was ge

[PHP] Tabs + SELECTED

2002-04-18 Thread Andre Dubuc
An interesting problem has surfaced while finishing the coding for an input form. The usual text inputs fields are in place for first name, surname, address etc. However, I've created a drop-down list for state and country. Since these drop-down lists have " In USA/Canada ", tabbing in the for

  1   2   3   >