Mysql

NZ_Kiwi

I want a field in my sql database where i can add serveral different numbers,

for example when i add a row it will have a name ect and it may have cat_id of 1 but it may need to have 1 and 3 or 1, 3 and say 10

what sort of field should i make?

richie

Your question is not very clear. However, if you are looking for a field that will take any kind of value, you can look at the TEXT field.

If you store an integer inside a text field, and you use that value with php in a calculation, php will do the TYPE conversion on the fly.

Another way around the problem is to use settype() function after you have retrieved the value from mysql.

NZ_Kiwi

Originally posted by richie
Your question is not very clear. However, if you are looking for a field that will take any kind of value, you can look at the TEXT field.

If you store an integer inside a text field, and you use that value with php in a calculation, php will do the TYPE conversion on the fly.

Another way around the problem is to use settype() function after you have retrieved the value from mysql.

well when i do q mysql_query it will select from my table where cat_id = $cat_id

in the cat_id box i want to put all the id's so there might be one there might be more....

sorry but is that any better??

Sxooter

What you're looking for is an arrayed type. While this is natural for programmers, it generally goes against the grain for folks who prefer database normalization. If you were running a database with arrayable types (PostgreSQL, firebird too I believe) you could just use an arrayed int type here.

But it would be wrong. 🙂

Seriously though, do you need to be able to use this set of numbers in a where clause or such? If not then you can just store the numbers as a pipe delimited string like '10|15|18' .

If you need to use them in a where clause you'll likely need to normalize out the data. Make another table to hold the values and the ID or whatever pk from the master table, and join against that.