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
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
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
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
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
[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
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
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
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
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)
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
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
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
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
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).
[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
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).
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
[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
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
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
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
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???
--
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
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??
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
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
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
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]
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
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
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
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
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
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:
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
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.
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
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,
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
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
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:
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
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
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?
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
46 matches
Mail list logo