times viewed

[tuf-web_co_uk]

i have a pag which is the index for animations and he display page for animations - here

and i wanted next to the title of the animation to display how many times it has been viewed

can anyone please help me....
i know this is a really easy task

thanks in advance...much appreciated 🙂

[cgraz]

Well when you clikc one of the animations, your url looks something like this: index.php?id=6

How I would do this is make a field in a mysql db called viewed with a default value of 0, then everytime the page is loaded, you add 1 to it.

$query = mysql_query("UPDATE table SET viewed='viewed + 1' WHERE id='" . $_GET["id"] . "'") or die(mysql_error());

Then to display how many times it was viewed, you select the field viewed from your db where the id equals the id in the db, then display.

$query = mysql_query("SELECT viewed FROM your_table WHERE id='" . $_GET["id"] . "'") or die(mysql_error());

$row = mysql_fetch_assoc($query);

echo "This animation has been viewed " . $row["viewed"] . " times";

Cgraz

[tuf-web_co_uk]

right i understand that perfectly and i have put it in my page, but it doesnt seem to show a number

the page is here - the page

and in the database the number stays at 0

the code to display a animation which has the code to also add 1 to the number of times viewed is this....

 echo "<table width=350><tr><td>";
  $query = mysql_query("UPDATE anim SET viewed='viewed + 1' WHERE id='" . $_GET["id"] . "'") or die(mysql_error());
  while ( $row = mysql_fetch_array($result) ) {    

  echo ("<P><font size=1 face=Verdana color=#000080><b>");
  echo "Animation : ".$row[anim]."<br><br>";
  echo "<embed src=".$row[src]." height=".$row[height]." width=".$row[width]."></embed><br><br>";
  echo "Creator : <a href=index.php?creator=".$row[creator].">".$row[creator]."</a><br><br>";
    }
  echo "<p align=left><font size=1 face=Verdana color=#000080><a href=index.php>back to main page</a>";
  echo "</td></tr></table>";

please could you help me further?!

[tuf-web_co_uk]

i also found out how to make it show the numbers, it was because we were trying to load it from a variable, when it was need to get from an array.

i still cant make it show a number past 0 though

[cgraz]

It's still at 0? Well the query looks fine, the only thing I could think of is you're on an older version of PHP, therefore $_GET has no value.

If that's the case, try echoing $_GET["id"] just before you run your query and see if it prints the id that's in the url to the page.

If it doesn't, you'll need to change it to $HTTP_GET_VARS["id"].

Cgraz

[tuf-web_co_uk]

hey i tried echoing $_GET that worked, so i must have the new version.

but it still isnt going past 0 in the database.

will it have something to do with the table?!
i have more than one field in.
or will it be data type?!

i'm confused 😕

anymore help please?!

[cahva]

Well, I see the problem. In the $query you have put the viewed='viewed +1'. Just get those quotes off and it should work.

$query = mysql_query("UPDATE anim SET viewed=viewed+1 WHERE id='" . $_GET["id"] . "'") or die(mysql_error());

[tuf-web_co_uk]

thanks very very much both of you

cahva and cgraz much appreciated!!

😃 😉

the working page is here - animations working page working thanks to u 2 🙂