Hi :)
I have a table that is created like such...
CREATE TABLE `BRANCH_mod_user_groups` (
`group_id` int(11) NOT NULL default '0',
`group_name` varchar(30) default NULL,
`description` text,
`members` text,
PRIMARY KEY (`group_id`)
) TYPE=MRG_MyISAM INSERT_METHOD=FIRST
I hope the question is OK :)
The first 4 queries work fine, the last causes the error. I'm probably
missing something obvious, but this is complex for me.
TIA for any tips,
verdon
GODD
SELECT
volunteers.volunteer_id,volunteers.first,volunteers.middle,volunteers.last,v
Just a quick note to Ed and Amer,
You two were right on, with this. I took the plunge and re-thought my db as
you both suggested. Sage advice, as successive queries and relationships
have been much easier to achieve with the new allocation table. It's clear
to see that this method also will offer
Hi :)
I'm not even sure if I'm naming the question correctly. I hope I can
ask/explain it clearly enough to get a hint ;)
Essentially...
1) I have a table of portfolio 'pieces', each row of which has a unique ID
2) I have a table of 'projects', which are comprised of a number of
'pieces'.
, Verdon vaillancourt wrote:
2) I have a table of 'projects', which are comprised of a number of
'pieces'. There is a column in this projects table called 'pieces',
which
contains a delimitated string of all the 'pieces' related to that
'project',
in the format of '1||2||3||5||12||16||17||24