Re: [PHP] adding 'vote' mechanism

2002-02-23 Thread Erik Price


On Saturday, February 23, 2002, at 02:42  PM, Nick Wilson wrote:
 I'd like to add a simple 'thumbs up, thumbs down' vote mechanism to it.
 The (simplified) table looks like this:

 id | authId | title | tip


 The only way I've come up with so far is to add two more fields
 (thumbs_up and thumbs_down). Then

 each time someone votes...
 get the current value of the field (say thumbs_up)
 use php to increment it's value and
 pop it back in the db.

What if you made the field a signed INT field, and used PHP to subtract 
one from the current value of the field every time someone chose thumbs 
down or add one to the current value of the field every time someone 
chose thumbs up.  This way you could have a level of how well the 
author stacks up.

This is just another idea shooting the moon, the truth is that it would 
probably be fine either way.  A matter of personal preference.

Erik







Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] adding 'vote' mechanism

2002-02-23 Thread Steven Walker

I personally prefer voting mechanisms that display how many votes have 
been cast. If you keep the thumbs_up separate from thumbs_down, you can 
figure the total number of votes. Otherwise, you will not be able to 
know whether the author is *really* average or just never voted for.

Steven J. Walker
Walker Effects
www.walkereffects.com
[EMAIL PROTECTED]

On Saturday, February 23, 2002, at 11:45  AM, Erik Price wrote:


 On Saturday, February 23, 2002, at 02:42  PM, Nick Wilson wrote:
 I'd like to add a simple 'thumbs up, thumbs down' vote mechanism to it.
 The (simplified) table looks like this:

 id | authId | title | tip


 The only way I've come up with so far is to add two more fields
 (thumbs_up and thumbs_down). Then

 each time someone votes...
 get the current value of the field (say thumbs_up)
 use php to increment it's value and
 pop it back in the db.

 What if you made the field a signed INT field, and used PHP to subtract 
 one from the current value of the field every time someone chose 
 thumbs down or add one to the current value of the field every time 
 someone chose thumbs up.  This way you could have a level of how 
 well the author stacks up.

 This is just another idea shooting the moon, the truth is that it would 
 probably be fine either way.  A matter of personal preference.

 Erik





 

 Erik Price
 Web Developer Temp
 Media Lab, H.H. Brown
 [EMAIL PROTECTED]


 -- PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php