[PHP] PHP 4.4.8 Released!

2008-01-03 Thread Derick Rethans
Hello! The PHP development team would like to announce the immediate availability of PHP 4.4.8. It continues to improve the security and the stability of the 4.4 branch and all users are strongly encouraged to upgrade to it as soon as possible. This release wraps up all the outstanding

[PHP] mysql date question

2008-01-03 Thread Adam Williams
I have a field in mysql as shown by describe contract; | length_start | date| YES | | NULL || Which stores it in the mysql format of -MM-DD. However, I need the output of my select statement to show it in MM-DD- format. I can select

Re: [PHP] mysql date question

2008-01-03 Thread Stut
Adam Williams wrote: select date_format('contract.length_start', '%m-%d-%Y') as length_start from contract where user_id = 1; This has nothing to do with PHP, but the first parameter to date_format should not be in quotes. -Stut -- http://stut.net/ -- PHP General Mailing List

[PHP] Re: mysql date question

2008-01-03 Thread Adam Williams
nevermind, figure it out, had to take the ' ' away from contract.length_start :) Adam Williams wrote: I have a field in mysql as shown by describe contract; | length_start | date| YES | | NULL || Which stores it in the mysql format of

RE: [PHP] mysql date question

2008-01-03 Thread Bastien Koert
no need for quotes select date_format(contract.length_start, '%m-%d-%Y') as length_start from contract where user_id = 1; bastien Date: Thu, 3 Jan 2008 08:30:55 -0600 From: [EMAIL PROTECTED] To: php-general@lists.php.net Subject: [PHP] mysql date question I have a field in mysql as

RE: [PHP] mysql date question

2008-01-03 Thread Jay Blanchard
[snip] I have a field in mysql as shown by describe contract; | length_start | date| YES | | NULL || Which stores it in the mysql format of -MM-DD. However, I need the output of my select statement to show it in MM-DD- format. I can

[PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Balaji A
Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes (language, author title). Initially first select box displays the available language by querying the database. On selecting one language, author

Re: [PHP] mysql date question

2008-01-03 Thread Silvio Porcellana
Uhm, a shot in the dark - try: select date_format(contract.length_start, '%m-%d-%Y') as length_start HTH, cheers! Silvio Adam Williams wrote: I have a field in mysql as shown by describe contract; | length_start | date| YES | | NULL || Which

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Robert Cummings
On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes (language, author title). Initially first select box displays the available language by

Re: [PHP] First stupid post of the year. [SOLVED]

2008-01-03 Thread Nisse Engström
On Wed, 2 Jan 2008 19:36:56 -0500, tedd wrote: To find out, I did put the operation through FireFox and reversed the POST/GET operations to get a look at the string -- it is: %C2%A0%C2%A0%C2%A0Z%C2%A0%C2%A0%C2%A0 where Z is the value passed. Now, C2 (HEX) is a linefeed (194 DEC)

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Jim Lucas
Robert Cummings wrote: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes (language, author title). Initially first select box displays the

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Jochem Maas
Robert Cummings schreef: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes (language, author title). Initially first select box displays the

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Jim Lucas
Jochem Maas wrote: Robert Cummings schreef: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes (language, author title). Initially first

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Balaji A
Hi Thanks for the replies. :-) Robert I do not mean hear to write a new script for me and send.. Requesting if you have any sample file to share.. But any way thanks a lot for the replies. Thanks Balaji On Jan 3, 2008 9:41 AM, Jim Lucas [EMAIL PROTECTED] wrote: Jochem Maas wrote: Robert

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Jochem Maas
Jim Lucas schreef: Jochem Maas wrote: Robert Cummings schreef: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes (language, author title).

RE: [PHP] Sample script files with 3 different select boxes withmysql conditions in select boxes

2008-01-03 Thread Jay Blanchard
[snip] I don't suppose any of you punks know the meaning of rhetorical? ;) [/snip] Rhetorical? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Robert Cummings
On Thu, 2008-01-03 at 07:48 -0800, Jim Lucas wrote: Jochem Maas wrote: Jim Lucas schreef: Jochem Maas wrote: Robert Cummings schreef: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book).

RE: [PHP] Sample script files with 3 different select boxes withmysql conditions in select boxes

2008-01-03 Thread Robert Cummings
On Thu, 2008-01-03 at 09:52 -0600, Jay Blanchard wrote: [snip] I don't suppose any of you punks know the meaning of rhetorical? ;) [/snip] Rhetorical? Rhetorical?? -- ... SwarmBuy.com - http://www.swarmbuy.com Leveraging the

