RE: [PHP-DB] Updating count on record results
| From: | Bastien Koert | Date: | Fri, 19 Nov 2004 15:36:11 +0000 |
| Subject: | RE: [PHP-DB] Updating count on record results | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37359@lists.php.net to get a copy of this message | ||
its a separate query on the same page, its activated after the data retreival query runs.
<?
...
// 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 <stuart4m@yahoo.com> To: Bastien Koert <bastien_k@hotmail.com>, php-db@lists.php.net Subject: RE: [PHP-DB] Updating count on record results Date: Fri, 19 Nov 2004 07:28:48 -0800 (PST) --- Bastien Koert <bastien_k@hotmail.com> 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