SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: Need a Query Help
Hybrid View
-
Nov 27, 2009, 18:10 #1
- Join Date
- Oct 2009
- Posts
- 4
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Need a Query Help
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
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
can anybody help me??
-
Nov 27, 2009, 21:27 #2
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
please provide sample data, preferably by dumping some rows from each table
then show us what the query should return based on your sample data
-
Nov 28, 2009, 03:38 #3
- Join Date
- Oct 2009
- Posts
- 4
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Friend Table Having Data
username fusername
---------- ---------
binumathew jesvin
binumathew ddd
msg username dt id
---------- ---------- ---------- ------
sdsdsd binumathew 0000-00-00 11
sdsdsddsds binumathew (NULL) 12
dddd jesvin 0000-00-00 13
ddddd ddd 0000-00-00 14
msg username dt id
---------- ---------- ---------- ------
sdsdsd binumathew 0000-00-00 11
sdsdsddsds binumathew (NULL) 12
dddd jesvin 0000-00-00 13
ddddd ddd 0000-00-00 14
-
Nov 28, 2009, 07:11 #4
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
Bookmarks