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
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 th
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 or
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
--
---
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
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 y
From: "Joffrey Leevy" <[EMAIL PROTECTED]>
> 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?
I woul
From: "Adam Williams" <[EMAIL PROTECTED]>
> 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 "ho
I'm doing a fulltext search.
CPT John W. Holmes wrote:
From: "Adam Williams" <[EMAIL PROTECTED]>
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 quer
From: "Adam Williams" <[EMAIL PROTECTED]>
> CPT John W. Holmes wrote:
> > From: "Adam Williams" <[EMAIL PROTECTED]>
> >
> >>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 "
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
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
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 M
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 aa-12
[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
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 al
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
t
[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
tha
I'm using Informix SQL. Do you know how to do full text searching on
Informix? If so, please share the details :)
Jay Blanchard wrote:
[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 s
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
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
[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 h
22 matches
Mail list logo