Re: [PHP] Assistance needed with mysql query to achieve this php5

On Fri, January 25, 2008 4:06 am, Don Don wrote: > The db structure is a little complicated hence the duplication of > usernames. A complicated DB is all the MORE reason not to duplicate data... Stop typing and start thinking, because you are building up a mess that WILL bite you in the butt in

Re: [PHP] Assistance needed with mysql query to achieve this php5

Hi Richard, I'll try out your suggestions and will let you know if i had any luck. The db structure is a little complicated hence the duplication of usernames. Cheers Richard Lynch <[EMAIL PROTECTED]> wrote: Just take out member_id = '%s' and use friendWIthId = '%s' instead. Actually, I think y

Re: [PHP] Assistance needed with mysql query to achieve this php5

Just take out member_id = '%s' and use friendWIthId = '%s' instead. Actually, I think you may need to swap member/friendwith as well... But why you are storing everybody's NAME twice is beyond me... Or maybe I'm guessing wrongly what the fields are... On Thu, January 24, 2008 10:49 am, Don Don

[PHP] Assistance needed with mysql query to achieve this php5

Hi all I have a table below CREATE TABLE `friends` ( `id` int(11) NOT NULL auto_increment, `member_id` int(11) NOT NULL, `member` varchar(32) NOT NULL, `friendwith` varchar(32) NOT NULL, `friendWithId` int(11) NOT NULL, `status` varchar(32) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyIS