displaying information as a percentage?

[ziggi]

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.

:(

[maspick]

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 :^{>

[Rakuli]

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

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

Cheers

[ziggi]

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'

???????

[maspick]

Originally Posted by ziggi

$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

[Rakuli]

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 />';