Why this php code not work?

[Chris2k]

<?php

    $siturl = $_POST['burl'];
    $removee = $_POST['doit'];
    
    if (isset($removee)) {
        mysql_query("DELETE FROM wcddl_blacklist WHERE url = '.$siteurl.'");
    }
?>

Any1 know why as iv tried n tried but its not working..

Chris2k Reviewed by Chris2k on 25th Nov 2011. Why this php code not work? <?php $siturl = $_POST; $removee = $_POST; if (isset($removee)) { mysql_query("DELETE FROM wcddl_blacklist WHERE url = '.$siteurl.'"); } ?> Rating: 5

[Rox]

dont know php but, i see a spelling mistake there siteurl is spelt as siturl

[zdorian]

add DB connection to the mysql_query()

[Chris2k]

Cheers Rox, fixed loool ima dumb fuck

[Rox]

[Gavo]

Escape the query

if (isset($_POST['burl']) && isset($_POST['doit'])) {
 $siteurl = mysql_real_escape_string($_POST['burl']); 
 mysql_query("DELETE FROM wcddl_blacklist WHERE url = '.$siteurl.'"); 
 } 
?> 

[Chris2k]

Thx Gav0