[PHP-DB] Converting upper case letters to lower case because of db??
Hi there, I have a tabel with 250 entries showing a country code lik CA Now my application does not work on linux, because they have to be in lower case. Can I make anyhow an bufix, or even better creating a php function to change all 250 entries to lower case. I could not find the propper function on the php site. Can anybody please help on changing this thing into lower case? Thanx ANdy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Converting upper case letters to lower case because of db??
On Thu, 7 Feb 2002 17:07:35 +0100 Andy Andy [EMAIL PROTECTED] wrote: Hi there, I have a tabel with 250 entries showing a country code lik CA Now my application does not work on linux, because they have to be in lower case. Can I make anyhow an bufix, or even better creating a php function to change all 250 entries to lower case. I could not find the propper function on the php site. Can anybody please help on changing this thing into lower case? Thanx ANdy How about strtolower()? -- Raquel Americans cannot teach democracy to the world until they restore their own. --William Greider, journalist and author -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Converting upper case letters to lower case because of db??
strtolower() -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 8:08 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Converting upper case letters to lower case because of db?? Hi there, I have a tabel with 250 entries showing a country code lik CA Now my application does not work on linux, because they have to be in lower case. Can I make anyhow an bufix, or even better creating a php function to change all 250 entries to lower case. I could not find the propper function on the php site. Can anybody please help on changing this thing into lower case? Thanx ANdy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Converting upper case letters to lower case because of db??
On Friday 08 February 2002 00:14, Raquel Rice wrote: On Thu, 7 Feb 2002 17:07:35 +0100 Andy Andy [EMAIL PROTECTED] wrote: Hi there, I have a tabel with 250 entries showing a country code lik CA Now my application does not work on linux, because they have to be in lower case. Can I make anyhow an bufix, or even better creating a php function to change all 250 entries to lower case. I could not find the propper function on the php site. Can anybody please help on changing this thing into lower case? Thanx ANdy How about strtolower()? You can run a query directly on the db. Something like: update mytable set myfield = LOWER(myfield) WHERE 1; -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Distrust all those who love you extremely upon a very slight acquaintance and without any visible reason. -- Lord Chesterfield */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php