Need a Query Help

binumathew · #1 (**permalink**) 11-27-09, 19:08

I Developed 2 Table

1)FriendTable

Code:

 CREATE TABLE `friendtable` (            
               `username` varchar(50) default NULL,  
               `fusername` varchar(50) default NULL  
             ) ENGINE=InnoDB DEFAULT CHARSET=latin1

2)Msg Table

Code:

 CREATE TABLE `msg` (                                      
          `msg` varchar(50) default NULL,                         
          `username` varchar(50) default NULL,                    
          `dt` date default NULL,                                 
          `id` int(50) unsigned NOT NULL auto_increment,          
          PRIMARY KEY  (`id`)                                     
        ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1

i need to get all the messages send by the fusername who is friend of username in friend table and messages send by username

can anybody help me??

Internet Services

Web Development

Digital Marketing

Consumer Tech