RE: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Jay Blanchard
[snip] I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes (language, author title). Initially first select box displays the available language by querying the database. On selecting one language, author

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Jochem Maas
Jim Lucas schreef: Robert Cummings wrote: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes (language, author title). Initially first

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Robert Cummings
On Thu, 2008-01-03 at 16:38 +0100, Jochem Maas wrote: Jim Lucas schreef: Robert Cummings wrote: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Jim Lucas
Jochem Maas wrote: Jim Lucas schreef: Jochem Maas wrote: Robert Cummings schreef: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes

Re: [PHP] Sample script files with 3 different select boxes withmysql conditions in select boxes

2008-01-03 Thread Børge Holen
On Thursday 03 January 2008 16:55:41 Robert Cummings wrote: On Thu, 2008-01-03 at 09:52 -0600, Jay Blanchard wrote: [snip] I don't suppose any of you punks know the meaning of rhetorical? ;) [/snip] Rhetorical? Rhetorical?? what??? --

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Børge Holen
On Thursday 03 January 2008 16:54:55 Robert Cummings wrote: On Thu, 2008-01-03 at 07:48 -0800, Jim Lucas wrote: Jochem Maas wrote: Jim Lucas schreef: Jochem Maas wrote: Robert Cummings schreef: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the

Re: [PHP] Sample script files with 3 different select boxes withmysql conditions in select boxes

2008-01-03 Thread Wolf
Børge Holen [EMAIL PROTECTED] wrote: On Thursday 03 January 2008 16:55:41 Robert Cummings wrote: On Thu, 2008-01-03 at 09:52 -0600, Jay Blanchard wrote: [snip] I don't suppose any of you punks know the meaning of rhetorical? ;) [/snip] Rhetorical? Rhetorical??

Re: [PHP] First stupid post of the year. [SOLVED]

2008-01-03 Thread tedd
At 4:24 PM +0100 1/3/08, Nisse =?utf-8?Q?Engstr=C3=B6m?= wrote: On Wed, 2 Jan 2008 19:36:56 -0500, tedd wrote: To find out, I did put the operation through FireFox and reversed the POST/GET operations to get a look at the string -- it is: %C2%A0%C2%A0%C2%A0Z%C2%A0%C2%A0%C2%A0 where Z is

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread tedd
At 10:41 AM -0500 1/3/08, Robert Cummings wrote: I don't suppose any of you punks know the meaning of rhetorical? ;) That really isn't a question, is it? Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List

Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread tedd
At 4:38 PM +0100 1/3/08, Jochem Maas wrote: Jim Lucas schreef: Robert Cummings wrote: On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote: Hi, I have a table with the below fields. (id, title, language, author link to the book). Initially I want to display a page with 3 select boxes

RE: [PHP] Sample script files with 3 different select boxes withmysql conditions in select boxes

2008-01-03 Thread Ford, Mike
On 03 January 2008 16:16, Wolf wrote: Børge Holen [EMAIL PROTECTED] wrote: On Thursday 03 January 2008 16:55:41 Robert Cummings wrote: On Thu, 2008-01-03 at 09:52 -0600, Jay Blanchard wrote: [snip] I don't suppose any of you punks know the meaning of rhetorical? ;) [/snip]

[PHP] handling ' with mysql/php insert and select

2008-01-03 Thread Adam Williams
In my form, I am parsing all the text inputs through mysql_real_escape_string() before inserting the data. however, when I look at the SQL query in PHP, when I type the word blah's to my text box variable, and then insert it into mysql after being ran through mysql_real_escape_string(), it

Re: [PHP] handling ' with mysql/php insert and select

2008-01-03 Thread afan pasalic
Adam Williams wrote: In my form, I am parsing all the text inputs through mysql_real_escape_string() before inserting the data. however, when I look at the SQL query in PHP, when I type the word blah's to my text box variable, and then insert it into mysql after being ran through

Re: [PHP] handling ' with mysql/php insert and select

2008-01-03 Thread David Giragosian
On 1/3/08, Adam Williams [EMAIL PROTECTED] wrote: In my form, I am parsing all the text inputs through mysql_real_escape_string() before inserting the data. however, when I look at the SQL query in PHP, when I type the word blah's to my text box variable, and then insert it into mysql after

Re: [PHP] handling ' with mysql/php insert and select

2008-01-03 Thread Brady Mitchell
when I type the word blah's to my text box variable, and then insert it into mysql after being ran through mysql_real_escape_string(), it does: insert into contract (contract_id, responsibility) VALUES (15, 'blah\\\'s') It looks like magic quotes is turned on. Take a look at

Re: [PHP] handling ' with mysql/php insert and select

2008-01-03 Thread Richard Lynch
On Thu, January 3, 2008 1:22 pm, Adam Williams wrote: In my form, I am parsing all the text inputs through mysql_real_escape_string() before inserting the data. however, when I look at the SQL query in PHP, when I type the word blah's to my text box variable, and then insert it into mysql

