Delete function throwing mySQL error

Question

Im having trouble trying to find out why my script wont delete a row in my table.

Each user has a randomkey assigned to them. I need to say delete row in table where random key equals that to the user...

<?php 

$userRand = $_GET['Rand'];

$delUser = mysql_query("DELETE from users WHERE randomkey = '" . mysql_real_escape_string($userRand));
        if(! $qResult )
            {
                die('Could not delete data: ' . mysql_error());
            }
        elseif($qResult )
            {
                echo "deleted"; 
            }

?>

the following outputs...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''111111111' at line 1

not related completly, but for a delete operation you should use POST and not GET. this will prevent some problems (like an image with this script in the url) — regilero
– regilero, Commented Jul 17, 2011 at 19:56

Mat · Accepted Answer · 2011-07-17 19:45:47Z

2

You're missing the closing ' in your PHP code.

$delUser = mysql_query("DELETE from users WHERE randomkey = '" . mysql_real_escape_string($userRand) . "'");

answered Jul 17, 2011 at 19:45

Mat

208k41 gold badges407 silver badges423 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

halfdan · Accepted Answer · 2011-07-17 19:46:52Z

1

You are not closing the SQL-String.

$delUser = mysql_query(
    sprintf("DELETE from users WHERE randomkey = '%d'", mysql_real_escape_string($userRand)
);

answered Jul 17, 2011 at 19:46

halfdan

34.3k8 gold badges83 silver badges88 bronze badges

Collectives™ on Stack Overflow

Delete function throwing mySQL error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related