<select> boxes in upload console

[Trippin]

Hi

l was digging everywhere but can't find usefull and simple code that shows me how to populate select box via php and Mysql DB. Basically I am making a small upload console for users so they have a select box that pulls out of the database the list of the folders user has created on the server .... there he picks which pics to upload to that folder and submits ... simple as that .. so first how it works once user logs in (the default upload places files in the root of their personal directory but.. I want to get user to use that select box to view all subfolders inside their own root and user can then upload images to each one depending what selection in box is made instead of uploading to their root. At the moment I have a DB table called 'folders' and php needs to pull that data matching all folders under currently logged user ID and put them in a select box. Hope someone can help because I know how it should work in theory but I can't get the code right.

Cheers

[nemonoman]

Why don't you post your broken code so we can help you fix it.

[Trippin]

here is the code but I keep getting warnings....

<?php

$options = '';
$query= mysql_query("SELECT foldername FROM folders WHERE userid ='$user_name'");
while($results=mysql_fetch_array($query))
{
$options .= '<option value="'.$results['folderid'].'">'.$results['foldername'].'</option>';
}
?>

I get
-->> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

any ideas?