SQL error in DELETE function?

Question

Hi I'm getting this SQL error, and I'm not seeing what I'm doing wrong...

I'm getting:

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 '* FROM forums WHERE id=2' at line 1

Code:

$remove_forum = "DELETE * FROM forums WHERE id=$selected_option";
$run_remove_forum = mysql_query("$remove_forum") or die(mysql_error());

golimar · Accepted Answer · 2011-12-04 16:25:40Z

3

It's just DELETE FROM (* is for choosing columns and here you're not choosing any)

answered Dec 4, 2011 at 16:25

golimar

2,5881 gold badge24 silver badges37 bronze badges

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

Comments

Sergio · Accepted Answer · 2011-12-04 16:26:32Z

0

Shouldn't you remove the '*'? As far as I know on standard SQL it is not necessary...

answered Dec 4, 2011 at 16:26

Sergio

3031 gold badge3 silver badges8 bronze badges

Comments

MOHAMED FATHEI · Accepted Answer · 2011-12-04 16:27:52Z

0

remove * and use DELETE FROM forums WHERE id=$selected_option

answered Dec 4, 2011 at 16:27

MOHAMED FATHEI

4682 silver badges5 bronze badges

Comments

danicotra · Accepted Answer · 2011-12-04 16:29:08Z

0

WRONG SYNTAX

change

$remove_forum = "DELETE * FROM forums WHERE id=$selected_option";

with

$remove_forum = "DELETE FROM forums WHERE id=$selected_option";

Also I think you could do without quotes when you pass the variable to mysql_query (this way)

$run_remove_forum = mysql_query($remove_forum) or die(mysql_error());

answered Dec 4, 2011 at 16:29

danicotra

1,5292 gold badges18 silver badges35 bronze badges

Comments

Mohit Bumb · Accepted Answer · 2011-12-05 05:53:41Z

0

we can use * for only those queries which returns something like select query

answered Dec 5, 2011 at 5:53

Mohit Bumb

2,4935 gold badges33 silver badges54 bronze badges

1 Comment

Gabriel Santos Over a year ago

Will be fine if you can improve answer quality, with samples or more details which help solve the problem.

Collectives™ on Stack Overflow

SQL error in DELETE function?

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related