Collation trouble

[darylr]

Hi guys,

I've come into a problem with collation, which I previously had not encountered.

Im trying to select a record by a form field. On previous servers where I did not have a "collation" field in the MySQL database, the data would appear by the name selected. Now however, it does not appear - nothing appears when I use this code;

SELECT * FROM purhcases where name like '$name' ORDER by date DESC

Can anybody help me so that it will select the rows again?

Thanks,

Daryl

[subwayman]

Echo the query string to the page after constructing it to make sure it is what you expect.
e.g.

$query = "SELECT * FROM purhcases where name like '$name' ORDER by date DESC";
echo "$query<br>";

Also when using the LIKE clause you would normally use a wild card, e.g. %name%, meaning anyting with 'name' in it. If $name only contains a full name: $name= 'henry' then you will only get rows which the name collumn matches to 'henry'.