Case sensitive....

[Frank Neergaard]

Hello

Im trying to support more languages by making 2 tables like this:

language_control:
id,
php (Program using...)
bracket (name of the text)
language

language_words:
bracket (primary index)
language (secondary index)
description

By doing so I can maintain texts in an easy way. Everything is fine except for a case sensitive error in the following code:

$qid = new PGM_Sql();
$qid->query("
SELECT language_words.bracket, language_words.description FROM language_words
JOIN language_control ON language_words.language=language_control.language AND language_words.bracket=language_control.bracket
WHERE language_control.php='$p1' AND language_control.language='$language'
");
while ($qid->next_record()) {
$t_data[$qid->f("bracket")] = $qid->f("description");
// echo "<br><div>", $qid->f("bracket"); //, "---", $qid->f("description");
}

On occasions I get an errors like this! When a program ask for "contact" it gets
"Contact".

What can I do? Will it help if I change the indextype to UNIQUE?

Frank