[PHP-DB] Web Poll Using sql

2002-01-17 Thread Jacob Wyke

Hi,

I know this must sound like a really easy question, but im trying to create
a simple web poll, where you choose your answer from a radio button and then
click submit.

On submitting I would like to update a sql table depending on what box the
user clicked.

How can I make it so it increments a table row by one??

So say I click option D, I want Row D in my table Poll to be incremented by
one.

Hope you can help me.

Thanks in advance for any help I receive.


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




RE: [PHP-DB] Web Poll Using sql

2002-01-17 Thread Beau Lebens

Jacob,

I think you can do something like

UPDATE tablename SET fieldD=fieldD+1 WHERE pollTitle='title';

or similar?

check the manual on updates and mathematical functions probably

-b

// -Original Message-
// From: Jacob Wyke [mailto:[EMAIL PROTECTED]]
// Sent: Friday, 18 January 2002 11:20 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Web Poll Using sql
// 
// 
// Hi,
// 
// I know this must sound like a really easy question, but im 
// trying to create
// a simple web poll, where you choose your answer from a radio 
// button and then
// click submit.
// 
// On submitting I would like to update a sql table depending 
// on what box the
// user clicked.
// 
// How can I make it so it increments a table row by one??
// 
// So say I click option D, I want Row D in my table Poll to be 
// incremented by
// one.
// 
// Hope you can help me.
// 
// Thanks in advance for any help I receive.
// 
// 
// _
// Do You Yahoo!?
// Get your free @yahoo.com address at http://mail.yahoo.com
// 
// 
// -- 
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: [EMAIL PROTECTED]
// For additional commands, e-mail: [EMAIL PROTECTED]
// To contact the list administrators, e-mail: 
// [EMAIL PROTECTED]
// 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]