\n"); Print("
back:

\n"); $mysql_link = mysql_connect("localhost", "plumbum", "17pb10"); mysql_select_db("subnote"); $result_totalentriesnoteno = mysql_query("SELECT noteno_id, noteno FROM noteno"); $totalrows= mysql_num_rows($result_totalentriesnoteno)-1; $max = $totalrows; // random number $random = ""; // randomizing mt_srand((double)microtime()*1000000); if ($max > 0) { $random = mt_rand(0,$max); } else { $random = 12; } // select the random quote and store the text in $quote and it's id in $id. for ($x=0;$x<=$random;$x++) { $myrow = mysql_fetch_array($result_totalentriesnoteno); } $id = $myrow[0]; $noteno = $myrow[1]; print("id=$id, random=$random, rows=$max
\n"); $result_noteno = mysql_query("SELECT imageprintcity, noteno, notevalue, noteseries, noteimage, imageartist, imagetitle, imagetext, imagedescription, imageartistwebaddress, imageimagefile, imageprintstate, imageprintdate FROM noteno WHERE noteno='$noteno'"); $result_check_spot = mysql_query("SELECT spotdate FROM tracked WHERE noteno='$noteno'"); $result_check_spent = mysql_query("SELECT spentdate FROM tracked WHERE noteno='$noteno'"); $result_check_message = mysql_query("SELECT messagetonext FROM tracked WHERE noteno='$noteno'"); $result_tracked_spot = mysql_query("SELECT spotfirstname, spotlastname, spotcity, spotdate, spotpurchase, spotshop, spotstate, spotcountry FROM tracked WHERE noteno='$noteno' ORDER BY spotdate DESC"); $result_tracked_spent = mysql_query("SELECT spotfirstname, spotlastname, spentdate, spentplace, spentcity, spentstate, spentcountry, spentpurchase FROM tracked WHERE noteno='$noteno' ORDER BY spentdate DESC"); $result_tracked_message = mysql_query("SELECT spotfirstname, spotlastname, messagetonext FROM tracked WHERE noteno='$noteno'"); $result_tracked = mysql_query("SELECT spotfirstname, spotlastname, spotcity, spotdate, spotpurchase, spotshop, spotstate, spotcountry, spentdate, spentplace, spentcity, spentstate, spentcountry, spentpurchase, datetime FROM tracked WHERE noteno='$noteno' ORDER BY datetime ASC"); //hier worden de gegevens van de eerste query uit tabel noteno weergegeven de while loop loopt tot en met het laatste resultaat uit noteno tabel. while($row = mysql_fetch_row($result_noteno)) { $item_imageprintcity = $row[0]; $item_noteno=$row[1]; $item_notevalue=$row[2]; $item_noteseries=$row[3]; $item_noteimage=$row[4]; $item_imageartist=$row[5]; $item_imagetitle=$row[6]; $item_imagetext=$row[7]; $item_imagedescription=$row[8]; $item_imageartistwebaddress=$row[9]; $item_imageimagefile=$row[10]; $item_imageprintstate=$row[11]; $item_imageprintdate=$row[12]; //layer voor registreren Print("
check another:

\"check

\n"); print(" \n"); //openen van layer voor het weergeven van de resultaten uit noteno Print(" \n"); //openen van de tabel voor het weergeven van de biljet informatie Print("
\n"); print("A12345678B $ $item_notevalue, series $item_noteseries
printdate $item_imageprintdate $item_imageprintcity, $item_imageprintstate
\n"); //sluiten eerste note info layer Print("\n"); //tweede layer voor image en details Print(" \n"); // tabel voor image en image details Print("\n");//later tabel en layer sluiten } // daarna kijken of er een image is elseif(empty($item_imageimagefile))//is er een imagefile, zo ja wordt dit weergegeven, anders niets {print(""); } else {print("\"$item_imagetitle\" \n"); // dit sluit de rij image } //nieuwe rij voor image details print("\n"); //nieuwe rij voor image description print("\n");} else {print("Description: $item_imagedescription\n");}//rij afsluiten //nieuwe rij image text print("\n");} else {print("Image text: $item_imagetext\n");}//rij afsluiten //eind van image table Print("
\n"); // hier zorgen dat er gecontroleerd wordt of er een noteimage is if($item_noteimage==0) { Print("For this note there are no image details available.\n"); Print("
$item_imagetitle, by $item_imageartist
\n"); if(empty($item_imagedescription)) { print("
\n"); if(empty($item_imagetext)) { print("
\n"); //einde van layer image info print("\n"); // deze sluit while loop voor note info?? // layer voor messages Print("
\n"); //bericht achtergelaten door vorige // hieronder de controle of er berichten zijn global $messageregels; $messageregels = 8;//opvoeren van een waarde om zeker te zijn dat waarde niet begint met 1 while($row = mysql_fetch_row($result_check_message)) { $item_messagetonext=$row[0]; $item_spentdate=$item_spentdate-1; if(!empty($item_messagetonext)) {$messageregels=1;} //einde check op messageregels variable }//einde while loop message check if($messageregels==1)//dan mag er gezocht worden naar resultaat: {print("Messages
\n"); while($row = mysql_fetch_row($result_tracked_message))// while loop voor resultaat message { $item_spotfirstname=$row[0]; $item_spotlastname=$row[1]; $item_messagetonext=$row[2]; if(empty($item_messagetonext)) {print("\n");} else {print("$item_spotfirstname $item_spotlastname: $item_messagetonext
\n");} } //einde while loop }//einde if Print("
\n"); } //open layer voor track details////////////////////////// Print("
\n"); // nu de details, while loop spot en spend // datafields: spotfirstname, spotlastname, spotcity, spotdate, spotpurchase, spotshop, spotstate, spotcountry, spentdate, spentplace, spentcity, spentstate, spentcountry, spentpurchase while($row = mysql_fetch_row($result_tracked)) { $item_spotfirstname = $row[0]; $item_spotlastname=$row[1]; $item_spotcity=$row[2]; $item_spotdate=$row[3]; $item_spotpurchase=$row[4]; $item_spotshop=$row[5]; $item_spotstate=$row[6]; $item_spotcountry=$row[7]; $item_spentdate=$row[8]; $item_spentplace=$row[9]; $item_spentcity=$row[10]; $item_spentstate=$row[11]; $item_spentcountry=$row[12]; $item_spentpurchase=$row[13]; $check_spotdate=$item_spotdate-1; $check_spentdate=$item_spentdate-1; $check_bothdate=$check_spotdate*$check_spentdate; if($check_bothdate>0)//kijken of er beide een datum hebben informatie van beide {Print(" \n"); }//einde if elseif($check_spotdate>0)//kijken of er een spot is, dan vullen met spot informatie {Print(" \n"); }//einde if spot date > 0 in while loop else {Print(" \n"); }//einde spent else }//einde while loop Print("
who
date
type
transaction
locality
Place
$item_spotfirstname $itemspotlastname spot $item_spotdate $item_spotpurchase $item_spotshop $item_spotcity, $item_spotstate, $item_spotcountry
$item_spotfirstname $itemspotlastname spent $item_spentdate $item_spentpurchase $item_spentplace $item_spentcity, $item_spentstate, $item_spotcountry
$item_spotfirstname $itemspotlastname spot $item_spotdate $item_spotpurchase $item_spotshop $item_spotcity, $item_spotstate, $item_spotcountry
$item_spotfirstname $itemspotlastname spent $item_spentdate $item_spentpurchase $item_spentplace $item_spentcity, $item_spentstate, $item_spentcountry
\n"); Print("\n"); ?>