javascript - data from db only post records on the first column -
i have table column has select type property. data coming database, when using fetch_array first row row retrieves records below script problem. query concerned after //for terminal
<div id='tab2' class='website_comops_3rd_shift'>// loop 3rd shift (1st) <table border='1' id='table_id' style='margin: 10px'; cellpadding='1' cellspacing='1' bordercolor='#333333' bgcolor='#c0ccd0' > // <tr> <th><font size='2' face='baskerville' id='systems'>systems</font></th> <th><font size='2' face='baskerville' id = 'schedule'>sched</font></th> <th><font size='2' face='baskerville' id='start_time'>start_time</font></th> <th><font size='2' face='baskerville' id='end_time'>end_time</font></th> <th><font size='2' face='baskerville' id='duration' class='c_duration'>*</font></th> <th><font size='2' face='baskerville'>ip</font></th> //<th><font size='2' face='baskerville'>done_by</font></th> <th><font size='2' face='baskerville' >remarks</font></th> </tr> <tr> <td><font size='2' color='red' face='baskerville'><b>3rd shift</b></font></td> </tr> while($row = mssql_fetch_array($website_comops_3rd_shift_1_result)) { <tr> <td><font size='1' face='baskerville'>" . $row['systems']."</font></td> <td><font size='1' face='baskerville'>" . $row['schedule']."</font></td> <td><input type = 'text' style='width: 130px' font size='1' face='baskerville' onclick='youclickstart()' class='start_time' id = '".$row['id']."' value = '". $row['start_time']."'> </input></td> <td><input type = 'text' disabled = 'disabled' style='width: 130px' font size='1' face='baskerville' onclick='youclickend()' class='end_time' id = '".$row['id']."' value = '". $row['end_time']."'> </input></td> <td><font size='2' face='baskerville'><b>" . $row['duration']."</b></font></td> //for terminal <td><select name='terminal' id = 'terminalid' class='termclass' > <option value= ''> </option> while($row = mssql_fetch_array($website_comops_terminal_result)) { <option value= '".$row['terminal']."'>".$row['terminal']."</option> } </select></td> <td><input type = 'text' style='width: 130px' font size='1' face='baskerville' class = 'remarks' id = '".$row['id']."' value = '". $row['remarks']."' title = '".$row['remarks']."'> </input></td> </tr> } //</tr> </table> </div>
Comments
Post a Comment