|
|
Posted by Jim Michaels on 02/07/06 08:20
"Jim S." <jim@yeah.com> wrote in message
news:d3oFf.10916$rH5.4077@newsread2.news.atl.earthlink.net...
> well i got lastly, a variable that is like: $mystuff and has
> 1,4,3,6,7,8
>
> but i am not able to put $mystuff in the table no matter what i do.
have you tried putting single quotes around the data when you INSERT it?
INSERT INTO tablename(columnname) VALUES ('1,4,3,6,7,8')
> my table field is of a type Varchar(255) .
>
> now let us assume that i succeed (am being Very optimistic, emphasic on
> VERY)
> i know i can use explode, but i want to change the 1,4,3,6,7,8 to the
> option that i started with. so how can i do that?
> so i can have instead of numbers, basically, to have option1, option4,
> option3, ... and so on.
>
> helllllllllllllp :D
> <xclarky@gmail.com> wrote in message
> news:1139144662.354557.102930@f14g2000cwb.googlegroups.com...
>> ENUM is basically the same as SET however it allows NULL values.
>> Therefore this would be a wrong data type to use considering what you
>> are storing. Both basically set up a list of acceptable values for the
>> field.
>>
>> As you are storing an array, I would advise you to convert it to a
>> string so you have a list of numbers, separated by a divider; as you
>> have done.
>>
>> You can then store that list in your field, VARCHAR or TEXT should be
>> appropriate depending on the length of the list.
>>
>> When retrieving the data you can use explode() or array_map() to create
>> an array of the numbers for whatever purpose you wish. Alternatively
>> you can use MySQL functions in the WHERE clause for statements if you
>> are looking to perform a action where a match is found for a specific
>> value in your list.
>>
>> Hope that helps you.
>>
>
>
Navigation:
[Reply to this message]
|