syntax error, unexpected 'order' (T_STRING)

Question

I put this code in my php file and it gives me the error syntax error, unexpected 'order' (T_STRING)

What am I doing wrong?

$sqldelreq="DELETE FROM `requests` WHERE tablecode = 1 and type = "order"";
        $result2=mysql_query($sqldelreq);
            if($result2)
            {
                header("Location: http://localhost/mjjapp/index.php");
            }

simply wow. http://www.w3schools.com/php/php_mysql_delete.asp — Red Acid, Sep 21 '15 at 08:32

score 2 · Answer 1 · edited Sep 21 '15 at 15:27

2

I think the query should be:

"DELETE FROM `requests` WHERE tablecode = 1 and type = 'order'";

Please note the single quotes around order.

edited Sep 21 '15 at 15:27

Hanky Panky

46,730
8
72
95

answered Sep 21 '15 at 08:19

Nikos

3,267
1
25
32

I am sorry I edited this answer for almost nothing. I gave you a down-vote earlier tonight considering your answer wrong when it was in fact in correct. When I realized it it was too late to retract my down-vote. After a few hours of feeling guilty when i just saw it i retracted my down-vote. – Hanky Panky Sep 21 '15 at 15:28
Hahah, no worries! I accept your apology but feel bad for your feeling guilty :) It's only stackoverflow :) Take care :) – Nikos Sep 21 '15 at 15:29

score 0 · Answer 2 · answered Sep 21 '15 at 08:24

You should do proper escape

 $sqldelreq = "DELETE FROM `requests` WHERE `tablecode` = 1 and `type` = 'order'";

Also your if is invalid. It only means that query was successful if you wan't to check if any rows were deleted you need to check how many rows were affected with mysql_affected_rows() function.

Moreover, consider using mysqli or pdo. Mysql_* functions are deprecated.

score 0 · Answer 3 · answered Sep 21 '15 at 08:26

0

Correct syntax usually goes a long way; try:

$sqldelreq = "DELETE FROM `requests` WHERE `tablecode` = 1 AND `type` = 'order';";

answered Sep 21 '15 at 08:26

foxbeefly

510
3
13

score 0 · Accepted Answer · answered Sep 21 '15 at 08:31

0

i found this running well thanks guys for ideas

$sqldelreq="DELETE FROM requests WHERE tablecode = 1 and type = 'order';";

answered Sep 21 '15 at 08:31

jeiidii

87
1
10

syntax error, unexpected 'order' (T_STRING)

4 Answers4