Hi . Welcome back.
|
Description
|
Date Created
|
Created By
|
Edit - Delete
|
You have no lists. Why dont you create one?";
if ($db->connect_error) {
die("Connection failed: " . $db->connect_error);
}
$sql = "SELECT DISTINCT lists.id, lists.listdescription, lists.createdon, lists.createdby, lists.sharedlist FROM lists INNER JOIN users ON users.fname = '$displayname' AND users.fname = lists.createdby";
$result = $db->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$listID = $row["id"];
$listDescription = $row["listdescription"];
$createdOn = $row["createdon"];
$createdBy = $row["createdby"];
echo "";
echo "| $listDescription | ";
echo "$createdOn | ";
echo "$createdBy | ";
echo "
| ";
}
} else {
echo " $noLists ";
}
$db->close();
?>