displaying information as a percentage?

I am attempting to display information submitted to a database byway of checkboxes, as a percentage of the rows within that database.

So for example; if a checkbox for ‘Group1’ was ticked once while submitting 4 separate entries to the database, ‘Group1’ would then be displayed as 25% of that database.

Does anyone know how I would submit this information to the database via checkboxes and inturn, display that information as a percentage of that database?

I have managed to submit the information to the database.
But my query for extracting it as a percentage is constantly displayed as a error message.

:(

Simpler to query for the totals of each 'group' and then do the calculations via php on the results. The simpler your query, the faster are your results.

That's my 2 cents :^{>

Can you post your PHP code that is giving you the errors?

It shouldn't be too hard to do what you need.

Cheers

Thanks for the response.

The following is the checkbox code for my php form which submits the information to the database fine:
...,

</tr>
<tr>
<td><p><b>Mentoring and Coaching:</b></p></td>
<td><p><input type="checkbox" name="mc1" value="1">
<?php if (isset($_POST['mc1'])) echo $_POST['mc1']; ?></p></td>
</tr>
<tr>
<td><p><b>Accredited Training for Staff:</b></p></td>
<td><p><input type="checkbox" name="sat2" value="1">
<?php if (isset($_POST['sat2'])) echo $_POST['sat2']; ?></p></td>
</tr>
<tr>
<td><p><b>Classroom Based Training:</b></p></td>
<td><p><input type="checkbox" name="cbr3" value="1">
<?php if (isset($_POST['cbr3'])) echo $_POST['cbr3']; ?></p></td>
</tr>
<tr>
<td><p><b>Development and Delivery of Training:</b></p></td>
<td><p><input type="checkbox" name="ddt4" value="1">
<?php if (isset($_POST['ddt4'])) echo $_POST['ddt4']; ?></p></td>
</tr>
<tr>

...,

My query for extracting the code as a percentage of the database is:

$query = "(SELECT * FROM yourl_titles ORDER BY Rand()*1/percentage)LIMIT 1)";

The message I receive is 'Couldn't execute query'

???????

If you cut 'n paste this line, you're missing a left parenthesis or have an unneeded right one

If you want to select using MySQL you have to so something like

Code: Select all

SELECT RAND()*1/percentage AS number FROM yourl_titles

But I don't actually understand what you want from the database....or what rows there are..

If you want to display as a total using PHP, you need to use something like

PHP: Select all

$result = mysql_query("SELECT * FROM yourl_titles");

$numbers = array();

while ($row = mysql_fetch_enum($result))

    $numbers[] = $row['whatevertherownamesare']





$total = array_sum($numbers);



foreach ($numbers as $number)

   echo  ($number/$total*100), '%<br />';