Error with query in mysql database

Question

Can't I use double condition in where clause in query. LIke I have used query..

 mysql_query("DELETE * FROM srelsg WHERE skey='".$childid."' AND sgkey='".$sgid."' ") or die(mysql_error());

but its giving me syntax error. Might be I am using double variables in WHERE for delete query. Any other solution I can do it. Because combination of both variable make my tupple unique. else both field exist number of times.

Mark Byers · Accepted Answer · 2011-10-11 17:23:49Z

6

There should not be a * between DELETE and FROM. Change this:

DELETE * FROM srelsg WHERE ...

To this:

DELETE FROM srelsg WHERE ...

See the DELETE syntax in the MySQL manual.

answered Oct 11, 2011 at 17:23

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

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

Comments

Ed Heal · Accepted Answer · 2011-10-11 17:26:42Z

0

In addtion to Mark Byers - use mysql_real_escape_string

http://php.net/manual/en/function.mysql-real-escape-string.php

answered Oct 11, 2011 at 17:26

Ed Heal

60.3k18 gold badges91 silver badges137 bronze badges

Collectives™ on Stack Overflow

Error with query in mysql database

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