<?php
include_once('config.php');
include_once('functions.php');
$user_one = "13";
$db = safe_db_open($host, $gebruiker, $wachtwoord, $database);
$query= ("SELECT u.user_id,c.c_id,u.username,u.email
 FROM conversation c, users u
 WHERE CASE
 WHEN c.user_one = '$user_one'
 THEN c.user_two = u.user_id
 WHEN c.user_two = '$user_one'
 THEN c.user_one= u.user_id
 END
 AND (
 c.user_one ='$user_one'
 OR c.user_two ='$user_one'
 )
 Order by c.c_id DESC Limit 20");

$result = safe_query($db, $query);

while($row = mysqli_fetch_array($result))
{
$c_id=$row['cid'];
$user_id=$row['user_id'];
$username=$row['username'];
$email=$row['email'];
$cquery= ("SELECT R.cr_id,R.time,R.reply FROM conversation_reply R WHERE R.c_id_fk='$c_id' ORDER BY R.cr_id DESC LIMIT 1");
$cresult = safe_query($db, $cquery);
$crow= mysqli_fetch_array($cresult);
$cr_id=$crow['cr_id'];
$reply=$crow['reply'];
$time=$crow['time'];
echo "$time : $reply";
}
?>