[SOLVED] Views...

[Aureole]

I'm trying to add views to my news so it shows how many time a story has been read but I have no idea where to begin, what's the best way to approach this?

[Caesar]

<?php

$db->query("UPDATE `topic` SET views=views+1 WHERE id = '$topicid'");

?>

[Aureole]

I didn't think it would be that simple...thanks a lot I'll try it out.

[Aureole]

This isn't working, at the moment my query is looking like this:

 

$query = "UPDATE news SET views=views+1 WHERE id='$theid'";

$query = "SELECT title, views, full, author, authorid, cat, id, date_format(date, '%a %D %b %Y %H:%i') as prettydate FROM news WHERE id='$theid'";

 

What's up with it?

[Aureole]

Do I need to put the two queries into one...somehow...from the looks of it to me I can't and they need to be seperate, but...

 

[sorry for triple post] I didn't realize...

[AndyB]

What's up with it?

 

You need to execute the query for anything to happen.

[redarrow]

$query1="UPDATE `news` SET views=views+1 WHERE `id`='$theid'";
$resuly=mysql_query($query1) or die("mysql_error()");

$query = "SELECT title, views, full, author, authorid, cat, id, date_format(date, '%a %D %b %Y %H:%i') as prettydate FROM news WHERE id='$theid'";
$resuly=mysql_query($query) or die("mysql_error()");

[Aureole]

I'm an idiot, thanks.