what's wrong?

[obscurr]

I'm trying to fetch some data from my mssql database, and display it in a select box. But it just doesn't work! anyone knows why? the query is correct though.. the code:

<form METHOD=POST ACTION="<?php print("$PHP_SELF"); ?>"><select NAME=messe[]" SIZE=3>
<?php $query = "SELECT stuff FROM messe where type = 1";
$result = mysql_query($querysteder);
while ($messe = mysql_fetch_array($result)) {
echo "<OPTION VALUE=\"$messe[0]\">$messe[1]\n";
}

echo "</SELECT></FORM><br>";

an empty selectbox appears....

obscurr

[leatherback]

When you place your query, make sure you call the actual query:

$query = "SELECT stuff FROM messe where type = 1"; 
$result = mysql_query($query);

while ($messe = mysql_fetch_array($result ) )

  { 
echo "<OPTION VALUE=\"$messe[0]\">$messe[1]\n";
      }

[obscurr]

sorry, wrong code entered. This is the correct one, and I'm pretty sure I'm using the actual query :
<form METHOD=POST ACTION="<?php print("$PHP_SELF"); ?>"><select NAME=messe[]" SIZE=3>
<?php
$querysteder = "SELECT sted FROM messe where type = 1";
$resultsteder = mysql_query($querysteder);
while ($messe = mysql_fetch_array($resultsteder)) {
echo "<OPTION VALUE=\"$messe[0]\">$messe[1]\n";
}
echo "</SELECT></FORM><br>";

[xblue]

assuming this is your actual code now, you seem to be selecting one column (sted) only, thus $messe[1] would not be set. should be easy to detect when looking at the html source code.

if that's not it, you should probably add some debugging code, e.g. printing the query and check how many records it returns.