Hi, Just wondering if it was possible to add more than 1 variable to the same database table.

For example.

They hit the radio button 1. and radio button 2.

So now they have selected 1 and 2, then they hit send.

it then stores the value for 1, and the value for 2, into the same database table.

So, if it stores the information in the field " Rectangle " in the field " Rectangle " it will have stored 1 2.

Any ideas?
Lothop

Lothop,

I am not entirely clear on your question. Firstly, radio buttons are by definition selectable only one at a time within a logical group. Their very name comes from the old manual preset buttons so common on car radios up until the early 1980's.

Assuming you mean checkboxes or some other means of specifying more than one value, let me try to restate your problem. With two values, you wish to be able to communicate, in one field that the user may have selected one option (we'll call the value for that option 1), another option (2), both or none. It's a common problem and programmers will normally approach it in one of several ways.

First, you could simply store off a comma-delimited list of the values selected. So if the user selected both, you would store "1,2" in the field.

Another option would be to assign numeric values to each option that are a power of 2. So option 1 would be 1, option 2 would be 2, option 3 would be 4, option 4 would be 8, then 16, 32, 64, etc. In this way, you could add all the values together and store that one numeric value from which could be deduced all the options selected. For example, if I store off a value of 11, I know a user must have selected a combination of options carrying the values of 1,2 and 8. That is the only combination of such values arriving at the sum of 11. It is really a matter of personal choice you wish to take.

I mean check boxes, not radio boxes.

Basically, so... it stores the selected box values in the same field.

So they select, games, and sports.

In the field called hobbies, it stores "games, sports,"

THnx for the reply,
Lothop

your _POST vars can hold the select box values if you use the name as myname[] ( i.e. like an array).

You then explode the array and store it on the field.

One thing. When you refill the form using the field data, you will have some trouble.

I understand the basis off it, just wondering how to impletement it.

EG. Storing the multiple variables in the field.

I just reinstalled windows, so i'll post my code ASAP.

PHP Code:

if ($this->sql->Update("UPDATE ".$this->TABLES['users']." SET info = '".$city."', '".$country."'  WHERE username = '".$_COOKIE['usernamecookie']."'")) {} 


Is using UPDATE wrong?

Lothop,

I'm not sure what you need from here. You are using the concatenation method of storing values and that is a valid approach. Is it not working for you? Can you provide specifics as to what your problem is now?

Hi lothop,

I think I asked you before.

I do not know what this is.

$this->sql->Update....

What package are you using?
Your coding style is very very different. Since you are using classes you must be very very proficient with it.

Please explain.

On the other hand, we try to give you quick fixes alone, which is not what you want.