What's wrong with this Query?

Question

What's wrong with the following SQL query?

$sql="SELECT * FROM ".TABLE." WHERE desgid='$id', weightid='$weightid' AND deptid='$deptid' ";

The error message is:

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 ' weightid='12' AND deptid='31'' at line 1

Answer 1

SELECT * FROM ".TABLE." WHERE desgid='$id' AND weightid='$weightid' AND deptid='$deptid'
                                           ^

Answer 2

Try to change

WHERE desgid='$id', weightid='$weightid'

to

WHERE desgid='$id' AND weightid='$weightid'

and see.

Answer 3

There was not AND, try this:

$sql="SELECT * FROM ".TABLE." WHERE desgid='$id' and weightid='$weightid' AND deptid='$deptid' ";

Answer 4

It's the comma after the first where bit. Try

"SELECT * FROM ".TABLE." WHERE desgid='$id' AND weightid='$weightid' AND deptid='$deptid'"

Answer 5

You have a , in your SQL code after desgid='$id' try changing this to AND so your SQL code says:

$sql="SELECT * FROM ".TABLE." WHERE desgid='$id' AND weightid='$weightid' AND deptid='$deptid' ";

Answer 6

The comma is your problem:

desgid='$id', weightid =