yhZE3DXq

1$check = "SELECT streamitem_id, streamitem_timestamp, streamitem_content FROM streamdata WHERE streamitem_creator="$user1_id." AND streamitem_id=".$last." AND streamitem_type_id=1 ORDER BY streamitem_timestamp DESC";
2$check1 = mysqli_query($mysqli,$check);
3$resultArr = mysqli_fetch_array($check1);
4$json['streamitem_id'] = $resultArr['streamitem_id'];
5$json['streamitem_timestamp'] = Agotime($resultArr['streamitem_timestamp']);
6$json['streamitem_content'] = $resultArr['streamitem_content'];
7mysqli_free_result($check1);
8
9
10$check = "SELECT * FROM users";
11$check1 = mysqli_query($mysqli,$check);
12$resultArr = mysqli_fetch_array($check1);
13$json['username'] = $resultArr['username'];
14$json['id'] = $resultArr['id'];
15$json['first'] = $resultArr['first'];
16$json['middle'] = $resultArr['middle'];
17$json['last'] = $resultArr['last'];
18mysqli_free_result($check1);
19
20
21-- Table structure for table `streamdata`
22--
23
24    CREATE TABLE IF NOT EXISTS `streamdata` (
25      `streamitem_id` int(11) NOT NULL auto_increment,
26      `streamitem_type_id` int(11) NOT NULL,
27      `streamitem_creator` int(11) NOT NULL,
28      `streamitem_target` int(11) NOT NULL,
29      `streamitem_timestamp` datetime NOT NULL,
30      `streamitem_content` varchar(5000) NOT NULL,
31      PRIMARY KEY  (`str
32
33    eamitem_id`)
34        ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1953 ;
35
36
37    -- Table structure for table `users`
38    --
39
40    CREATE TABLE IF NOT EXISTS `users` (
41      `id` int(11) NOT NULL auto_increment,
42      `first` varchar(64) NOT NULL,
43      `middle` varchar(64) NOT NULL,
44      `last` varchar(64) NOT NULL,
45     `username` varchar(64) NOT NULL,
46      PRIMARY KEY  (`id`)
47    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=150 ;
48	
49$check = "
50SELECT * FROM users u 
51INNER JOIN streamdata s ON
52    (s.streamitem_creator = u.id AND s.streamitem_id = {$last})";