getting MySQL error msg when Updating info in a database

Igor Astakhov · March 13th, 2009, 05:13 PM

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>

Igor Astakhov · March 13th, 2009, 06:03 PM

i figured out that it has something to do with the "adults" menu and "children" menu for some reason the data from the database is not entering the menus i cant put my finger on it why specifically its not catching it. ive tried changing the code in different ways and yet still nothing.... any suggestions why it doesnt recieve the data from the db?

BLah figured it out for somereason when you use dynamic data in dreamweaver to insert values into menus with integers it doesnt put the values in so therefor you have to go and edit the code manually and put the correct values in like mine that i edited above, ill outline it