Database Query + Int Value

[obrienkev]

hi all,

When creating a database query should an int value be inside quotes??

e.g. $query = "SELECT * FROM tbl WHERE id = '$id' ";

Is the above the correct way or is this one correct...

$query = "SELECT * FROM tbl WHERE id = $id ";

id is stored as integer in database

thanks.

[MarkR]

No, it should not be in quotes.

MySQL however, will accept it in quotes and convert as necessary. If strict mode is on then it will generate an error if an invalid number is used.

Mark