whats wrong with this code it doesnt update
$count = $row[teller]; $countnew = $count + 1; $sql = "update homes set teller = '$countnew' where id = '$propnum' "; $result = mysql_query($sql,$link);
$count = $row["teller"];
Grisu
Hi,
Not sure (I always have trouble with string / number settings of PhP/MySQL, when to quote, when not..) but I think you need to loose the quotes around '$propnum' ?? Perhaps.. Is the counter col an integer? You are trying to store a string??
J.
The quotes in the SQL-query should not be a problem. I sometimes put automatically quotes around the values to make sure not to leave them out. If you try phpMyAdmin, it does the same. You only must not forget them for text.
