Dear Fellow PHPBuilder Members,
If any of you have a spare moment to devote to assisting me with the following I would be much appreciative!
Current database data:
WordForm - Number
aj - 10
ad - 12
âd - 63
âj - 34
SQL Query:
$sql = ("SELECT WordForm, Number FROM table WHERE WordForm LIKE 'a%' ORDER BY WordForm");
The $char is a value submitted from a previous pages' form with the following submit buttons: [a] and [â]
When a user hits the [a] button they see:
aj - 10
ad - 12
âd - 63
âj - 34
Which needs to only read:
aj - 10
ad - 12
effectivly excluding the:
âd - 63
âj - 34
Unless the user hits the [â] button instead of the [a] button.
Hope my plee for assistance is clear.
NOTE: you may wonder as to the funny characters.. this is becuase its a german dictionary project.
Update: I've also tried inserting the code for the â on the submit button as â and still no workie. Even using the literal key of "$" before doesn't work. Just listing things i've tried. Thanks again.
Not sure if this will help any but this project is an asp/access conversion to php/mysql. The access sql statement is:
"SELECT wordform, number FROM table WHERE left(wordform,1)='a' ORDER BY wordform;"
Which works just fine in displaying the 'a' and not the â
Update 2: I've tried changing the Collation to German1 and 2 for the tables and database as well... still nothing
