number new Mysql Cookie

[Anon]

I am setting up a site and I want to be able to post the # of new news since the visitors last visit. I know I need to query the mysql database.. but I am totally lost..

I would be forever in debted to someone who can help me...

Thanks in advance

[Anon]

You would have to store sumthing to let your script know what news the person has read. maybe in a cookie

[Anon]

Okay...if I were you, I'd have an auto incrementing primary key.

Now, depending on how exactly you want the new news number to work, you could, each time the client views a page, update the cookie with the highest news primary key. Then, the next time they view a page, compare the value stored in the cookie with the current primary key: "SELECT count(*) AS numNew FROM Table WHERE primaryKey > $cookievalue"

Hope this helps....

-Rich

[Anon]

Rich, thanks..

I have 2 categories- site news and site additions.

I got your email from the site.. if you do not want me
write you..let me know..

I know php on a 1-5 (5 being highest) 2.5. I am
completely lost.. What can i send you to help me do
this.. This would be so great if I can get this
working..

Joe