WONT update row!!!

vent

can someone please tell whats wrong with this? no errors, but it doesn't do what its supposed to do!

<?
include("conf.php");

mysql_connect($host, $user, $password);
mysql_select_db($database) or die ("Unable to select database");

$query=mysql_query("UPDATE answer_count SET answer_count=answer count+1 WHERE aid='1'");

mysql_close();
?>

thanks in advance.

laserlight

um, are you literally substituting underscores where whitespace should be used?

vent

nah, there not there on the script. anything else?

laserlight

So basically your script is:

<?php
include("conf.php");

mysql_connect($host, $user, $password)
	OR die("Unable to connect to database server");
mysql_select_db($database)
	OR die ("Unable to select database");

$query = mysql_query("UPDATE answer_count SET answer_count=answer_count+1 WHERE aid='1'")
	OR die(mysql_error());

?>

Your table name is answer_count?

vent

DAMN EFFIN' cutin & pastin' those underscores where invisible characters whee the problem. if i hadn't a posted i would neve a known.

cheers.