Photo Gallery

I have photo gallery with my mysql database. My page finds phots going by a category id in the sql table and displays a list of correct photos.

One feature I want to add to this is

1/ when a person clicks on a photo for a full size it adds it to a hit counter to later I can sort by best photo as well.

Cool.

So, uh...what's your question?

Quote:

---

Originally posted by The Hobo
Cool.

So, uh...what's your question?

---

What line of clode will I need to add to my showpicture.php?id=22

so that every time it's loaded it adds one to the photo counter....

Make a new field called 'count' as an integer in your MySQL table and add this function somewhere in your code.. Call it whenever the showpic.php is called with the ID of the picture passed in the parameters. If you're using $_GET['id'] like in your example of 'showpic.php?id=22' then call it like "updateCount($_GET['id']);'.

PHP Code:

---

function updateCount($id){
  $qry = mysql_query("UPDATE table SET count=count+1 WHERE id='$id' LIMIT 1");
} 


---

see how that works for you.. tweaking will probably be needed, too.

If you are using Gallery and not something you wrote yourself, then I think you will find more appropriate help at the Gallery Forum.