RE: [PHP] handling ' with mysql/php insert and select

2008-01-03 Thread Bastien Koert
lots of ways to handle this use HTMLentities($string) to convert the apostrophes use addslashes($string) to escape them use mysql_real_escape_string($string) to escape them the last is my preferred method bastien Date: Thu, 3 Jan 2008 13:22:09 -0600 From: [EMAIL PROTECTED] To:

Re: [PHP] mysql date question

2008-01-03 Thread Richard Lynch
On Thu, January 3, 2008 8:30 am, Adam Williams wrote: I have a field in mysql as shown by describe contract; | length_start | date| YES | | NULL || Which stores it in the mysql format of -MM-DD. However, I need the output of my select

Re: [PHP] Re: automatic caller

2008-01-03 Thread Richard Lynch
On Wed, January 2, 2008 4:35 pm, Dan wrote: blackwater dev [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm working on a prototype now and was wondering if anyone new of a service where I could pass in text and a number and the service would call the number and read the text.

Re: [PHP] automatic caller

2008-01-03 Thread Richard Lynch
On Wed, January 2, 2008 6:50 pm, Jim Lucas wrote: blackwater dev wrote: I'm working on a prototype now and was wondering if anyone new of a service where I could pass in text and a number and the service would call the number and read the text. I know I can do this with asterisk and it's

Re: [PHP] Re: automatic caller

2008-01-03 Thread FrozenDice
If you want to make the job really easy go with Delphi, yeah I know it's not PHP, but it comes with the Jedi components, which I'm pretty sure have a built in Speech component, and you can do the Skype api on it. - Dan On Jan 3, 2008 1:53 PM, Richard Lynch [EMAIL PROTECTED] wrote: On Wed,

Re: [PHP] First stupid post of the year.

2008-01-03 Thread Richard Lynch
On Wed, January 2, 2008 5:26 pm, tedd wrote: At 2:34 PM -0800 1/2/08, Jim Lucas wrote: This I think shows what tedd is looking for. so, from this I deduce that this should work. $submit = trim($submit, \xA0\x20); What do you guys/gals think? Nope, not a winner. But it produces some

Re: [PHP] First stupid post of the year.

2008-01-03 Thread Richard Lynch
On Wed, January 2, 2008 3:07 pm, Daniel Brown wrote: On Jan 2, 2008 3:58 PM, Richard Lynch [EMAIL PROTECTED] wrote: Works for me: [EMAIL PROTECTED] ~/cd $ php -a Interactive mode enabled ?php $a = 'nbsp; nbsp; nbsp; nbsp;Anbsp; nbsp; nbsp; nbsp;'; $b = str_replace('nbsp;', '', $a); echo

Re: [PHP] First stupid post of the year. [SOLVED]

2008-01-03 Thread Richard Lynch
On Thu, January 3, 2008 11:39 am, tedd wrote: At 4:24 PM +0100 1/3/08, Nisse Engström wrote: On Wed, 2 Jan 2008 19:36:56 -0500, tedd wrote: To find out, I did put the operation through FireFox and reversed the POST/GET operations to get a look at the string -- it is:

Re: [PHP] First stupid post of the year. [SOLVED]

2008-01-03 Thread Richard Lynch
On Wed, January 2, 2008 6:36 pm, tedd wrote: Now, why does a POST operation add in C2's? I'll leave that for another post. :-) I believe the POST operation adds nothing. The BROWSER interprets your nbsp; as whatever it finds most appropriate to slap into a button VALUE, given the charset and

Re: [PHP] First stupid post of the year. [SOLVED]

2008-01-03 Thread tedd
At 3:35 PM -0600 1/3/08, Richard Lynch wrote: On Wed, January 2, 2008 6:36 pm, tedd wrote: Now, why does a POST operation add in C2's? I'll leave that for another post. :-) I believe the POST operation adds nothing. The BROWSER interprets your nbsp; as whatever it finds most appropriate

Re: [PHP] First stupid post of the year.

2008-01-03 Thread tedd
At 3:28 PM -0600 1/3/08, Richard Lynch wrote: On Wed, January 2, 2008 5:26 pm, tedd wrote: At 2:34 PM -0800 1/2/08, Jim Lucas wrote: This I think shows what tedd is looking for. so, from this I deduce that this should work. $submit = trim($submit, \xA0\x20); What do you guys/gals think?

Re: [PHP] First stupid post of the year. [SOLVED]

2008-01-03 Thread tedd
At 3:33 PM -0600 1/3/08, Richard Lynch wrote: On Thu, January 3, 2008 11:39 am, tedd wrote: That's a valid point. Not only the encoding that's declared for the page via it's html DOCTYPE, but also what encoding was used to actually save that file on the server. This entire encoding