Hello there, hope someone can tell me how i can fix this

Table Create:

PHP Code:

CREATE TABLE IF NOT EXISTS `trafficEx` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `url` varchar(150) NOT NULL,
  `in` int(11) NOT NULL DEFAULT '0',
  `out` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`)
) AUTO_INCREMENT=1 ; 


Php Code:

PHP Code:

mysql_query("update trafficEx set in=in+1 where url='$result[0]'") or die(mysql_error()); 


when i try to run this command he give me MySql error ... can someone please help me with this ... (he dont make update to in or out but if i try to make update to title works)

and the error is??

what does the query look like as it is sent to the MySql server?

IN is a reserved word in mysql. You'll have to refer to the table as `in` or trafficEx.in. Better yet, don't name your column in.

Try this query:

mysql_query("update trafficEx set in=in+1 where url='".$result[0]."'") or die(mysql_error());

And NP is right, don't name a column 'in', I think it's a keyword

Your query looks ok, if you get any error post it to see what happen.

Note: try to use other field name not 'in' because this word used by mysql.