RE: [PHP-DB] Updating count on record results

2004-11-19 Thread Bastien Koert
rt <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: [PHP-DB] Updating count on record results Date: Fri, 19 Nov 2004 07:28:48 -0800 (PST) --- Bastien Koert <[EMAIL PROTECTED]> wrote: > this is how I did it for a client's site > > // update the number of times the ve

RE: [PHP-DB] Updating count on record results

2004-11-19 Thread Stuart Felenstein
--- Bastien Koert <[EMAIL PROTECTED]> wrote: > this is how I did it for a client's site > > // update the number of times the vehicle has been > viewed > mysql_db_query($dbname, "UPDATE vehicle_inventory > SET viewed=viewed+1 WHERE > ccode='$ccode'", $link); > Where did this code go though ? M

RE: [PHP-DB] Updating count on record results

2004-11-19 Thread Bastien Koert
AIL PROTECTED] Subject: [PHP-DB] Updating count on record results Date: Fri, 19 Nov 2004 04:59:20 -0800 (PST) I am setting up a table to log a count on individual records for every time they are returned in a results return. Just so to illustrate Record1 First search brings up Record1 (counter is set

[PHP-DB] Updating count on record results

2004-11-19 Thread Stuart Felenstein
I am setting up a table to log a count on individual records for every time they are returned in a results return. Just so to illustrate Record1 First search brings up Record1 (counter is set too 1) Second search brings up Record1 (counter is set too 2) Third search brings up Record1 (counter