if ($_CURRENT_USER->is_anonymous) {
show_error("You must be logged in to view this dream journal.",
$PHP_USERS_HEADER_FILE,
$PHP_USERS_FOOTER_FILE);
}

$loggedin_user_id = $_CURRENT_USER->id;

$PAGE_TITLE = "dream theme: ".$_REQUEST["tag"];
include $PHP_USERS_HEADER_FILE;

if ($submit) {

// here if no ID then adding else we're editing

if ($id) {

$sql = "UPDATE Journals SET dream='$dream', month='$month', day='$day', year='$year', time='$time' WHERE dreamId=$id";
} else {

$sql = "INSERT INTO Journals (userId, dream, month, day, year, time) VALUES ($loggedin_user_id, '$dream', $month, $day, $year, $time)";

}

// run SQL against the DB

$result = mysql_query($sql);

echo "Record updated/edited!<p>";

} elseif ($delete) {

// delete a record

$sql = "DELETE FROM Journals WHERE dreamId=$id";

$result = mysql_query($sql);

echo "Record deleted!<p>";

} else {

// this part happens if we don't press submit

if (!$id) {

$sql = "SELECT TagsJournals.dreamID FROM TagsJournals, Tags WHERE TagsJournals.tagID=Tags.tag_id AND Tags.tag='".$_REQUEST["tag"]."'";

$result = mysql_query($sql);
#echo $sql;

echo "<P><font color='red'><i>Below are all users' dreams sharing this theme.</i></font></P>";

while ($myrow = mysql_fetch_array($result)) {
echo "<hr size=\"1\">";
$sqlDream = "SELECT * FROM Journals WHERE dreamId = ".$myrow["dreamID"];
$resultDream = mysql_query($sqlDream);

while ($rsDream = mysql_fetch_array($resultDream)) {
$dreamText = $rsDream["dream"];
$sqlTags = "SELECT * FROM Tags";
$resultTags = mysql_query($sqlTags);

printf("<B>someone dreamt this on </B><font size=\"4\">%s/%s/%s</font><P>\n", $rsDream["month"], $rsDream["day"], $rsDream["year"]);

$tagListing = "";

while ($rsTags = mysql_fetch_array($resultTags)) {
#$pos = strpos($mystring, $rsTags["tag"]);

$findTag = " ".$rsTags["tag"]." ";

if ($_REQUEST["tag"] == $rsTags["tag"]) {
$replaceTag = " <a href='tags.php?tag=".$rsTags["tag"]."'><b>".$rsTags["tag"]."</b></a> ";
}
else {
$replaceTag = " <a href='tags.php?tag=".$rsTags["tag"]."'>".$rsTags["tag"]."</a> ";
}

$dreamText = str_replace($findTag, $replaceTag, $dreamText, $count);

if ($count > 0) {
$tagListing = $tagListing." <a href='tags.php?tag=".$rsTags["tag"]."'>".$rsTags["tag"]."</a>";

#$sqlTagInsert = "INSERT INTO TagsJournals (dreamId, tagID) VALUES (".$myrow["dreamId"].", ".$rsTags["tag_id"].")";
#$resultTagInsert = mysql_query($sqlTagInsert);
#echo $sql."<br>";
}
}

echo nl2br($dreamText);
echo "<p><B><font size='3'>more themes:</font> </B> ".$tagListing."</p>";



#printf("%s<P>\n", $myrow["dream"]);



#$pos = strpos($mystring, $rsTags["tag"]);

#$findTag = " ".$rsTags["tag"]." ";
#$replaceTag = " <a href='#'>".$rsTags["tag"]."</a> ";

#$dreamText = str_replace($findTag, $replaceTag, $dreamText, $count);

#if ($count > 0) {
# $sqlTagInsert = "INSERT INTO TagsJournals (dreamId, tagID) VALUES (".$myrow["dreamId"].", ".$rsTags["tag_id"].")";
#$resultTagInsert = mysql_query($sqlTagInsert);
#echo $sql."<br>";
#}
}

}

}

}

include $PHP_USERS_FOOTER_FILE;
?>