$var or '$var' in a sql if the field is an int ?

db mysql;

if ID is a field int or bigint

if in the query
.....
WHERE ID = '$var'

and $var= 10;

I can use write so '$var' or so $var (no '') ?
or there aren't difference?

or for security is better use '$var' and not $var also for numeric
field?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 18th November 07:56 nawfer External User Posts: 1	$var or '$var' in a sql if the field is an int ? db mysql; if ID is a field int or bigint if in the query ..... WHERE ID = '$var' and $var= 10; I can use write so '$var' or so $var (no '') ? or there aren't difference? or for security is better use '$var' and not $var also for numeric field?