In the where clause it is necessary to compare two strings so that the equality condition is fulfilled without regard to punctuation marks, i.e. didnt either didnt or didnt.

this query needs to be redone so that it compares $_POST["name"] and the textUS field, not including the punctuation marks mysql_query('SELECT * FROM les WHERE textUS= "'.$_POST["name"].'"',$conn);

    1 answer 1

    Probably you can somehow (the necessary signs how to add I think guess):

     where LOWER(REPLACE('yourstr',"'","")) = LOWER(REPLACE(field,"'",""))
    • and line 2 where to enter? You can read more - vasa777
    • Um ... Do you need to compare php code or php? If php read the search engine for the query "working with php strings". You can read more about regexps. The general idea is simple - you need to normalize two lines, so as to eliminate the difference. - Chad
    • Have you got a bugtracker here? :-) draw conclusions about the values ​​of 'yourstr' and field ... - Chad