MySQL Forums
Forum List  »  Newbie

Radio button from form, binary attribute
Posted by: gaute
Date: July 21, 2005 01:56AM

Hi.

I am having trouble making a field to recieve a boolean value from a radio button in a form.

The host i am using, is running MySQL version 4.0.24

I am making a survey of our company online, and want to store the information into a database.

The form has question and 11 radio buttons (1 through 10, and "I dont't know")
When i create the tabel for this form, I add a field ex. "S1" and try to make it binary.
Like so:

S1` TINYINT( 1 ) BINARY NOT NULL DEFAULT '0'

Then i get this error message:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BINARY NOT NULL
DEFAULT '0'' at line 1

Please advise.

Options: ReplyQuote


Subject
Written By
Posted
Radio button from form, binary attribute
July 21, 2005 01:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.