Need desperate help with school project!

I am currently trying to make an inventory that sorts out equipment, but I am having trouble with building a drop down list. The trouble is that I have no idea how to convert SJIS to EUC-JP when displaying the selection list. It just displays garbling.

The script I tried to use is:

$query = "SELECT DISTINCT category FROM equipmenttype ORDER BY category";
$query = mb_convert_encoding( $query, "SJIS", "EUC-JP");

$result = mysql_query($query)
or die ("Couldn't execute query.");



/* create form containing selection list */
echo "<form action='list.php' method='POST'>
<select name='category'>\n";

while ($row = mysql_fetch_array($result))
{
extract($row);

echo "<option value='$category'>$category\n";

}
echo "</select>\n";
echo "<input type='submit' value='検索する'>
</form>\n";


Can anyone help me?? Thanks!

What does your rendered HTML look like?
I trust you have values in your table?
You may want to add a closing OPTION tag... </option>
Why are you using mb_convert_encoding()?

I'm pasting your code below, as is, perhaps the forum's colour coding will show something odd.

Shot in the dark... does your database support SJIS?

I would still advise to remove that line altogether.