incrementing and replacing

[Anon]

i am trying to retrieve a integer from a db, increment it by one, then insert it back in, this is what i got. Weird thing is it works once for each recordset, but then never does it again.

<?php

$conn = mysql_connect("localhost", "", "");
mysql_select_db("planetloopdb", $conn);

$query = "SELECT ArticleHits FROM tblarticles WHERE id='$id'";
$result = mysql_query($query)
or die(mysql_error());
$result = mysql_num_fields($result);

$result = array_reverse($result);
$result = $result[9];

$result = ++$result;

$query = "UPDATE tblarticles SET ArticleHits='$result' WHERE id='$id'";
$result = mysql_query($query)
or die(mysql_errno() . mysql_error());
?>

any ideas?

[Anon]

oops.. that should be
$result = array_reverse($result);
$result = $result[0]

[Anon]

Your gonna run into scaling/table locking errors with code like that. Check out the docs for mysql.. you can actually increment feild values inside the sql statement... soething to the effect of:

UPDATE tblarticles SET ArticleHits=ArticleHits+1 WHERE id='$id'

my syntax may be a bit wrong but i know for a fact that you only need 1 query to do what you want to do rather than pullin all of the information out of the db and puttin it back in. I beleive if you look in the section 'Database preformance' or 'Speed of queries' in the mysql doc it will show you all types of cool stuff you can do with the query inoder to save time/money/code

-Jon

[Anon]

ahhh, that worked, didn't know you could do that. Thankyou very much. 🙂