CODEWITHSUNDEEP
phpmysql
pamela
pamela

Reputation: 11

how to pass int values in mysql query string?

here my code-

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

status is int type.
it is showing parse error.

Upvotes: 1

Views: 2108

Answers (3)

Crozin
Crozin

Reputation: 44376

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).

Upvotes: 0

miku
miku

Reputation: 188014

Have you tried?

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

Upvotes: 0

zed_0xff
zed_0xff

Reputation: 33217

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

Upvotes: 6

Related Questions