nasirr

by using this what it return in the option is just " mean there are two enteries in the table and its return " for both help me please

[code]<tr>       <?       echo "<td>";          $link = mysql_connect( "localhost", 'root', 'root' ); if ( ! $link ) die( "Couldn't connect to MySQL" ); mysql_select_db( 'project', $link ) or die ( "Couldn't open user: ".mysql_error() ); $sql="SELECT * FROM labels"; $result = mysql_query($sql);     echo "<select name=project>";        echo "<option value='1'>-Select Project-</option>"; while($nt=mysql_fetch_row($result))        { //echo "<option value=".$nt[id]."></option>"; echo "<option value=".$nt["id"].">".$nt["wht"]."</option>"; } echo "</select>"; ?> </td>[/code] what i m trying to do is that get the values from the database for a drop down menu and i got nothing there is only one option "select project" which is outside from the while statement of fetch intstruction please help me what is the problem with this code

I m nasir a student i got an assignment of making an activity monitor in which users have to fill the forms of their whole week activity they can save it edit it and submit to the manager. 1 one way is to do it with the mysql but in this form the user can add new rows and the users can add as many as row he/she want. e.g. for saturday user can add the e.g. 10 projects on which he worked. mean there can b many enteries for a day. and on the other hand when user submit his/her form to mananger , manager can reject it which can come back to the user again and again the process of editing starts. mean there can be at a time many pending rejected or even few aproved forms are available for the user . so i think i can not do it in mysql . please guys can u tell me another option to do this. waiting for an early reply