Posts tagged case
Q&A: PHP/MYSQL CASE QUESTION?
Oct 2nd
Question by Timbuktu:
PHP/MySQL case question?
in my search engine script, i have the “select * from table1 where column1 like %$ _POST[search]% or column2 like etc”. But when i conduct the search, things appear to be case sensitive. For example, when searching for date, e.g. June, if i typed june, i could not find anything, only if i typed June.
i could use the “strtoupper” function like:
$ _POST[search]=strtoupper($ _POST[search]); before the query above, and then search all in CAPS?
any other solutions which will make things case insensitive?
or put differently: how do you make a query result case insensitive?
Read More >>
WHERE CAN I FIND BUILD PC INTO IMAC G3 CASE INSTRUCTIONS?
Oct 25th
I found instructions on how to build a Computer into a Mac G3 a while ago, but I cannot find the website anymore! Can anyone help me here? I have been searching with search engines for the whole day!
I have a Power iMac G3 and I want to custom build a Computer into it and I might get the money to do so soon…
Read More >>
PHP/MYSQL CASE QUESTION?
Apr 25th
in my search engine script, i have the “select * from table1 where column1 like %$_POST[search]% or column2 like etc”. But when i conduct the search, things appear to be case sensitive. For example, when searching for date, e.g. June, if i typed june, i could not find anything, only if i typed June.
i could use the “strtoupper” function like:
$_POST[search]=strtoupper($_POST[search]); before the query above, and then search all in CAPS?
any other solutions which will make things case insensitive?
or put differently: how do you make a query result case insensitive?
Read More >>