how to pass int values in mysql query string?

Question

here my code-

$sqlpin = "SELECT pinId FROM tblpin WHERE pinId = '$pin_no', status = 0 ";

status is int type.
it is showing parse error.

Answer 1

SELECT pinId FROM tblpin WHERE pinId = '$pin_no' AND status = 0

Answer 2

Have you tried?

$sqlpin = "SELECT pinId FROM tblpin WHERE pinId = '$pin_no' and status = 0 ";

Answer 3

Syntax error is caused by comma in WHERE clause. You should use AND logical operator to connect these two conditions.

btw: If some column has numeric type don't pass values with apostrophes, just: colName = 123. Only text values requires apostrophes/quotes (in MySQL both has exactly the same meaning).