On Wednesday 23 March 2005 20:00, Chip Wiegand wrote: > count=count+1; <--- This is the added bit ---> > ?> > ----------------------------------------------- > The count doesn't increment in the database. The table has a column called > 'count'. > Two things: variables start with a $ and the variable count in your example does not... this means error!, change the count to $count
2nd, You should update your table like this: mysql_query("UPDATE `manuals_list` SET `count`='$count' WHERE ...selection here... LIMIT 1;"); Also, I see that you are ignoring mysql security! Please think about sql injection attacks. You should use the mysql_escape_string function on any and all user inputed values, use backticks to delimit database/table/field names, and quotes to delimit values. > Can someone please please point me in the right direction? > Thanks, http://dev.mysql.com/doc/mysql/ Andy -- Registered Linux User Number 379093 -- Feel free to check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ --
pgpVeoCP0qrd6.pgp
Description: PGP signature