Hi,

This is my table structure

Code: -- -- Table structure for table `showbeta` -- `id` int(11) NOT NULL auto_increment, `presenter1id` int(5) NOT NULL, `presenter2id` int(5) NOT NULL, `engineerid` int(5) NOT NULL, `presenter1status` enum(0,1,2) NOT NULL, `presenter2status` enum(0,1,2) NOT NULL, `engineerstatus` enum(0,1,2) NOT NULL, Now if userid 5 wants to update his status I cant do a simple query such as

UPDATE showbeta SET presenter1status=2 WHERE id=$id

because user 5 could be in presenter1id, presenter2id, or engineerid.


So either I have set up the database wrong or I need to do the following but just not sure how.

Check if the user falls into presenter1id, presenter2id or engineerid

With that info update the corresponding status field.

For example user 5 is in presenter1id so update query presenter1status.


Hope this is clear,
Thanks Hi,

This is my table structure

Code: -- -- Table structure for table `showbeta` -- `id` int(11) NOT NULL auto_increment, `presenter1id` int(5) NOT NULL, `presenter2id` int(5) NOT NULL, `engineerid` int(5) NOT NULL, `presenter1status` enum(0,1,2) NOT NULL, `presenter2status` enum(0,1,2) NOT NULL, `engineerstatus` enum(0,1,2) NOT NULL, Now if userid 5 wants to update his status I cant do a simple query such as

UPDATE showbeta SET presenter1status=2 WHERE id=$id

because user 5 could be in presenter1id, presenter2id, or engineerid.


So either I have set up the database wrong or I need to do the following but just not sure how.

Check if the user falls into presenter1id, presenter2id or engineerid

With that info update the corresponding status field.

For example user 5 is in presenter1id so update query presenter1status.


Hope this is clear,
Thanks

View Complete Thread with Replies