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'
???????