Hallo cpers.
Ik ben een inbox aan het maken.
Er staat 2 berichten in de tabel en hij laat er maar 1 zien.
inbox.php
PHP
<?php
/*
(c) xxx.nl
Alle rechten voorbehouden.
Niets mag worden gekopieerd zonder toestemming.
*/
include ("../config.php");
logincheck ();
$page = $_GET['p'];
$max = 10;
$start = ($_GET['n'] >= 0) ? $_GET['n'] * $max : 0;
?>
<html>
<head>
<title>xxx.nl</title>
<meta name="description" content="xxx is een gratis maffia game.">
<meta name="author" content="Youri">
<link href="../design/css/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="60%" align="center">
<tr>
<td class="titel" colspan="3">Je berichten</td>
</tr>
<tr>
<td class="text" width="20%"><b>Van</b></td>
<td class="text" width="40%"><b>Onderwerp</b></td>
<td class="text" width="40%"><b>Datum</b></td>
</tr>
<?php
$dbres = mysql_query("SELECT * FROM `Messages` WHERE `to`='{$data['name']}' AND `safe`=0 ORDER BY `time` DESC LIMIT $start, $max");
while($msg = mysql_fetch_assoc($dbres)) {
$dbres = mysql_query("SELECT * FROM `Users` WHERE `name`='{$msg['from']}'");
$user = mysql_fetch_assoc($dbres);
$from = $msg['from'];
$to = $msg['to'];
$subject = $msg['subject'];
$time = $msg['time'];
$showtime = gmdate("d-m-Y H:i:s", $time);
if ($msg['read'] == 1) {
PRINT <<<ENDHTML
<tr>
<td class="text"><a href="../user.php?uid={$user['id']}">{$from}</a></td>
<td class="text"><a href="read.php?mid={$msg['id']}">{$subject}</a></td>
<td class="text">{$showtime}</td>
</tr>
ENDHTML;
}
else {
PRINT <<<ENDHTML
<tr>
<td class="text"><i><a href="../user.php?uid={$user['id']}">{$from}</a></i></td>
<td class="text"><i><a href="read.php?mid={$msg['id']}">{$subject}</a></i></td>
<td class="text"><i>{$showtime}</i></td>
</tr>
ENDHTML;
}
}
?>
</table>
</body>
</html>De tabel is.
PHP
--
-- Tabelstructuur voor tabel `Messages`
--
CREATE TABLE IF NOT EXISTS `Messages` (
`id` int(100) NOT NULL auto_increment,
`from` varchar(20) NOT NULL,
`to` varchar(20) NOT NULL,
`subject` varchar(200) NOT NULL,
`msg` text NOT NULL,
`read` int(5) NOT NULL default '0',
`safe` int(5) NOT NULL default '0',
`time` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Gegevens worden uitgevoerd voor tabel `Messages`
--
INSERT INTO `Messages` (`id`, `from`, `to`, `subject`, `msg`, `read`, `safe`, `time`) VALUES
(1, 'Test', 'Youri', 'Onderwep', 'Message', 1, 0, 1261601566),
(2, 'Test', 'Youri', 'Onderwep', 'Message', 1, 0, 1261601566),Mijn inlog naam is dus youri, maar als ik naar me inbox ga laat hij er maar 1 zien.
Wie ken me helpen?