Nu heb ik twee tabellen met rijen:
lv_episodes
ep_id
rating
num_votes
rate
lv_voted_ip
id
ep_id
rate
ip
Deze code gebruik ik om de valse stemmen (die ik aangevinkt heb) te verwijderen uit lv_voted_ip
$id = $_GET['id'];
if($_SERVER['REQUEST_METHOD'] == "POST")
{
// Bestaat het id veld in de POST data?
if (isset($_POST['id']))
{
foreach($_POST['id'] as $iID)
{
$sWhere = implode(',',$_POST['id']);
$sQuery = "DELETE FROM lv_voted_ep WHERE id IN(".$sWhere.")";
if (!mysql_query($sQuery))
{
echo 'Query failed:'.$sQuery.'<BR>'.mysql_error();
}
}
}
else
{
echo "No votes selected";
}
echo "You've successfully deleted the selected votes";
}
else
{
$sql2 = "SELECT id,ep_id,rate,ip FROM lv_voted_ip ORDER BY ip,ep_id ASC";
//sql code om de gegevens op te halen
$query2 = mysql_query($sql2);
//sql code uitvoeren
$count = mysql_num_rows($query2);
if ($count !== 0){
echo "<table width=\"100%\">\n";
echo "<form action='rating.php?a=show' method='post'>\n";
while($aRow = mysql_fetch_assoc($query2))
{
echo "<tr>\n<td width='10%'><input type='checkbox' name='id[]' value='".$aRow['id']."'/>\n</td><td>".$aRow['ip']."</td><td width='10%'>".$aRow['rate']."</td>\n</tr>\n";
}
echo "<tr>\n<td> </td>\n<td>\n<input type='submit' name='delete' value=' Delete Checked Votes '>\n</td>\n</tr>\n</form>\n</table>";
}
echo "No votes available<br />";
}Maar de stem moet ook uit lv_episodes verwijderd worden.
Dus dit moet gebeuren per verwijderde stem:
rating(lv_episodes) - rate(lv_voted) = nieuwe rating
num_votes(lv_episodes) - 1 = nieuwe num_votes
nieuwe rating/nieuw num_votes = rate(lv_episodes)
Weet iemand hoe ik dat makkelijk in de bovenstaande code kan toevoegen?