no output.. why? help!!

[phence]

I am trying to pull data from a database into a listbox...
I am not getting any output inside the listbox!?

	$query = "SELECT * FROM categories WHERE Parent = 'NULL'";
	?><SELECT name="categories" size="20" multiple>
	<?php
	if (($result = @ mysql_query ($query, $connection))){
    	while ($category = mysql_fetch_array($result)){
  			?>
			 <option name="<?php echo $category['ID']; ?>"><?php echo $category['Name']; ?></option>
			<?php
		}
	}         

	else
         showerror();
	?>
	</select>

Can anyone tell me y?
thank-you!

[rupertbj]

change your code to read like this:

 <?php
if ( ( $result = @ mysql_query ($query, $connection) ) )
     {
     while ( $category = mysql_fetch_array($result) )
          {
print "option name=\"<?php echo $category['Name']; </option>\" ";
          }
     }         

else
showerror();
?>

Then the user can select the correct one from the list.

[phence]

huh?! did u leave somthing out?... getting a parce error.

[phence]

Nevermind... im stupid!!

had to change

$query = "SELECT * FROM categories WHERE Parent = 'NULL'";

to

$query = "SELECT * FROM categories WHERE Parent IS NULL";