[PHP-DB] PHP and Active Directory...

2003-11-12 Thread Boniforti Flavio
Hello all! I managed to get data out of my Active Directory, but now I have a big trouble: as I'm in Italy and use Italian, I also have characters like à è ì ò ù, which are part of my users' names. Now, when I get this data with PHP, I get following: à gets à ò gest ò I didn't check the

[PHP-DB] RE: Adding in MySQL

2003-11-12 Thread Dillon, John
Thanks for the three replies and two tickings-off. It was a spelling mistake in my table name. The reason I tend to top post is that you then don't have to read the disclaimer or address details from my company in a reply. Sometimes in easy situations the question is clear from the reply plus

Re: [PHP-DB] RE: Adding in MySQL

2003-11-12 Thread David T-G
John -- ...and then Dillon, John said... % % Thanks for the three replies and two tickings-off. It was a spelling % mistake in my table name. I hate those :-) But I'm glad to see you found your answer. % % The reason I tend to top post is that you then don't have to read the % disclaimer

Re: [PHP-DB] PHP and Active Directory...

2003-11-12 Thread Boniforti Flavio
Russell Johnson wrote: With luck, either the utf8_encode or utf8_decode functions might work, else the recode_string function (with some experimentation) should do it. Great! I'm using utf8_decode... and it works!!! Great... ... but I still hate Micro$oft's software! :-( Thank you --

[PHP-DB] Re: about some MySQL basics

2003-11-12 Thread pete M
I use phpmyadmin http://www.phpmyadmin.net/home_page/ ;-) pete Koala Yeung wrote: Maybe tis a little bit out of topic... I want to learn using PHP with MySQL. After long time reading, I still have no idea how to build a database on a remote computer How to create a MySQL database on a

[PHP-DB] newbie question on data accumulation

2003-11-12 Thread Joffrey Leevy
Hi all: Curious as to what happens after data is repeatedly selected from a mysql table overtime. Does it accumulate as junk data, stored at some location and eventually slow down the database/program/server? Does any purging have to take place? Thanks J __ Do

Re: [PHP-DB] keyword searching

2003-11-12 Thread Adam Williams
This is my SQL query: SELECT seriesno, governor, descr, boxno, year, eyear, docno from rg2 WHERE seriesno = '$_POST[seriesno]' and governor matches '*$searchterm*' or descr matches '*$searchterm*'; So as you can see, its gonna need some work to make it do fulltext searching of the descr field.

[PHP-DB] Re: keyword searching

2003-11-12 Thread Chandra Kanth Chereddi
On 12/11/03 12:24 -0600, Adam Williams wrote: So as you can see, its gonna need some work to make it do fulltext searching of the descr field. I'm not really sure how to make it do a keyword search, either since holmes*north*carolina doesn't work because it only searches for those words

Re: [PHP-DB] keyword searching

2003-11-12 Thread CPT John W. Holmes
From: Adam Williams [EMAIL PROTECTED] This is my SQL query: SELECT seriesno, governor, descr, boxno, year, eyear, docno from rg2 WHERE seriesno = '$_POST[seriesno]' and governor matches '*$searchterm*' or descr matches '*$searchterm*'; Looks like you're doing the equivilent to a MySQL LIKE

[PHP-DB] Changing case

2003-11-12 Thread Robert Sossomon
I have a form that allows for an item to be entered, the other pieces have been fixed so far that were bogging me down, but now I am looking for a way to convert any entry in the form to be UPPER case so that when the quote is listed, they are alphabetical. The problem is if someone enters

[PHP-DB] RE: [PHP] Changing case

2003-11-12 Thread Jay Blanchard
[snip] The problem is if someone enters aa-1234 and the other items in the quote are FF-2345 and QQ-3456 then the aa-1234 is UNDER them, instead of on top. [/snip] http://www.php.net/strtoupper -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] Changing case

2003-11-12 Thread CPT John W. Holmes
From: Robert Sossomon [EMAIL PROTECTED] I have a form that allows for an item to be entered, the other pieces have been fixed so far that were bogging me down, but now I am looking for a way to convert any entry in the form to be UPPER case so that when the quote is listed, they are

[PHP-DB] keyword searching

2003-11-12 Thread Adam Williams
Hello, I am selecting a field in a database called description for keyword searching. The field contains names of people, states, years, etc. When someone searches for say holmes north carolina the query searches for exactly that, fields which have holmes north carolina, and not fields that

[PHP-DB] RE: [PHP] keyword searching

2003-11-12 Thread Jay Blanchard
[snip] I am selecting a field in a database called description for keyword searching. The field contains names of people, states, years, etc. When someone searches for say holmes north carolina the query searches for exactly that, fields which have holmes north carolina, and not fields that

RE: [PHP-DB] keyword searching

2003-11-12 Thread Robert Sossomon
Explode the kewords list. I have mine explode the keyword and search the description field. It CAN limit it by category AND/OR by Vendor. But this will do the trick without the limiters. $keyword = $_POST[keyword]; $keywords = explode( , $keyword); // so you can search for each word they enter

[PHP-DB] Re: [PHP] keyword searching

2003-11-12 Thread CPT John W. Holmes
From: Adam Williams [EMAIL PROTECTED] I'm using Informix SQL. Could have saved some bandwidth by mentioning that in the first place and only posting to either php-general or php-db (which is more appropriate), not both. :) Ignore what my other posts said, as I don't know how Informix works.

[PHP-DB] RE: [PHP]{Semi-OT} keyword searching

2003-11-12 Thread Jay Blanchard
[snip] I'm using Informix SQL. Do you know how to do full text searching on Informix? If so, please share the details :) [/snip] You will have to consult your Informix documentation in order to discern if full-text features are available. Usually the text column where the information is being