Quote:
Originally Posted by lumpen5  We are holding a contest and want to be able to find out which registered user submitted the X link (as in you submitted the 1,000th link. Congrats!), etc.
I've checked in mysql, etc. but I just can't find a way to do it. Is there something I am missing?
Also, we want to be able to show the amount of published links on the front page. Try to modify the "logged in user" code but that didnot turn out so well.
Any help?
Thanks! |
Ok figured it out...Duhhh.
Go into mysql admin
click on yourtable_links
then browse
scroll down to the 1,000 entry (insert duh here!)
look in the "link_author" field for the author number
go to yourtable_users and find the "author number" in "user_id
Presto you have found your 1,000 submitor.
Still need help with getting the amount of published stories on the front page though