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

[Bastien Koert]

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 <[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