Does anyone know if there is a way to be able to update just one field from just one record without having to reupdate the entire column? The only way I know how to update a field is like this:
mysql_query("UPDATE $db_table SET template=$template WHERE user=$user");
But I noticed in my database column "template" it updated the appropriate record with the the correct value, but for all my other records, it reset that column to 0 for all of them, which is the default value. It doesn't make sense that you would have to repopulate the column with the current values each time you want to update just one. So would anyone be able to help me out here? I appreciate it!
Erik
mysql_query("UPDATE $db_table SET template=$template WHERE user=$user");
But I noticed in my database column "template" it updated the appropriate record with the the correct value, but for all my other records, it reset that column to 0 for all of them, which is the default value. It doesn't make sense that you would have to repopulate the column with the current values each time you want to update just one. So would anyone be able to help me out here? I appreciate it!
Erik