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

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] Ok then, here is a test

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

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

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: >

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

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

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

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

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

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: > > > > >> >

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

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 migh

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

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 t

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

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 > >

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

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 fast

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

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

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

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

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

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?

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

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?

[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

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

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?

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 tha

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

t;[EMAIL PROTECTED]> To: 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

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

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?

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 wr

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

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 as

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

[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 reside

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

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?

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?

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?

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 sec

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

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 l

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

[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 wheth

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

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 next php problem

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 do

Re: [PHP] Ok next php problem

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 t

Re: [PHP] Ok next php problem

they are not scripted statically. - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "Rob W." <[EMAIL PROTECTED]> Cc: Sent: Sunday, June 18, 2006 8:38 PM Subject: Re: [PHP] Ok next php problem Rob W. wrote: I got the previous question answ

Re: [PHP] Ok next php problem

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 lik

[PHP] Ok next php problem

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 isnt

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

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?

-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...

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 + (

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

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 is this happening...

Chris Boget wrote: Chris Boget wrote: echo "if( $originalNet != $calculatedNet ) = " . ( (int)$originalNet !== (int)$calculatedNet ) . "\n"; Change this to echo out what you're comparing... echo "if( ". (int)$originalNet ." != ". (int)$calculatedNet ." ) = " . ( (int)$originalNet !== (int)$

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

> Chris Boget wrote: > > > echo "if( $originalNet != $calculatedNet ) = " . ( (int)$originalNet !== > > (int)$calculatedNet ) . "\n"; > > Change this to echo out what you're comparing... > echo "if( ". (int)$originalNet ." != ". (int)$calculatedNet ." ) = " . ( > (int)$originalNet !== (int)$calcu

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

Chris Boget wrote: echo "if( $originalNet != $calculatedNet ) = " . ( (int)$originalNet !== (int)$calculatedNet ) . "\n"; Change this to echo out what you're comparing... echo "if( ". (int)$originalNet ." != ". (int)$calculatedNet ." ) = " . ( (int)$originalNet !== (int)$calculatedNet ) . "

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

Consider the following test script: set_time_limit( 0 ); echo ''; echo ''; echo ''; echo 'Running test...
'; flush(); echo ''; echo ''; echo ''; echo '

Original Net

Commission %< 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 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 $arrlevels[$lvl_guest]['level [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 doe 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 A 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-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 '%$keyword%') 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 sugges 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 f 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 sugges 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 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_ 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' WHER 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 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' = 'acti 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 mysql_ 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 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[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[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 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: [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 m 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 (fi 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 LIKE RE: [PHP] OK SQL experts... 2004-04-23 Thread Chris W. Parker Brian Dunning 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 statu Re: [PHP] OK SQL experts... 2004-04-23 Thread Brian Dunning ng 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 at all makes no di 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 L 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 Re: [PHP] OK SQL experts... 2004-04-23 Thread Mark > 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, Re: [PHP] OK SQL experts... 2004-04-23 Thread Brian Dunning MAIL 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 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: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 stru 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 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 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 Jeff McKeon rd%' && 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 experts... > > > It gives 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 figu 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 backt Re: [PHP] OK SQL experts... 2004-04-23 Thread Richard Harb gured what 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 A 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: 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 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 tilde) Re: [PHP] OK SQL experts... 2004-04-23 Thread Brian Dunning uotes? -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 ('fiel 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 retu [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 (http:// 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? http://www.devshed.com/ [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, So I am new to these List. Win2000 help! 2003-07-13 Thread John Nichel t; Sent: Saturday, July 12, 2003 10:01 PM Subject: 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:\PHP>hello.php Content-type: text/html X-Powered-By: PHP/4.3.2 !#C:\php\; echo"Hello 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:\PHP>hello.php Content-type: text/html X-Powered-By: PHP/4.3.2 !#C:\php\; echo"Hello World!"; if ($foo): echo "yep\n"; elseif ($bar): echo "almost\n"; else: echo "nope\n"; endif; phpinfo(); C:\PHP> And t [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:\PHP>hello.php Content-type: text/html X-Powered-By: PHP/4.3.2 !#C:\php\; echo"Hello World!"; if ($foo): echo "yep\n"; elseif ($bar): echo "almost\n"; else: echo "nope\n"; endif; phpinfo(); C:\PHP> And the following is the PH 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'] != " 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 Re: [PHP] OK guys, thank you so far 2003-06-04 Thread Øystein Håland 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, th 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... 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 [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 "regi 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 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 ti [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 i Re: [PHP] ok now my sessions are *not* timing out 2003-03-11 Thread Ernest E Vogelsinger At 14:38 11.03.2003, freaky deaky said: [snip] >the js looks like: > >   1   2   >