PHP MySQL API Can't Drop Table

Question

I am trying to drop a table with php. I have been working with php for a couple of months now, and don't see why I am getting an error. Sample Code:

include 'SQLaccount.php';
$sql = "DROP TABLE RequestBooks;";
if (!$accountCon->query("SET a=1")) {
    printf("Errormessage: %s\n <br> SQL: %s", $accountCon->error , $sql);
}
$accountCon->close();

And this is the error:

Errormessage: Unknown system variable 'a' //What I get when I run theabove code
SQL: DROP TABLE RequestBooks;

I can drop the table from PHPMyAdmin, and the user I am using has all permissions granted. I use this same query setup for all of my mysql needs, with no problem.

Edit 1:

I was running a query on SET a=1 and not $sql.

include 'SQLaccount.php';
$sql = "DROP TABLE RequestBooks;";
if (!$accountCon->query(**$sql**)) {
    printf("Errormessage: %s\n <br> SQL: %s", $accountCon->error , $sql);
}
$accountCon->close();

Thanks for your help.

We will assume you meant ->query($sql) ... nothing to see here — Mindeater
– Mindeater, Commented Jun 12, 2014 at 4:59
If you are really trying to drop the table, shouldn't if (!$accountCon->query("SET a=1")) be if (!$accountCon->query($sql))?? — Sean
– Sean, Commented Jun 12, 2014 at 5:00

hsz · Accepted Answer · 2014-06-12 11:55:31Z

2

Try this

include 'SQLaccount.php';
$sql = "DROP TABLE RequestBooks;";
if (!$accountCon->query($sql)) {
    printf("Errormessage: %s\n <br> SQL: %s", $accountCon->error, $sql);
}
$accountCon->close();

edited Jun 12, 2014 at 11:55

hsz

153k63 gold badges268 silver badges320 bronze badges

answered Jun 12, 2014 at 5:04

Gabber

7,2593 gold badges35 silver badges47 bronze badges

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

1 Comment

Alex Pelletier Over a year ago

Thanks man. I don't know how I missed that when I was going through it.

Collectives™ on Stack Overflow

PHP MySQL API Can't Drop Table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related