PHP kôd:
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 18, 2011 at 09:53 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `pm`
--
-- --------------------------------------------------------
--
-- Table structure for table `diskusija`
--
CREATE TABLE IF NOT EXISTS `diskusija` (
`did` int(11) NOT NULL AUTO_INCREMENT,
`member1` int(11) NOT NULL,
`member2` int(11) NOT NULL,
PRIMARY KEY (`did`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `diskusija`
--
INSERT INTO `diskusija` (`did`, `member1`, `member2`) VALUES
(1, 1, 2),
(2, 1, 2),
(3, 4, 2),
(4, 1, 4);
-- --------------------------------------------------------
--
-- Table structure for table `poruke`
--
CREATE TABLE IF NOT EXISTS `poruke` (
`pid` int(11) NOT NULL AUTO_INCREMENT,
`did` int(11) NOT NULL,
`sender` int(11) NOT NULL,
`time` datetime NOT NULL,
`message` text NOT NULL,
`read` int(11) NOT NULL,
`deleted` int(11) NOT NULL,
PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `poruke`
--
INSERT INTO `poruke` (`pid`, `did`, `sender`, `time`, `message`, `read`, `deleted`) VALUES
(1, 1, 1, '2011-12-17 20:40:44', 'Ovo je test', 0, 0),
(2, 2, 2, '2011-12-18 20:50:41', 'test message2', 0, 0),
(3, 3, 4, '2011-12-28 20:51:30', 'sfav dadgagaga', 0, 0),
(4, 4, 4, '2011-12-31 21:19:45', 'poslednja poruka...', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `name`) VALUES
(1, 'Djuro'),
(2, 'Pajo'),
(3, 'Zvalo'),
(4, 'Sroljo');
////////
$id=1;
$query=mysql_query("SELECT *
FROM diskusija d
INNER JOIN poruke p ON p.did = d.did
INNER JOIN users u ON (u.id = d.member1 OR u.id = d.member2) AND u.id != '$id'
WHERE d.member1 = '$id' OR d.member2 = '$id'
GROUP BY d.did
ORDER BY p.time");
while($result = mysql_fetch_array($query)) {
echo $result['name'].':<br />';
echo $result['message'].'<br />';
}
Hm... da, zapravo, valjda bi trebalo tu jos koji upit ili dodatni uslov bachiti... i mozda nije ok tabela korisnika...