Execute multiple sql delete query in mysql for php

Question

For some reason, i want to delete some of records in my table using php mysql query function. Here's what i've write

$sql = "delete from progress where first_date='2010-01-01' and last_date='2010-01-31';
delete from progress where first_date='2010-02-01' and last_date='2010-02-28';
delete from progress where first_date='2010-03-01' and last_date='2010-02-31';
delete from progress where first_date='2010-04-01' and last_date='2010-02-30';
delete from progress where first_date='2010-05-01' and last_date='2010-02-31';";

if(!mysql_query($sql)) echo "Error deleting records";

Thats exactly what i get, "Error deleting records". However when itrace it using mysql_error() , its no use after all. Anyone know how to handle this? Thank's before

Change your final echo there to echo 'Error deleting records: ', mysql_error();, which will spit out the exact error that occured. Just saying "something happened" is of no use. — Marc B
– Marc B, Commented Jul 2, 2010 at 14:54

Naktibalda · Accepted Answer · 2010-07-02 10:33:17Z

6

mysql_query() can't execute multiple statements for security reasons.

use mysqli_multi_query() or call mysql_query() many times.

answered Jul 2, 2010 at 10:33

Naktibalda

14.2k5 gold badges37 silver badges53 bronze badges

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

1 Comment

Zein Miftah Over a year ago

yes i did using mysqli_multi_query but once i got error : 'command out of sync, you can't command now' or smiliar

BoltClock · Accepted Answer · 2010-07-02 10:33:15Z

3

You cannot send more than one SQL query at a time when using mysql_query(). That is why it's failing and returning false.

answered Jul 2, 2010 at 10:33

BoltClock

728k165 gold badges1.4k silver badges1.4k bronze badges

2 Comments

Zein Miftah Over a year ago

that's what i've tought before. It's strange beacuse when i use phpmyadmin everithing looks fine

BoltClock Over a year ago

I think it's because phpMyAdmin parses your SQL, splits statements by the given delimiter and runs mysql_query() once for each separate statement.

Ruyonga Dan · Accepted Answer · 2013-03-14 11:53:38Z

0

you can either create different variables for each query and then call the mysql_query for each variable created. i did it this way when i wanted to execute two queries to select and update at once.

answered Mar 14, 2013 at 11:53

Ruyonga Dan

6862 gold badges9 silver badges24 bronze badges

Comments

Rehmat · Accepted Answer · 2017-04-13 05:29:37Z

0

Why not combine all queries into one?

$sql = "DELETE FROM progress WHERE (first_date='2010-01-01' AND last_date='2010-01-31') OR (first_date='2010-02-01' AND last_date='2010-02-28') OR (first_date='2010-03-01' AND last_date='2010-02-31') OR (first_date='2010-04-01' AND last_date='2010-02-30') OR (first_date='2010-05-01' AND last_date='2010-02-31')";

answered Apr 13, 2017 at 5:29

Rehmat

2,3372 gold badges28 silver badges34 bronze badges

1 Comment

Zein Miftah Over a year ago

I will use PDO nowadays, not mysql_query. But your code might worked back then.

Collectives™ on Stack Overflow

Execute multiple sql delete query in mysql for php

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related