I have a page where I display info on 16 players (I'm running a fantasy
football league and trying to have everything automated) This info comes
from a DB. The info is displayed like this in an html table.
<TR BGCOLOR=#7DEDF7>
<TD class=constant align="center">4</TD>
<TD class=constant align="center">QB</TD>
<TD class=constant align="center"> Kurt Warner</TD>
<TD class=constant align="center">STL</TD>
<TD class=constant align="center"><input type="checkbox"
name="player" value="2">
<input type="hidden" name="postion" value="1">
<input type="hidden" name="team" value="1">
<input type="hidden" name="week" value="4">
</TD>
</TR>
now there is 16 of these. I need to insert only the ones are checked
which will be 8 players. How can I insert these into my DB, I keep
getting a numeric value out of range error message so I'm guessing it's
trying to grab all the form values in my page and insert them into one
line in my DB, I need to have it so Player one info will be inserted
into 4 columns, then player 2 will be inserted into the next row of
columns etc.. I hope I explained this ok. Thanks for any help someone
may offer.
Ben Densmore
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
