[PHP-DB] PostgreSQL lib and character case

2004-04-28 Thread Tumurbaatar S.
I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] MySQL - counting number of instances of a word in a field

2004-04-28 Thread Ignatius Reilly
It is easy to get around this limitation: for each column containing indexable content, create a shadow column containing content prepared for FULLTEXT indexing. I usually do the following: - for each word: - replace all non whitespace, non-blank characters by _ - right pad to 4 with _

Re: [PHP-DB] scrolling drop down menu

2004-04-28 Thread Tristan . Pretty
Cause I care, here's a suggestion... On any drop downs, add an onmouseout event in javascript. I put together a really simple example, I'm sure you could change it to be more usefull for multiple scoll boxes..? http://www.beertastic.co.uk/matthew.html Good luck...! Tris... matthew perry

Re: [PHP-DB] PostgreSQL lib and character case

2004-04-28 Thread Doug Thompson
Tumurbaatar S. wrote: I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? Assuming you want all lower case, convert the form field entry

Re: [PHP-DB] MySQL - counting number of instances of a word in a field

2004-04-28 Thread Ignatius Reilly
The functions do not exist. However, FULLTEXT indexes will do much of this work for you. I encourage you to experiment with them. _ - Original Message - From: Gavin Amm [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 7:18 AM Subject:

[PHP-DB] Re: PostgreSQL lib and character case

2004-04-28 Thread Hans Lellelid
Hi - Tumurbaatar S. wrote: I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? This is how Postgres works: it always returns arrays

RE: [PHP-DB] Request for help on (My)SQL Statement

2004-04-28 Thread John.Bedard
That would work except I'd change the last line to send email. The problem is the users are showing up to see any alert of new posts on the site. And when they do access PHPBB it will highlight those topics that have new posts anyway. Just got to get them there in the first place. Thanks,

Re: [PHP-DB] PostgreSQL lib and character case

2004-04-28 Thread Martin Marques
El Wednesday 28 April 2004 03:21, Tumurbaatar S. escribió: I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? No. PHP is

Re: [PHP-DB] First letter

2004-04-28 Thread Lang Sharpe
Cornelia Boenigk wrote: Hi Matt You can teat a string like an Array $first = $string[0]; $second = $string[1] and so on. Actually this method is deprecated. The current best way is to use curly braces. $first = $string{0}; $second = $string{1}; Lang -- PHP Database Mailing List