[PHP-DB] Converting the Month from a word into the numerical expression

2005-10-06 Thread Ron Piggott
I have the word for the month stored in the variable $month In this example $month may be equal to "June". I wonder if there is a way to use the DATE function to convert this into a numberical expression --- in this example 06 Ron -- PHP Database Mailing List (http://www.php.net/) To unsubsc

Re: [PHP-DB] Search & Replace within PHP

2005-10-06 Thread Alain Rivest
Ron Piggott a écrit : Is there a search & replace PHP command? An example I am needing this for would be: My name is replace_with_real_name I want to retrieve replace_with_real_name from a mySQL database and put in the name ... the key is that I want to put the person's name in various positi

Re: [PHP-DB] Search & Replace within PHP

2005-10-06 Thread F.B
it is interesting... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Search & Replace within PHP

2005-10-06 Thread Norland, Martin
I think he's looking for str_replace() / preg_replace() or sprintf() or similar http://www.php.net/str_replace http://www.php.net/preg_replace http://www.php.net/sprintf cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within

[PHP-DB] domxml_open_mem and cdata

2005-10-06 Thread Matthias Willerich
hello, I hope this isn't too off-topic for the list, if it is, please point me to a better one: I have to edit an xml file, and I was going to do that via DOMXML. The editing process itself is fine, but I now realised that all content that was in cdata brackets gets stored back without them. exam

RE: [PHP-DB] Search & Replace within PHP

2005-10-06 Thread Bastien Koert
No sure i this is what you want but... echo "Hi, my name is " . $rows['name']; bastien From: "Ron Piggott" <[EMAIL PROTECTED]> Reply-To: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" Subject: [PHP-DB] Search & Replace within PHP Date: Thu, 6 Oct 2005 10:40:45 -0500 Is there a search & repl

[PHP-DB] Search & Replace within PHP

2005-10-06 Thread Ron Piggott
Is there a search & replace PHP command? An example I am needing this for would be: My name is replace_with_real_name I want to retrieve replace_with_real_name from a mySQL database and put in the name ... the key is that I want to put the person's name in various position ... so I want to searc

Re: [PHP-DB] is SELECT case sensitive

2005-10-06 Thread roy . a . jones
Depends on database ... in Oracle yes data is stored in mixed case so you can use functions like UPPER & LOWER to force case. Roy A. Jones US Pharma Database Administration GlaxoSmithKline Inc. US Pharma IT, Shared Services Email: [EMAIL PROTECTED] http://usphdba.gsk.com/ - USPHARMA Database

Re: [PHP-DB] is SELECT case sensitive

2005-10-06 Thread Koen Wagemans
Select on type varchar is not case sensitive, you can make it case sensitive with the BINARY option: SELECT * FROM table_name WHERE BINARY column LIKE '$searching_criteria'; Koen On 06/10/05, Ron Piggott <[EMAIL PROTECTED]> wrote: > Is SELECT typically case sensitive? Is there a way to ma

[PHP-DB] is SELECT case sensitive

2005-10-06 Thread Ron Piggott
Is SELECT typically case sensitive? Is there a way to make it case sensitive? (In the example below can $searching_criteria become case sensitive?) SELECT * FROM table_name WHERE column LIKE '$searching_criteria'; Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: