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

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

SESSION CHECK WORKS "MOST" of the time... whats going on?
i have a sign in check thats included in every page that is a members only page which is basically a

How to find OS bit version
How can I tell the person browsing my site is running 32, or 64 bit operating system?

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

phpMailer will not connect using SMTP
I am trying to use phpMailer with smtp:

Code: [Select]$mailer = new PHPMailer();
$mailer-&

Rounding a number queried from a database
I know that to display a rounded number you just do echo "round($number)";. But how would

Problem in back link
I have page where i have given javascript back link but when i click on it browser give a message

How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<

IP Based Cron Jobs
I run cronjobs on my website. After one of my visitors got curious and tinkered around he realized h

Turning Data into URLs?
This may seem very basic to you, but I'm having a hard time figuring out how to do this since I don'