<?
...
// get the information for this vehicle
$result = mysql_db_query($dbname, "SELECT * FROM vehicle_inventory WHERE ccode='$ccode'", $link);
$data = mysql_fetch_array($result);
$data[comments] = nl2br($data[comments]);
// 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);
...?>
bastien
From: Stuart Felenstein <[EMAIL PROTECTED]> To: Bastien Koert <[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 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 ? Meaning, was it in a seperate script / page or was it part of a bigger query that first got the results based on certain criteria , the did the update?
Stuart
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php