SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: Custom fields and mysql
-
Aug 21, 2001, 18:12 #1
Custom fields and mysql
Hey guys,
I have this project on hand, where i need to be able to store a dynamic number of fields in my mysql dbase... i need to add a new column for every field... any ideas on the best way to do this?
Kunali dunno...
-
Aug 21, 2001, 19:07 #2
- Join Date
- Dec 2000
- Posts
- 528
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Hi kunal,
Whenever you create a new field, you are creating a new column.
If this isn't what you mean, could you please give some examples?
-CorbbCorbb O'Connor
Looking for quality website design or database programming?
Contact me for more information and a FREE quote!
-
Aug 21, 2001, 19:11 #3
- Join Date
- Oct 2000
- Location
- Austin, TX
- Posts
- 1,438
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
You could create a separate table like this:
CREATE TABLE data (
rowid INT UNSIGNED NOT NULL,
type VARCHAR(20),
value VARCHAR(50)
);
where rowid links the row to the other table.ck :: bringing chris to the masses.
-
Aug 22, 2001, 02:43 #4
Whenever you create a new field, you are creating a new column.
thats what i wanna dobut the big problem is, i will need to vary my mysql queries equally...
i dint understand the new table thing.. how is it gonna help my queries??
any more ideas??i dunno...
Bookmarks