getting MySQL error msg when Updating info in a database
Column was set to data type implicit default; NULL supplied for NOT NULL column 'adults' at row 1
thats what I am getting when i click submit button, it dont even go to the next page.
<tr>
<td bordercolor="#FFFFFF"><div align="right">Number of Adults: </div></td>
<td bordercolor="#FFFFFF"><select name="adults">
<option value="1" <?php if (!(strcmp(1, $row_rsBooking['adults']))) {echo "selected=\"selected\"";} ?>>1</option>
<option value="2" <?php if (!(strcmp(2, $row_rsBooking['adults']))) {echo "selected=\"selected\"";} ?>>2</option>
</select></td>
</tr>
<tr>
<td bordercolor="#FFFFFF"><div align="right">Number of Children: </div></td>
<td bordercolor="#FFFFFF"><select name="children">
<option value="0" <?php if (!(strcmp(0, $row_rsBooking['children']))) {echo "selected=\"selected\"";} ?>>0</option>
<option value="1" <?php if (!(strcmp(1, $row_rsBooking['children']))) {echo "selected=\"selected\"";} ?>>1</option>
<option value="2" <?php if (!(strcmp(2, $row_rsBooking['children']))) {echo "selected=\"selected\"";} ?>>2</option>
</select></td>
</tr>
Last edited by Igor Astakhov; March 13th, 2009 at 11:33 PM..
|