[PHP] Ok then, here is a test

2012-10-13 Thread Jim Lucas
On 10/12/2012 11:42 AM, Daniel Brown wrote: Well, as the adage goes, you'll catch more flies with honey than with vinegar. And considering this is the very first message I've ever seen from you, it sounds like either (a) you didn't follow the proper protocol, or (b) there's something in the

Re: [PHP] Ok then, here is a test

2012-10-13 Thread Jim Lucas
On 10/13/2012 10:42 PM, Jim Lucas wrote: On 10/12/2012 11:42 AM, Daniel Brown wrote: Well, as the adage goes, you'll catch more flies with honey than with vinegar. And considering this is the very first message I've ever seen from you, it sounds like either (a) you didn't follow the

[PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread clive
I have no clue how big the files are, but you might want to store them in a database. That can speed up things, but don't ask me how much ;) Tijnema no dude, while database are convenient, files systems are faster, I mean thats what they were designed for, serving files. For lots of files I

[PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread Colin Guthrie
clive wrote: I have no clue how big the files are, but you might want to store them in a database. That can speed up things, but don't ask me how much ;) Tijnema no dude, while database are convenient, files systems are faster, I mean thats what they were designed for, serving files.

Re: [PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread Daniel Brown
On 6/18/07, Colin Guthrie [EMAIL PROTECTED] wrote: clive wrote: I have no clue how big the files are, but you might want to store them in a database. That can speed up things, but don't ask me how much ;) Tijnema no dude, while database are convenient, files systems are faster, I mean

Re: [PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread Tijnema
On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Colin Guthrie [EMAIL PROTECTED] wrote: clive wrote: I have no clue how big the files are, but you might want to store them in a database. That can speed up things, but don't ask me how much ;) Tijnema no dude, while

Re: [PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread Daniel Brown
On 6/18/07, Tijnema [EMAIL PROTECTED] wrote: On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Colin Guthrie [EMAIL PROTECTED] wrote: clive wrote: I have no clue how big the files are, but you might want to store them in a database. That can speed up things, but don't ask

Re: [PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread Tijnema
On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Tijnema [EMAIL PROTECTED] wrote: On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Colin Guthrie [EMAIL PROTECTED] wrote: clive wrote: I have no clue how big the files are, but you might want to store them

Re: [PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread Daniel Brown
On 6/18/07, Tijnema [EMAIL PROTECTED] wrote: On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Tijnema [EMAIL PROTECTED] wrote: On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Colin Guthrie [EMAIL PROTECTED] wrote: clive wrote: I have no clue how big

Re: [PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread Robert Cummings
On Mon, 2007-06-18 at 11:25 -0400, Daniel Brown wrote: On 6/18/07, Tijnema [EMAIL PROTECTED] wrote: On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: Referring to one of my earlier posts in this thread, as a refresher, database information is stored in files. So to store files

Re: [PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread Jim Lucas
Daniel Brown wrote: On 6/18/07, Tijnema [EMAIL PROTECTED] wrote: On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Tijnema [EMAIL PROTECTED] wrote: On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Colin Guthrie [EMAIL PROTECTED] wrote: clive wrote: I

Re: [PHP] Re: [BULK] Re: [PHP] OK to have many files in one folder?

2007-06-18 Thread Robert Cummings
On Mon, 2007-06-18 at 08:41 -0700, Jim Lucas wrote: Daniel Brown wrote: On 6/18/07, Tijnema [EMAIL PROTECTED] wrote: On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Tijnema [EMAIL PROTECTED] wrote: On 6/18/07, Daniel Brown [EMAIL PROTECTED] wrote: On 6/18/07, Colin

Re: [PHP] OK to have many files in one folder?

2007-06-17 Thread Brian Dunning
For everyone who advised me to beware the inode, allow me to forward what the Rackspace admins told me. This is Greek to me, and I'm hoping one of you can translate. All I understood was where he said I appear to have more than enough. Yes? ---snip--- All of your slices on the disk are

Re: [PHP] OK to have many files in one folder?

2007-06-17 Thread Tijnema
On 6/17/07, Brian Dunning [EMAIL PROTECTED] wrote: For everyone who advised me to beware the inode, allow me to forward what the Rackspace admins told me. This is Greek to me, and I'm hoping one of you can translate. All I understood was where he said I appear to have more than enough. Yes?

[PHP] OK to have many files in one folder?

2007-06-15 Thread Brian Dunning
Server is running Linux, and PHP is constantly creating and modifying images in a directory. Apache is constantly serving these same images. There are about 250,000 of them in the same directory. Seems to be running OK, no problematic CPU load, but I'm wondering if anyone knows whether I'm

RE: [PHP] OK to have many files in one folder?

2007-06-15 Thread Jay Blanchard
[snip] Server is running Linux, and PHP is constantly creating and modifying images in a directory. Apache is constantly serving these same images. There are about 250,000 of them in the same directory. Seems to be running OK, no problematic CPU load, but I'm wondering if anyone knows

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Daniel Brown
6/15/07, Jay Blanchard [EMAIL PROTECTED] wrote: [snip] Server is running Linux, and PHP is constantly creating and modifying images in a directory. Apache is constantly serving these same images. There are about 250,000 of them in the same directory. Seems to be running OK, no problematic CPU

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Crayon Shin Chan
On Saturday 16 June 2007 02:51, Daniel Brown wrote: And remember, the fact that they're all in one directory doesn't matter at all to the system, as directories, folders, et cetera, are just representations for human readability and organization. In fact, those files reside on several

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Brian Dunning
Thanks for the replies but I'm not sure I know what to do with them. Is the problem with the number of files, or is the problem with the activity? Can you dumb down your answers at all for me? :) On Jun 15, 2007, at 11:51 AM, Daniel Brown wrote: 6/15/07, Jay Blanchard [EMAIL PROTECTED]

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Daniel Brown
On 6/15/07, Crayon Shin Chan [EMAIL PROTECTED] wrote: On Saturday 16 June 2007 02:51, Daniel Brown wrote: And remember, the fact that they're all in one directory doesn't matter at all to the system, as directories, folders, et cetera, are just representations for human readability and

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Brian Dunning
I can easily break it up into 100 subdirectories, 2500 files in each, would that be good insurance against problems? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] OK to have many files in one folder?

2007-06-15 Thread Jay Blanchard
[snip] I can easily break it up into 100 subdirectories, 2500 files in each, would that be good insurance against problems? [/snip] As someone mentioned, directories are just a human convenience. Each file will have an inode and is identified by an inode number in the file system where it

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Tijnema
On 6/15/07, Brian Dunning [EMAIL PROTECTED] wrote: I can easily break it up into 100 subdirectories, 2500 files in each, would that be good insurance against problems? I have no clue how big the files are, but you might want to store them in a database. That can speed up things, but don't ask

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Daniel Brown
On 6/15/07, Brian Dunning [EMAIL PROTECTED] wrote: Thanks for the replies but I'm not sure I know what to do with them. Is the problem with the number of files, or is the problem with the activity? Can you dumb down your answers at all for me? :) On Jun 15, 2007, at 11:51 AM, Daniel Brown

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Daniel Brown
On 6/15/07, Jay Blanchard [EMAIL PROTECTED] wrote: [snip] I can easily break it up into 100 subdirectories, 2500 files in each, would that be good insurance against problems? [/snip] As someone mentioned, directories are just a human convenience. Each file will have an inode and is identified

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Satyam
] To: php-general@lists.php.net Sent: Friday, June 15, 2007 9:38 PM Subject: Re: [PHP] OK to have many files in one folder? Thanks for the replies but I'm not sure I know what to do with them. Is the problem with the number of files, or is the problem with the activity? Can you dumb down your

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Crayon Shin Chan
On Saturday 16 June 2007 03:47, Daniel Brown wrote: Once again, this doesn't matter so much for per-directory (though listing will take longer, as I think I mentioned) as it does the filesystem mount. Several years ago, having say 3000+ files in single directory on ext2 would mean that

Re: [PHP] OK to have many files in one folder?

2007-06-15 Thread Stut
Jay Blanchard wrote: [snip] Server is running Linux, and PHP is constantly creating and modifying images in a directory. Apache is constantly serving these same images. There are about 250,000 of them in the same directory. Seems to be running OK, no problematic CPU load, but I'm wondering

RE: [PHP] OK to have many files in one folder?

2007-06-15 Thread Jay Blanchard
[snip] Two words. Beware the inode. ^^ ^^^ ^ 1 23 Here endeth the lesson. [/snip] Can I get an Admin brotha'!? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Ok next php problem

2006-06-18 Thread Rob W.
I got the previous question answered, Now here's my next problem. With the numbers displaying correctly again I got: 1 2 3 4 5 6 7 10 11 12 13 14 15 16 17 18 19 20 21 22 25 listed in that order in the database Now i'm trying to figure out how to write a syntax saying that if like number 8

Re: [PHP] Ok next php problem

2006-06-18 Thread Chris
Rob W. wrote: I got the previous question answered, Now here's my next problem. With the numbers displaying correctly again I got: 1 2 3 4 5 6 7 10 11 12 13 14 15 16 17 18 19 20 21 22 25 listed in that order in the database Now i'm trying to figure out how to write a syntax saying that if

Re: [PHP] Ok next php problem

2006-06-18 Thread Rob W.
they are not scripted statically. - Original Message - From: Chris [EMAIL PROTECTED] To: Rob W. [EMAIL PROTECTED] Cc: php-general@lists.php.net Sent: Sunday, June 18, 2006 8:38 PM Subject: Re: [PHP] Ok next php problem Rob W. wrote: I got the previous question answered, Now here's

Re: [PHP] Ok next php problem

2006-06-18 Thread tedd
At 7:21 PM -0500 6/18/06, Rob W. wrote: I got the previous question answered, Now here's my next problem. With the numbers displaying correctly again I got: 1 2 3 4 5 6 7 10 11 12 13 14 15 16 17 18 19 20 21 22 25 listed in that order in the database Now i'm trying to figure out how to write a

Re: [PHP] Ok next php problem

2006-06-18 Thread Chris
Rob W. wrote: Ok but my problem is is that in the process of doing that, numbers can be released so they pretty much haft to be dynamic. Any idea how I do it with that. IE: 1 2 3 6 9 10 ... So if them numbers change, which they can, because they are assigned port numbers for servers, How

Re: [PHP] GD text proc via php OK for local strings, but NOT for SESSION-passed strings. why?

2006-04-29 Thread Richard Lynch
On Fri, April 28, 2006 4:54 pm, OpenMacNews wrote: -BEGIN PGP SIGNED MESSAGE- in a given php file, this returns an image as expected: ... $word=blah; imagefttext($im, ... other params ... , $word); ... header (Content-type: image/png);

[PHP] GD text proc via php OK for local strings, but NOT for SESSION-passed strings. why?

2006-04-28 Thread OpenMacNews
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 hi all, php-5.1.2 built from src on OSX 10.4.6. GD-2.0.33 + libpng-1.2.10 are built/enabled. GD is working fine ... locally. in a given php file, this returns an image as expected: ... $word=blah; imagefttext($im,

Re: [PHP] Ok, why is this happening...

2005-07-22 Thread Richard Lynch
On Tue, July 19, 2005 10:26 am, John Nichel said: There's some freaky math going on there or something. I added a couple of other echos in to see and for some reason it seems to be losing single digit value (subtracting, rounding down, I don't know). $calculatedGross = $originalNet + (

[PHP] Ok, why is this happening...

2005-07-19 Thread Chris Boget
Consider the following test script: script language=php set_time_limit( 0 ); echo 'html'; echo 'headtitleTest Rounding Net Premium/title/head'; echo 'body'; echo 'Running test...br'; flush(); echo 'table'; echo 'tr'; echo 'tdOriginal Net/td'; echo 'tdCommission %/td';

Re: [PHP] Ok, why is this happening...

2005-07-19 Thread John Nichel
Chris Boget wrote: snip echo if( $originalNet != $calculatedNet ) = . ( (int)$originalNet !== (int)$calculatedNet ) . br\n; /snip Change this to echo out what you're comparing... echo if( . (int)$originalNet . != . (int)$calculatedNet . ) = . ( (int)$originalNet !== (int)$calculatedNet ) .

Re: [PHP] Ok, why is this happening...

2005-07-19 Thread Chris Boget
Chris Boget wrote: snip echo if( $originalNet != $calculatedNet ) = . ( (int)$originalNet !== (int)$calculatedNet ) . br\n; /snip Change this to echo out what you're comparing... echo if( . (int)$originalNet . != . (int)$calculatedNet . ) = . ( (int)$originalNet !== (int)$calculatedNet

Re: [PHP] Ok, why is this happening...

2005-07-19 Thread John Nichel
Chris Boget wrote: Chris Boget wrote: snip echo if( $originalNet != $calculatedNet ) = . ( (int)$originalNet !== (int)$calculatedNet ) . br\n; /snip Change this to echo out what you're comparing... echo if( . (int)$originalNet . != . (int)$calculatedNet . ) = . ( (int)$originalNet !==

Re: [PHP] Ok, why is this happening...

2005-07-19 Thread Andy Pieters
Hi I admit not gone trough all of your code, but mostly this happens when mixing the string concatenation operator (.) with the addition (+) or substraction (-) operator. HTH With kind regards Andy On Tuesday 19 July 2005 19:26, John Nichel wrote: Chris Boget wrote: Chris Boget wrote:

RE: [PHP] OK ... WHY does this work ?????

2004-09-15 Thread Gryffyn, Trevor
Read over some of the examples at: http://us4.php.net/types.array If you don't set a key, PHP starts with '0' and increments as you add more elements to the array. If you have NOTICEs turned on, I believe you'll get a notice saying that $arrlevels[99] doesn't exist. It's not a fatal error, so

[PHP] OK ... WHY does this work ?????

2004-09-14 Thread -{ Rene Brehmer }-
This is some experimental code I did to try and find a way to recycle the same query multiple times as efficient as possible. With the purpose of efficiently comparing the results of 2 queries where the resultset from both queries won't match in the size (in this sample test it coincidently

Re: [PHP] OK ... WHY does this work ?????

2004-09-14 Thread Greg Donald
On Tue, 14 Sep 2004 22:32:54 +0200, -{ Rene Brehmer }- [EMAIL PROTECTED] wrote: Unless I misunderstand how PHP make unspecified arrays (and I probably do since this works), when you have an array of 3 elements on the first dimenstion like I do, and then ask for

Re: [PHP] OK SQL experts...

2004-04-25 Thread Daniel Clark
I think you want to remove the single quotes around the field names. SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%' OR field_2 LIKE '%$keyword%' OR field_3 LIKE '%$keyword%') AND status = 'active'; I STFW and RTFM and I still can't figure out why this returns a 1064 parse error:

Re: [PHP] OK SQL experts...

2004-04-25 Thread Daniel Clark
The parenthesis are OK. The query might take a long time to run with 3 LIKE statements. Backticks, single quotes, or nothing at all makes no difference. I believe the parsing error is due to my parentheses or AND/OR structure. Any thoughts on that? On Apr 23, 2004, at 8:32 AM, John W.

[PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; Anyone? TIA! - B1ff Lamer -- PHP General Mailing List

RE: [PHP] OK SQL experts...

2004-04-23 Thread Edward Peloke
why are the table and field names surrounded by single quotes? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:19 AM To: [EMAIL PROTECTED] Subject: [PHP] OK SQL experts... I STFW and RTFM and I still can't figure out why this returns

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:19 AM To: [EMAIL PROTECTED] Subject: [PHP] OK SQL experts... I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword

RE: [PHP] OK SQL experts...

2004-04-23 Thread Jay Blanchard
[snip] I tried it both ways - didn't make any difference (phpmyadmin adds the single quotes when I was trying to use its sql function to debug, so I figured what the hell)... [/snip] Those aren't single quotes it adds to table and column names...those are back tics (on the same key as the

RE: [PHP] OK SQL experts...

2004-04-23 Thread Edward Peloke
does it just return the error when running in the php page? If you pull it out can you run it in mysql without errors? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:23 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... I

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
] Sent: Friday, April 23, 2004 11:23 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... I tried it both ways - didn't make any difference (phpmyadmin adds the single quotes when I was trying to use its sql function to debug, so I figured what the hell)... On Apr 23, 2004, at 8:27 AM

Re: [PHP] OK SQL experts...

2004-04-23 Thread Richard Harb
the hell)... On Apr 23, 2004, at 8:27 AM, Edward Peloke wrote: why are the table and field names surrounded by single quotes? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:19 AM To: [EMAIL PROTECTED] Subject: [PHP] OK SQL experts... I

Re: [PHP] OK SQL experts...

2004-04-23 Thread John W. Holmes
From: Brian Dunning [EMAIL PROTECTED] I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; Use backticks

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
Backticks, single quotes, or nothing at all makes no difference. I believe the parsing error is due to my parentheses or AND/OR structure. Any thoughts on that? On Apr 23, 2004, at 8:32 AM, John W. Holmes wrote: From: Brian Dunning [EMAIL PROTECTED] I STFW and RTFM and I still can't figure

RE: [PHP] OK SQL experts...

2004-04-23 Thread Jeff McKeon
'%$keyword%' status = 'active' || field_2 like '%$keyword%' status = 'active' || field_3 like '%$keyword%' status = 'active' Jeff -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:30 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL

RE: [PHP] OK SQL experts...

2004-04-23 Thread Jay Blanchard
[snip] SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; [/snip] How about this? SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%' OR field_2 LIKE '%$keyword%' OR field_3 LIKE '%$keyword%')

RE: [PHP] OK SQL experts...

2004-04-23 Thread Edward Peloke
what value is being put in the $keyword variable? You are sure all these columns exist? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing

RE: [PHP] OK SQL experts...

2004-04-23 Thread Edward Peloke
if you echo out the query..what is the output? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no difference. I believe

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no difference. I believe the parsing error is due to my parentheses or AND/OR structure. Any

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no difference. I believe the parsing error is due to my parentheses or AND/OR structure. Any thoughts on that? On Apr 23, 2004, at 8:32 AM, John W. Holmes wrote: From: Brian Dunning [EMAIL PROTECTED

Re: [PHP] OK SQL experts...

2004-04-23 Thread Mark
[mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no difference. I believe the parsing error is due to my parentheses or AND/OR structure. Any thoughts

RE: [PHP] OK SQL experts...

2004-04-23 Thread Daniel Purdy
I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; Why don't you try rebuilding the query. I mean go into

RE: [PHP] OK SQL experts...

2004-04-23 Thread Jay Blanchard
[snip] SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; [/snip] *slaps forehead* SELECT * FROM my_table WHERE (field_1 LIKE '% . $keyword . %' OR field_2 LIKE '% . $keyword . %' OR field_3 LIKE

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
? You are sure all these columns exist? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no difference. I believe the parsing

RE: [PHP] OK SQL experts...

2004-04-23 Thread Chris W. Parker
Brian Dunning mailto:[EMAIL PROTECTED] on Friday, April 23, 2004 8:19 AM said: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; have you tried simply: SELECT * FROM my_table WHERE status =

RE: [PHP] OK SQL experts...

2004-04-23 Thread Jay Blanchard
[snip] SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%') AND status = 'active'; if that works continue until you get an error. [/snip] That'll give you an error right there. That old single quoted variable will get you every time. :) WHERE (field_1 LIKE '%$keyword%') WHERE (field_1

Re[2]: [PHP] OK SQL experts...

2004-04-23 Thread Tom Rogers
Hi, Saturday, April 24, 2004, 1:55:36 AM, you wrote: JB [snip] JB SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR JB 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND JB 'status' = 'active'; JB [/snip] JB *slaps forehead* JB SELECT * FROM my_table WHERE (field_1

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
if that works move up into: SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%') AND status = 'active'; Yes, I actually did exactly that. Everything works until I have more than one statement inside the (x LIKE x OR x LIKE x) parens. That's why I figured there has to be something wrong with

RE: Re[2]: [PHP] OK SQL experts...

2004-04-23 Thread Jay Blanchard
[snip] They do if they are themselves inside double quotes :) echo '$var'; will get parsed ok [/snip] I know, but since I saw no double quotes I had to go for the obvious. :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re[4]: [PHP] OK SQL experts...

2004-04-23 Thread Tom Rogers
Hi, Saturday, April 24, 2004, 2:03:36 AM, you wrote: JB [snip] JB They do if they are themselves inside double quotes :) JB echo '$var'; will get parsed ok JB [/snip] JB I know, but since I saw no double quotes I had to go for the obvious. :) Yes I would like to see the whole truth as well :)

Re[2]: [PHP] OK SQL experts...

2004-04-23 Thread Richard Davey
Hello Brian, Friday, April 23, 2004, 5:02:00 PM, you wrote: BD Yes, I actually did exactly that. Everything works until I have more BD than one statement inside the (x LIKE x OR x LIKE x) parens. That's why BD I figured there has to be something wrong with my paren structure. When BD I RTFM I

Re: [PHP] OK SQL experts...

2004-04-23 Thread William Lovaton
How are you manipulating the whole SQL string?? $sql = SELECT...; ??? or $sql = 'SELECT...'; ??? In this case you will have to use double quotes because PHP won't parse single quote strings for searching embedded PHP variables. May be this is the problem. -William El vie, 23-04-2004 a

Re: [PHP] OK SQL experts...

2004-04-23 Thread Curt Zirzow
* Thus wrote Brian Dunning ([EMAIL PROTECTED]): I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; You might

Re: [PHP] OK SQL experts...

2004-04-23 Thread John Nichel
Brian Dunning wrote: I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; Anyone? TIA! - B1ff Lamer What does

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
On Apr 23, 2004, at 10:13 AM, John Nichel wrote: Brian Dunning wrote: I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' =

RE: [PHP] OK SQL experts...

2004-04-23 Thread Edward Peloke
doesn't look like your $keyword value contains anything. -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 1:19 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... On Apr 23, 2004, at 10:13 AM, John Nichel wrote: Brian Dunning

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
On Apr 23, 2004, at 10:27 AM, Edward Peloke wrote: doesn't look like your $keyword value contains anything. My error. Here is the actual return: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''my_table'

Re: [PHP] OK SQL experts...

2004-04-23 Thread Curt Zirzow
* Thus wrote Brian Dunning ([EMAIL PROTECTED]): On Apr 23, 2004, at 10:13 AM, John Nichel wrote: Brian Dunning wrote: I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE

Re[2]: [PHP] OK SQL experts...

2004-04-23 Thread Richard Davey
Hello Brian, Friday, April 23, 2004, 6:18:43 PM, you wrote: BD You have an error in your SQL syntax. Check the manual that corresponds BD to your MySQL server version for the right syntax to use near BD ''my_table' WHERE ('field_1' LIKE '%%' OR 'field2' my_table should NOT be quoted in this

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''my_table' WHERE ('field_1' LIKE '%%' OR 'field2' Because you are using a single quotes around your table/field names. Remove them or use ` (back tick). As

Re: [PHP] OK SQL experts...

2004-04-23 Thread John W. Holmes
From: Brian Dunning [EMAIL PROTECTED] My error. Here is the actual return: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''my_table' WHERE ('field_1' LIKE '%custom%' OR 'field_ I am searching for the

Re: [PHP] OK SQL experts...

2004-04-23 Thread Brian Dunning
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''my_table' WHERE ('field_1' LIKE '%%' OR 'field2' Because you are using a single quotes around your table/field names. Remove them or use ` (back tick). As

Re: [PHP] OK SQL experts...

2004-04-23 Thread John Nichel
Brian Dunning wrote: On Apr 23, 2004, at 10:13 AM, John Nichel wrote: Brian Dunning wrote: I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE

[PHP] OK

2003-07-22 Thread Rausch Alexandru
Sorry, i didn't itent to be a spam, believe me. But i don't know how to do this aplication

Re: [PHP] OK

2003-07-22 Thread Jeff Harris
On Jul 22, 2003, Rausch Alexandru claimed that: |Sorry, i didn't itent to be a spam, believe me. But i don't know how to |do this aplication | In that case, you might want to start with something a bit less ambitious, maybe learning to wrap your mail, and some tutorials?

Re: [PHP] OK, So I am new to these List. Win2000 help!

2003-07-13 Thread John Nichel
: Re: [PHP] OK, So I am new to these List. Win2000 help! John A. Thomason wrote: The following is my output in the command prompt window(DOS Prompt?) C:\PHPhello.php Content-type: text/html X-Powered-By: PHP/4.3.2 !#C:\php\; echoHello World!; if ($foo): echo yep\n; elseif ($bar): echo almost\n

[PHP] OK, So I am new to these List. Win2000 help!

2003-07-12 Thread John A. Thomason
The following is my output in the command prompt window(DOS Prompt?) C:\PHPhello.php Content-type: text/html X-Powered-By: PHP/4.3.2 !#C:\php\; echoHello World!; if ($foo): echo yep\n; elseif ($bar): echo almost\n; else: echo nope\n; endif; phpinfo(); C:\PHP And the following is the PHP code to

Re: [PHP] OK, So I am new to these List. Win2000 help!

2003-07-12 Thread John Nichel
John A. Thomason wrote: The following is my output in the command prompt window(DOS Prompt?) C:\PHPhello.php Content-type: text/html X-Powered-By: PHP/4.3.2 !#C:\php\; echoHello World!; if ($foo): echo yep\n; elseif ($bar): echo almost\n; else: echo nope\n; endif; phpinfo(); C:\PHP And the

[PHP] OK guys, thank you so far

2003-06-04 Thread Øystein Håland
Now my code is extract ($_GET); if ($_GET['printout'] != yeah) { include(header.php); } but I still get the following error: Undefined index: printout I understand nothing Jonathan Wilkes [EMAIL PROTECTED] skrev i meddelandet news:[EMAIL PROTECTED] Hi, What he means is that with

RE: [PHP] OK guys, thank you so far

2003-06-04 Thread Edward Peloke
can you try if ($HTTP_GET_VARS['printout']!=yeah) {include(header.php);} does that work? -Original Message- From: Øystein Håland [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 1:17 PM To: [EMAIL PROTECTED] Subject: [PHP] OK guys, thank you so far Now my code is extract ($_GET

Re: [PHP] OK guys, thank you so far

2003-06-04 Thread Wendell Brown
On Tue, 3 Jun 2003 19:16:30 +0200, +ystein H†land wrote: Now my code is extract ($_GET); if ($_GET['printout'] != yeah) { include(header.php); } but I still get the following error: Undefined index: printout I understand nothing Ok, it looks like you are mixing your metaphors ;) If you

Re: [PHP] OK guys, thank you so far

2003-06-04 Thread Øystein Håland
? -Original Message- From: Øystein Håland [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 1:17 PM To: [EMAIL PROTECTED] Subject: [PHP] OK guys, thank you so far Now my code is extract ($_GET); if ($_GET['printout'] != yeah) { include(header.php); } but I still get the following

Re: [PHP] OK guys, thank you so far

2003-06-04 Thread David Nicholson
Hello, This is a reply to an e-mail that you wrote on Tue, 3 Jun 2003 at 20:04, lines prefixed by '' were originally written by you. I've tried and here's the output: Undefined index: input if ($HTTP_GET_VARS['printout'] != yeah) { include(header.php); } You have error reporting set to E_ALL,

Re: [PHP] OK guys, thank you so far

2003-06-04 Thread Lars Torben Wilson
On Tue, 2003-06-03 at 13:20, David Nicholson wrote: Hello, This is a reply to an e-mail that you wrote on Tue, 3 Jun 2003 at 20:04, lines prefixed by '' were originally written by you. I've tried and here's the output: Undefined index: input if ($HTTP_GET_VARS['printout'] != yeah) {

Re: [PHP] Ok, problem found, but that makes way for another...

2003-04-03 Thread Ryan Vennell
ok, now where in that heck can i find the php entry in that file? i cant seem to find it anywhere. would it be with the CGI entry or in a different place? Marek Kilimajer[EMAIL PROTECTED] 04/03/03 04:37AM The old installation is likely in /usr, and you installed in /usr/local. Simply remove

Re: [PHP] Ok, problem found, but that makes way for another...

2003-04-03 Thread Marek Kilimajer
The old installation is likely in /usr, and you installed in /usr/local. Simply remove the old installation (man rm ;-) and change httpd.conf to look for php in the new place Ryan Vennell wrote: ok, my last post stated that i've tried reconfigureing.making/makeinstalling php 4.3.1 a tons of

[PHP] Ok, problem found, but that makes way for another...

2003-04-02 Thread Ryan Vennell
ok, my last post stated that i've tried reconfigureing.making/makeinstalling php 4.3.1 a tons of times. well, today when i typed php -v it told me that version 4.2.2 was the one that was installed. so apparently my installing has not been taking the place of the old one. The original root

[PHP] ok now my sessions are *not* timing out

2003-03-11 Thread freaky deaky
before my problem was that my sessions were being terminated spontaneously. it looks like i've managed to fix that problem - so far i haven't been randomly logged off my application. the problem is, according to my php.ini settings, my session should have been terminated after 2 hours, it's

  1   2   >