Having trouble updating MySQL databse

[Naits]

I have this:
#
# Table structure for table 'browser'
#

CREATE TABLE browser (
id int(11) DEFAULT '0' NOT NULL,
type varchar(150) NOT NULL,
count int(11) DEFAULT '0' NOT NULL
);

Im trying to update it with this query:

$sql = "UPDATE browser SET count = count + 1 WHERE type = $browser";

FAIL's! But thi query works:

$sql = "UPDATE browser SET count = count + 1 WHERE id = 0";

Why can't I use the first one? I realy need it to work...

 

[KarveR]

$sql = "UPDATE browser SET count = count + 1 WHERE type = '$browser'"; - note the addded single quotes
______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[Naits]

Thanks!

 

[sonnysavage]

Or, using a slightly different coding style:

$sql = "UPDATE browser SET count = count + 1 WHERE type = '".$browser."';";

I personally like to use the '.' when putting variable values in a string, but... it's just my personal preference.