Ask for help!Capital sensitive [SOLVED]
Posted: Wed Oct 25, 2006 9:12 am
Hi,
Anybody knows how to get rid of capital-sensitive in the following code?
I found the results were capital sensitive.
means I need to input "HELLO" instead of "hello" if I want the term found in database (the term in database is
"HELLO").
Anybody knows how to get rid of capital-sensitive in the following code?
I found the results were capital sensitive.
means I need to input "HELLO" instead of "hello" if I want the term found in database (the term in database is
"HELLO").
Code: Select all
mysql_pconnect ("localhost", "root");
mysql_select_db ("ejunic");
$search_term = $_POST ["search_term"];
$result_search = mysql_query ("SELECT publication FROM issn_vertify WHERE publication LIKE '%${search_term}%'");
echo $search_term;
$num = mysql_num_rows($result_search);
for ($i=0; $i<$num; $i++)
{
$row = mysql_fetch_array ($result_search);
echo "$i. Title:";
echo htmlspecialchars (stripslashes($row ["publication"]));
}