Limiting checkboxes?

Posted on 16th Feb 2014 07:03 pm by admin

Hi guys,

I have this code: Code: if(isset($_POST['selected'])) {
foreach($_POST['selected'] as $item) {
$sql = "SELECT * FROM tablename WHERE ID=$item";
mysql_query($sql) or trigger_error("SQL: $sql, ERROR: " . mysql_error(), E_USER_ERROR);
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
if ($num_rows>6) {
echo ("Too many checkboxes were selected");
}
else

while ($db_field = mysql_fetch_assoc($result)) {

echo "stuff that is ok if number of checkboxes is correct";
}
}
}

I am trying to limit the number of checkboxes that were selected, to say a max of 6. If the user selected any more than 6 a message should appear saying too many checkboxes were selected.

Can anyone see where i went wrong?

Cheers for any help fellas...

Your Answer:

Login to answer

Other forums

paginate search result
Hi, I have a paginations script to display data from my database but i would like to paginate someon

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t

error with opendir
when i do this

if ($handle = opendir($dir)) {
while (false !== ($file = readdir($han

Sufficient protection from bad input?
I am writing a simple script to let people upload 'pages' of their own content, be it simply a few b

Parse Error with doctype
I'm getting a parse error with this simple code. I don't get it. It worked one time then when I relo

Image loading
Hi Developers,

I'm trying to display an image from images/image.gif getting the url from mysq

Problem with an browser game.
Hello,i just joined that great forum and i got php prob,its kinda freaky...anyway i got browser game

Problems with strings containing
Hey all,

I have encountered something strange in a script. I am trying to write an XML heade

how can i expire the submitted page using session.
hi,
i'm new to php world.
i'm using "post" method.
when i submit it,data goes to

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to