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 >

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

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

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

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

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 migh

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 t

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

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 fast

[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

[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

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?

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

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

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

2007-06-15 Thread Satyam
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?

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

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 as

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 reside

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

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 l

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 wheth

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 do

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 t

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

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 lik

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

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

2005-07-19 Thread John Nichel
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...

2005-07-19 Thread Chris Boget
> 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...

2005-07-19 Thread John Nichel
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 ) . "

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

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: [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: [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: [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
the same error when I run it in phpmyadmin. > > > On Apr 23, 2004, at 8:34 AM, Edward Peloke wrote: > > > 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- > &g

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
AFAIK phpMyAdmin uses backticks for table/field names, not single quotes ... Friday, April 23, 2004, 5:22:35 PM, thus was written: > 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 h

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
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, Edward Peloke wrote: why are the table and field names surrounded by single quotes? -Original

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

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/

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

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
I've tried and here's the output: Undefined index: input if ($HTTP_GET_VARS['printout'] != "yeah") { include("header.php"); } "Edward Peloke" <[EMAIL PROTECTED]> skrev i meddelandet news:[EMAIL PROTECTED] > can you try if ($HTTP_GET_VARS['printout']!="yeah") {include("header.php");} > > does that

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 far Now my code is extract ($_G

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

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

RE: [PHP] *OK, more eval for today

2002-12-19 Thread Ford, Mike [LSS]
> -Original Message- > From: Alexey Lysenkov [mailto:[EMAIL PROTECTED]] > Sent: 18 December 2002 19:08 > > > I am trying to do this: > > $tempVar1 = '\$HTTP_POST_VARS[\"q4_'.$i.'"]'; > eval("\$tempVar1=\"$tempVar1\";"); > Well, you have the answer right there in front of you -- why n

RE: [PHP] *OK, more eval for today

2002-12-18 Thread Martin Towell
argh! eval() try this instead: $temp = ${"php_q3_$i"}; to get it directly from $HTTP_POST_VARS: $temp = $HTTP_POST_VARS["php_q3_$i"]; simple HTH Martin -Original Message- From: Alexey Lysenkov [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 6:08 AM To: [EMAIL PROTECTED] Subje

Re: [PHP] *OK, more eval for today

2002-12-18 Thread Alexey Lysenkov
It worked for validation! :) Hooray. Now, I guess, I have to set the same logic for the whole other bumch of questions God.. Most probably will post here today later again. Cheers, John! -Alex -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/

Re: [PHP] *OK, more eval for today

2002-12-18 Thread Alexey Lysenkov
am trying -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] *OK, more eval for today

2002-12-18 Thread John W. Holmes
> Okay, wait. > How? > > say, I have a field of checkboxes in 3 columns and 6 rows. I need at least > one checked. > At the moment every checkbox has the name of kind: q3_4_1 , where 4 stands > for row and 1 for column. Now, how do I name them and loop through them? > Plus, if $HTTP_POST_VAR["q3_4

Re: [PHP] *OK, more eval for today

2002-12-18 Thread Alexey Lysenkov
Okay, wait. How? say, I have a field of checkboxes in 3 columns and 6 rows. I need at least one checked. At the moment every checkbox has the name of kind: q3_4_1 , where 4 stands for row and 1 for column. Now, how do I name them and loop through them? Plus, if $HTTP_POST_VAR["q3_4_1"] wasn't chec

RE: [PHP] *OK, more eval for today

2002-12-18 Thread John W. Holmes
Why not name your form elements php_q3[] and then just loop through the array. That would cut the need for eval(). ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -Original Message- > From: Alexey Lysenkov [mai

Re: [PHP] ok what kind of crack is my computer smoking?

2002-06-27 Thread Rick Kukiela
Message - From: "Demitrious S. Kelly" <[EMAIL PROTECTED]> To: "'Kurth Bemis (List Monkey)'" <[EMAIL PROTECTED]> Cc: "'Rick Kukiela'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 4:30 PM Subject: R

RE: [PHP] ok what kind of crack is my computer smoking?

2002-06-27 Thread Demitrious S. Kelly
Whoa! Good idea! -Original Message- From: Kurth Bemis (List Monkey) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 2:35 PM To: Demitrious S. Kelly Cc: 'Rick Kukiela'; [EMAIL PROTECTED] Subject: RE: [PHP] ok what kind of crack is my computer smoking? At 02:19 PM

Re: [PHP] ok what kind of crack is my computer smoking?

2002-06-27 Thread Rick Kukiela
- Original Message - From: "Erik Price" <[EMAIL PROTECTED]> To: "Rick Kukiela" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 4:28 PM Subject: Re: [PHP] ok what kind of crack is my computer smoking? > > On Thursday, June 27, 2002

RE: [PHP] ok what kind of crack is my computer smoking?

2002-06-27 Thread Kurth Bemis (List Monkey)
At 02:19 PM 6/27/2002 -0700, Demitrious S. Kelly wrote: hey - RESTART APACHE! ~kurth >You check and make sure the date was set right on the box? > >You could try "make clean" for everything before configuring... > > >-Original Message- >From: Rick Kukiela [mailto:[EMAIL PROTECTED]] >Sen

RE: [PHP] ok what kind of crack is my computer smoking?

2002-06-27 Thread Demitrious S. Kelly
You check and make sure the date was set right on the box? You could try "make clean" for everything before configuring... -Original Message- From: Rick Kukiela [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 2:10 PM To: [EMAIL PROTECTED] Subject: [PHP] ok what kind of crack i

Re: [PHP] ok what kind of crack is my computer smoking?

2002-06-27 Thread Erik Price
On Thursday, June 27, 2002, at 05:09 PM, Rick Kukiela wrote: > SO what do i have to do to get php to acknolege the fact that it has > been > recompiled with new options Did you rm ./config.cache in the Apache source tree? If I were you, I'd remove the source trees you have, re-extrac

Re: Re: [PHP] OK Dan...

2002-03-05 Thread GENESiS DESiGNS
Dan, I;m using PHP to create my database. This is the script I'm using: -- -- Thanks, -GENESiS DESiGNS -Sean Kennedy -http://www.gdesigns.vcn.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] ok still want to join a project...

2002-02-09 Thread DL Neil
Emphasis on the second-last word? =dn - Original Message - From: "Nick Wilson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 09 February 2002 18:24 Subject: Re: [PHP] ok still want to join a project... > -BEGIN PGP SIGNED MESSAGE- > Hash:

Re: [PHP] ok still want to join a project...

2002-02-09 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Arik Ashepa declared > nice... anyone else has an idea? How about a Haiku db? The php list a place for conversation with other nutters Hehe,. - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingne

Re: [PHP] ok still want to join a project...

2002-02-09 Thread Arik Ashepa
nice... anyone else has an idea? Jason Wong wrote: > On Sunday 10 February 2002 01:42, Arik Ashepa wrote: > >>any offers? or start one... >> > > If you're still stuck for ideas, how about a jobs board, something like > monster.com? > > > -- PHP General Mailing List (http://www.php.net/)

  1   2   >