bory,

You are making a number of crucial mistakes. Firstly you are directly placing variables into your prepare string. Use placeholders instead then the DBI/DBD will take care of escaping for you. You haven't fully worked out the SQL you need and until you do it is likely you will have some pretty awful problems!

First step is to check the tutorials on this site. You are making errors and using a coding style which is well discussed in several tutorials. Either go to www.mysql.com and carefully read the documentation there or go out and buy a good MySQL or SQL book.

You also have a similar quoting problem in building the checkboxes. I would suggest using CGI.pm to create them, which will, again, removing the quoting difficulties.

And remember - ONE WORD for me please - PLACEHOLDERS

jdtoronto

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.