Lorinda

OMG!! @Guru you are a life saver.. I guess I looked a bit too long at the code.. Thank you thank you thank you is all i can say. :happy-04:

Hi All, I am struggling to get the correct information from mysql db to my php page. My page has an Index page: Like this: index.php: <?php require "dbinfo.php"; $sql="SELECT * FROM stats"; $result = mysql_query($sql, $db) or die (mysql_error()); $pageTitle = "My Stats Database"; include "header.php"; print <<<HERE <h2> My Contacts</h2> Select a Record to update <a href="addstat.php"> add new stat</a>. <table id="home"> HERE; while ($row=mysql_fetch_array($result)){ $id=$row["id"]; $type=$row["type"]; $depthead=$row["depthead"]; $person=$row["person"]; $descr=$row["descr"]; $recdate=$row["recdate"]; $tolog=$row["tolog"]; $senttorev=$row["senttorev"]; $recfromrev=$row["recfromrev"]; print <<<HERE <tr> <td> <form method="POST" action="updateform.php"> <input type="hidden" name="sel_record" value="$id"> <input type="submit" name="update" value=" Edit " </form> </td> <td><strong> Description: </strong>$descr,<p> <strong>Type: </strong>$type</p> <p><strong> Department Head: </strong>$depthead</p> <strong> Test Analyst: </strong> $person<br/></td> HERE; } print "</tr></table></body></html>"; ?> Then it has the actual adding of the stats: Here: addstats.php: <?php if($_POST['submit']="Submit") //if(isset($_POST['submit'])) { $type = cleanData($_POST['type']); $depthead = cleanData($_POST['depthead']); $person = cleanData($_POST['person']); $descr = cleanData($_POST['descr']); $recdate = cleanData($_POST['recdate']); $tolog = cleanData($_POST['tolog']); $senttorev = cleanData($_POST['senttorev']); $recfromrev = cleanData($_POST['recfromrev']); //print "Data Cleaned"; addData($type, $depthead, $person, $descr, $recdate, $tolog, $senttorev, $recfromrev); } else { printForm(); } function cleanData($data){ $data = trim($data); $data = stripcslashes($data); $data = htmlspecialchars($data); $data = strip_tags($data); return $data; } function addData ($type, $depthead, $person, $descr, $recdate, $tolog, $senttorev, $recfromrev) { //print "ready to add data"; include("dbinfo.php"); include("header.php"); $sql="INSERT INTO stats VALUES (null, '$type', '$depthead', '$person', '$descr', '$recdate', '$tolog', '$senttorev', '$recfromrev')"; $result=mysql_query($sql) or die(mysql_error()); print <<<HERE <h1>You have added the following</h1> <ul> <li> Type: $type</li> <li> Deptartment Head: $depthead</li> <li> Test Analyst: $person</li> <li> Description: $descr</li> <li> Received Date: $recdate</li> <li> Date to log: $tolog</li> <li> Sent to Rev: $senttorev</li> <li> Received from Revision : $recfromrev</li> </ul> HERE; } function printform(){ $pagetitle = "Add Stats"; include("header.php"); print <<<HERE <h2>Add Stats Here</h2> <form id = "stats" method ="POST"> <div> <label for = "type" >Type*:</label> <input type = "text" name = "type" id = "type" required = "required"> </div> <p> </p> <div> <label for = "depthead" >Department Head*:</label> <input type = "text" name = "depthead" id = "depthead" required = "required"> </div> <p> </p> <div> <label for = "person" >Test Analyst*:</label> <input type = "text" name = "person" id = "person" required = "required"> </div> <p> </p> <div> <label for = "descr" >Description*:</label> <input type = "text" name = "descr" id = "descr" required = "required"> </div> <p> </p> <div> <label for = "recdate" >Date Received*:</label> <input type = "text" name = "recdate" id = "recdate" required = "required"> </div> <p> </p> <div> <label for = "tolog" >Date to log*:</label> <input type = "text" name = "tolog" id = "tolog" required = "required"> </div> <p> </p> <div> <label for = "senttorev" >Sent to Rev:</label> <input type = "text" name = "senttorev" id = "senttorev" required = "required"> </div> <p> </p> <div> <label for = "recfromrev" >Received from Rev*:</label> <input type = "text" name = "recfromrev" id = "recfromrev" required = "required"> </div> <p> </p> <div id="mySubmit"> <input type="submit" name="submit" value="Submit"> </div> </form> HERE; } ?> Then it has the updating of the stats: updateform.php this is where I am stuck beyond belief: <?php require"dbinfo.php"; $sel_record = $_POST['sel_record']; //$sel_record = (isset($_POST['sel_record'])) ? $_POST['sel_record'] : ''; $sql = "SELECT * FROM stats WHERE id = '$sel_record'"; //execute sql query and get result $result = mysql_query($sql, $db) or die (mysql_error()); if (!$result) { print "<h1> Something went wrong!</h1>"; } else { //begin while loop while ($record = mysql_fetch_array($result, MYSQL_ASSOC)){ $id = $record['id']; $type = $record['type']; $depthead = $record['depthead']; $person = $record["person"]; $descr = $record["descr"]; $recdate = $record["recdate"]; $tolog = $record["tolog"]; $senttorev = $record["senttorev"]; $recfromrev = $record["recfromrev"]; } } //end while loop $pagetitle = "Edit Stat"; include "header.php"; print <<<HERE <h2> Modify this Stat</h2> <p> Change the values in the boxes and click "Modify Record" button </p> <form id="myform" method="POST" action="update.php"> <input type="hidden" name="id" value="$id"> <div> <label for="type">Type*:</label> <input type="text" name="type" id="type" value="$type"> </div> <p> </p> <div> <label for = "depthead" >Department Head*:</label> <input type = "text" name = "depthead" id = "depthead" value = "$depthead"> </div> <p> </p> <div> <label for="person">Test Analyst*:</label> <input type="text" name="person" id="person" value="$person"> </div> <p> </p> <div> <label for="descr">Description*:</label> <input type="text" name="descr" id="descr" value="$descr"> </div> <p> </p> <div> <label for="recdate">Date Received*:</label> <input type="text" name="recdate" id="recdate" value="$recdate"> </div> <p> </p> <div> <label for="tolog">Date to log*:</label> <input type="text" name="tolog" id="tolog" value="$tolog"> </div> <p> </p> <div> <label for="senttorev">Sent to Rev:</label> <input type="text" name="senttorev" id="senttorev" value="$senttorev"> </div> <p> </p> <div> <label for="recfromrev">Received from Rev*:</label> <input type="text" name="recfromrev" id="recfromrev" value="$recfromrev"> </div> <p> </p> <div id="mySubmit"> <input type="submit" name="submit" value="Modify Record"> </div> </form> HERE; ?> and the then update portion itself: <?php include "dbinfo.php"; $id = $_POST['id']; $type = $_POST['type']; $depthead = $_POST['depthead']; $person = $_POST['person']; $descr=$_POST['descr']; $recdate=$_POST['recdate']; $tolog=$_POST['tolog']; $senttorev=$_POST['senttorev']; $recfromrev=$_POST['recfromrev']; $sql="UPDATE stats SET type='$type', depthead='$depthead', person='$person', descr='$descr', recdate='$recdate', tolog='$tolog', senttorev='$senttorev', recfromrev='$recfromrev' WHERE id='$id' "; $result=mysql_query($sql) or die (mysql_error()); print "<html><head><title>Update Results</titlel></head><body>"; include "header.php"; print <<<HERE <h1>The new Record looks like this: </h1> <td> <p><strong>Type: </strong>$type</p> <p><strong>Department Head: </strong>$depthead</p> <p><strong>Test Analyst: </strong> $person</p> <p><strong>Description: </strong>$descr</p> <p><strong>Received Date:</strong>$recdate</p> <p><strong>Date to Log:</strong>$tolog</p> <p><strong>Sent to rev:</strong>$senttorev</p> <p><strong>Received from Rev:</strong>$recfromrev</p> <br/> HERE; My problem is when I select the "edit" record on the index.php page I get the wrong information to my updateform.php screen. I don't know why, I have tried everything that I know of. Does not matter which record I select I keep on getting the same numbered one. Please see fi you can help me with this? Thanking you in advance.

Hi, The mail needs to be sent with the information that the "manager" has completed in the one page and then sent to the user to be able to view the information and then click on a link and open the form (where the data is stored in) //so we use the MD5 algorithm to generate a random hash $random_hash = md5(date('r', time())); $headers = "From: $johnny@gmail.com"; //add boundary string and mime type specification $headers .= "\r\nContent-Type: multipart/alternative; boundary=\"PHP-alt-".$random_hash."\""; $message = " Do I place the above code before the table I have created ?

Thank you, but the UwAmp is already set up to send emails..I need assitance with the code..

Hi I an using UwAmp

Good Morning, I am building a system at work with Mysql and PHP with regards to log-in's and submitting information. I need to send the form info to my Database (which works great) but now I have to send the information that was submitted into the Databse to the applicable users email address, this user then has to click a link in the mail to take him/her to continue. I am struggling horribly with the email function.. Here is my code that I am using: <?php $conn = mysql_connect("localhost","root","root"); $db = mysql_select_db("mysql",$conn); ?> <?php $alloc = $_POST["alloc"]; $allocby = $_POST["allocby"]; $specification = $_POST["specification"]; $reqno = $_POST["reqno"]; $scheme = $_POST["scheme"]; $fromtime = $_POST["fromtime"]; $totime = $_POST["totime"]; $targetdate = $_POST["targetdate"]; $comments = $_POST["comments"]; if($alloc == "s"){ $alloc = 'MHAS002 - AS'; }else if ($alloc == "t"){ $alloc = 'MHMS004 - SM'; }else if ($alloc == "u"){ $alloc = 'MHMN005 - MM'; }else if ($alloc =="v"){ $alloc = 'MHMW005 - MVW'; }else if ($alloc == "w"){ $alloc = 'MHGC001 - GC'; }else if ($alloc == "x"){ $alloc = 'MHGK002 - GDP'; }else if ($alloc == "y"){ $alloc = 'MHLW009 - LW'; }else if ($alloc == "z"){ $alloc = 'MHZP001 - ZP'; }; if($allocby == "a"){ $allocby = 'LM; }else if ($allocby == "b"){ $allocby = 'User'; }else if ($allocby == "c"){ $allocby = 'Other'; }; $sql = "INSERT into manspecification values('$alloc','$allocby','$specification','$reqno','$scheme','$fromtime','$totime','$targetdate','$comments')"; $query = mysql_query($sql); if(!$query) echo mysql_error(); else { echo "Successfully Inserted<br />"; } $to = "johnny@johnny.co.za"; $subject = "Specification"; $email = $_POST['Email']; $message = $_POST['Spec']; $headers = "From: [email="$johnny@gmail.com"]$johnny@gmail.com[/email]"; $sent = mail($to, $subject, $message, $headers); if($sent) {print "Your mail was sent successfully"; } else {print "We encountered an error sending your mail"; } ?> <p> </p> <table border="0" cellspacing="0" cellpadding="3"> <tr><td> Allocated To: <td> <?=$alloc?> <tr><td> Allocated By: <td> <?=$allocby?> <tr><td> Spec Info: <td> <?=$type?> <tr><Td> Request No: <td> <?=$reqno?> <tr><td> Scheme: <td> <?=$scheme?> <tr><td> From Time: <td> <?=$fromtime?> <tr><td> To Time: <td> <?=$totime?> <tr><td> Target Date: <td> <?=$targetdate?> <tr><td> Comments: <td> <?=$comments?> <td> <td> </td> </table> </form> <p><A HREF="/manspesifications.html" target="_self"><strong>Go back</strong></A></p> </body> </html> I would apprecaite any help with this as this would be the first time that I am working with php and not to mention emails in phph *blush* :'(

WoW thanx, lemme play with it a bit and I'll let you know, thank you very very much for your help, That is really kind of you :happy-04: :happy-04:

WoW Oaky, that makes a little sense...if I then run the query it will give me all the info in the 'selectedcolumn' of i.e. type and requestedby ?

All of them are in the tables, and would that then sort the problem with getting all the information from the 3 tables into one page to be able to generate a report ? Terribly sorry for all the queations, I am just trying to wrap my silly little brain around all the information

The tables I use would be: 'stats', 'systemletter' and 'systemchanges' those are the tables created in my DB (wamp Server) The 48, 49, 50 etc.. is basically for my code to send the info to the spec. db i.e: <?php $conn = mysql_connect("localhost","root",""); $db = mysql_select_db("mysql",$conn); ?> <?php $username = $_POST["username"]; $requestedby = $_POST["requestedby"]; $type = $_POST["type"]; $memberno = $_POST["memberno"]; $scheme = $_POST["scheme"]; $fromtime = $_POST["fromtime"]; $fromdate = $_POST["fromdate"]; $totime = $_POST["totime"]; $todate = $_POST["todate"]; $comments = $_POST["comments"]; if($username == "s"){ $username = 'MHAS002 - Anelia Sinclair'; }else if (%username == "t"){ $username = 'MHMS004 - Melanie Smit'; }else if ($username == "u"){ $username = 'MHMN005 - Marelize Momberg'; }else if ($username =="v"){ $username = 'MHMW005 - Martin van Wyk'; }else if ($username == "w"){ $username = 'MHGC001 - George Curtin'; }else if ($username == "x"){ $username = 'MHGK002 - Gerna du Plessis'; }else if ($username == "y"){ $username = 'MHLW009 - Lorinda Wilkinson'; }else if ($username == "z"){ $username = 'MHZP001 - Zenobia Potgieter'; }; if($requestedby == "a"){ $requestedby = 'Leona Makkink'; }else if ($requestedby == "b"){ $requestedby = 'User'; }else if ($requestedby == "c"){ $requestedby = 'Other'; }; if ($type == 1){ $type = '158DL'; }else if ($type == 2){ $type = '032D1'; }else if ($type == 3){ $type = '140D1'; }else if ($type == 4){ $type = '517D1'; }else if ($type == 5){ $type = '484D1'; }else if ($type == 6){ $type = 'SMS197'; }else if ($type == 7){ $type = 'Relation Code'; }else if ($type == { $type = 'System Letters'; }else if ($type == 9){ $type = 'Purge Briewe'; }else if ($type == 10){ $type = 'Purge "A" nr'; }else if ($type == 11){ $type = 'IT BB'; }else if ($type == 12){ $type = 'Purge BB'; }else if ($type == 13){ $type = 'Printer'; }else if ($type == 14){ $type = 'Outlook'; }else if ($type == 15){ $type = 'Health & Safety'; }else if ($type == 16){ $type = 'Salary Code'; }else if ($type == 17){ $type = 'Limits'; }else if ($type == 18){ $type = 'Drukstukke Doen'; }else if ($type == 19){ $type = 'Drukstukke Nasien'; }else if ($type == 20){ $type = 'XML Log'; }else if ($type == 21){ $type = 'Ad Hoc Testings'; }else if ($type == 22){ $type = 'Other'; }else if ($type == 23){ $type = 'SCR Report'; }else if ($type == 24){ $type = 'Usr Group oudit'; }else if ($type == 25){ $type = 'Usr Xfer'; }else if ($type == 26){ $type = 'Bertus Stats'; }else if ($type == 27){ $type = 'Yoricks Stats'; }else if ($type == 28){ $type = 'Meetings'; }else if ($type == 29){ $type = 'Nerver Centre'; }else if ($type == 30){ $type = 'Line Count'; }; $sql = "INSERT into stats values('$username','$requestedby','$type','$memberno','$scheme','$fromtime','$fromdate','$totime','$todate','$comments')"; $qury = mysql_query($sql); if(!$qury) echo mysql_error(); else { echo "Successfully Inserted<br />"; } ?> <p> </p> <table border="0" cellspacing="0" cellpadding="3"> <tr><td> User Name: <td> <?=$username?> <tr><td> Requested By: <td> <?=$requestedby?> <tr><td> Type: <td> <?=$type?> <tr><Td> Member No: <td> <?=$memberno?> <tr><td> Scheme: <td> <?=$scheme?> <tr><td> From Time: <td> <?=$fromtime?> <tr><td> From Date: <td> <?=$fromdate?> <tr><td> To Time: <td> <?=$totime?> <tr><td> To Date: <td> <?=$todate?> <tr><td> Comments: <td> <?=$comments?> <td> </table> </form> <p><A HREF="/Statsp1.html" target="_self"><strong>Go back</strong></A></p> </body> </html> Don't know if it is wrong but it pulls everything through to the specific db (i sue drop down boxes) <body> <script src="datepicker.js" language="javascript"></script> <div id="datepicker" style="position:absolute; width:277px; height:271px; z-index:1; visibility: hidden;" onmouseover="javascript:dpmouseover=true;" onmouseout="javascript:dpmouseover=false;"> <object id="fdatepicker" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" type="application/x-shockwave-flash" width="230" height="230"> <param name="movie" value="datepicker.swf" /> <param name="wmode" value="transparent" /> <param name="quality" value="high" /> <param name="swfversion" value="8.0.35.0" /> <embed name="fdatepicker" wmode="transparent" src="datepicker.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="230" height="230"></embed> </object> </div> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <form name="stats" action="post.php" method="post"> <table align="center"> <td align="center"> <tr> <td height="25" colspan="2" align="center" valign="middle"><h1 class="grey"><strong>Stats</strong></h1> <tr> <td class="grey"><p> User Name: <td><select name="username"> <option value="s">MHAS002 - Anelia Sinclair</option> <option value="t">MHMS004 - </option> <option value="u">MHMN005 - </option> <option value="v">MHMW005 - </option> <option value="w">MHGC001 - </option> <option value="x">MHGK002 - </option> <option value="y">MHLW009 - </option> <option value="z">MHZP001 - </option> </select> <tr><td> <tr> <td class="grey"><p> Requested by: <td><select name="requestedby"> <option value="a">Leona Makkink</option> <option value="b">User</option> <option value="c">Other</option> </select> <tr><td> <tr> <td class="grey"><p> Type: <td><select name="type"> <option value="1">158DL</option> <option value="2">032D1</option> <option value="3">140D1</option> <option value="4">517D1</option> <option value="5">484D1</option> <option value="6">SMS197</option> <option value="7">Relation Code</option> <option value="8">System Letters</option> <option value="9">Purge Briewe</option> <option value="10">Purge "A" nr</option> <option value="11">IT BB</option> <option value="12">Purge BB</option> <option value="13">Printer</option> <option value="14">Outlook</option> <option value="15">Health & Saftey</option> <option value="16">Salary Code</option> <option value="17">Limits</option> <option value="18">Drukstukke Doen</option> <option value="19">Drukstukke Nasien</option> <option value="20">XML Log</option> <option value="21">Ad Hoc Testing</option> <option value="22">Other</option> <option value="23">SCR Report</option> <option value="24">USR Group Oudit</option> <option value="25">USR Xfer</option> <option value="26">Bertus Stats</option> <option value="27">Yorick Stats</option> <option value="28">Meetings</option> <option value="29">Nerve Centre</option> <option value="30">Line Count</option> </select> <tr><td> <tr> <td class="grey"><p> Member No: <td><input name="memberno" type="text"> <tr><td> <tr> <td class="grey"> Scheme: <td><span id="sprytextfield3"> <input name="scheme" type="text" id="scheme" value="Medihelp"> <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span> <tr><td> <tr> <td class="grey"><p> From Time: <td><span id="sprytextfield1"> <input name="fromtime" type="text" value="00:00:00"> <span class="textfieldRequiredMsg">A value is required. </span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span> <tr class="grey"> <td>From Date:<td><span id="sprytextfield4"> <label> <input type="text" name="fromdate" id="fromdate"> </label> <span class="textfieldRequiredMsg">A value is required. </span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span> <tr> <td class="grey"><p> To Time: <td><span id="sprytextfield2"> <input name="totime" type="text" value="00:00:00"> <span class="textfieldRequiredMsg">A value is required</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span> <span class="textfieldRequiredMsg">A value is required.</span></span> <tr> <td colspan=2><span class="grey">To Date: </span> <span id="sprytextfield6"> <label> <input type="text" name="todate" id="todate"> </label> <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span> <tr> <td class="grey"><p> Comments: <td><textarea name="comments" rows="7" id="comments"></textarea> <tr> <td><p> <p> <input type="submit" value="Send"> <input name="Reset" type="reset" value="Clear"> </table> <p><a href="/index.php" target="_self"><img src="/home.jpg" alt="roundhome" width="64" height="71" border="0" /></a></p> </form> <script type="text/javascript"> <!-- var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1", "time", {format:"HH:mm:ss"}); var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2", "time", {format:"HH:mm:ss"}); var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3", "custom"); var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4", "date", {format:"yyyy/mm/dd"}); var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5"); var sprytextfield6 = new Spry.Widget.ValidationTextField("sprytextfield6", "date", {format:"yyyy/mm/dd"}); //--> </script> </body> </html> hope it makes sense this way... Like I said I am new at this and is learning something new everyday (litterally)

I did not add the full script, but they are all within the form tags... Can you maybe suggest another way I can approach this then ? I can change my page s I like, I thought tick boxes would work better for more selections ?

Hope this help Good Afternoon, I am a newbie at php coding and sql, and I have started a site at work where the users can enter everything that they have done at work for the day including times and dates. I managed to get the information pulled through to my local DB (Wamp Server) Now I want the head of the department to be able to get reports and results from those pages using php. I am using check boxes for the head to choose what she wants to see..i.e: <tr> <td class="grey"><p><span class="grey"> <input name="username" type="checkbox" class="User" id="username" value="48"/> User Name </span> </p> <p> <input name="requestedby" type="checkbox" id="requestedby" value="49"/> Requested By </p> <p> <input name="type" type="checkbox" id="type" value="50"/> Type </p> <p> <input name="memberno" type="checkbox" id="memberno" value="51"/> Member No </p> <p> <input name="scheme" type="checkbox" id="scheme" value="52"/> Scheme </p> <p> <input name="fromtime" type="checkbox" id="fromtime" value="53"/> From Time </p> <p> <input name="fromdate" type="checkbox" id="fromdate" value="54"/> From Date </p> <p> <input name="totime" type="checkbox" id="totime" value="55"/> To Time </p> <p> <input name="todate" type="checkbox" id="todate" value="56"/> To Date </p> <p> <input name="comments" type="checkbox" id="comments" value="57"/> Comments </p> <p> <input type="submit" value="Send"> <input name="Reset" type="reset" value="Clear"> This look good, but i need the code to assist with (for example) the head of the department selects 3x tick boxes.i.e comments, username and fromtime, the information should then be taken from existing db's like..'stats' or systemletters' and then be complied in one page all together so that we can place that on a report? I hope this make sense. My wording is sometimes less understandable Please help.. I can send more info aswell if needed. (I have attached what I have come up with thus far) Thanking you in advance.

Good Afternoon, I am a newbie at php coding and sql, and I have started a site at work where the users can enter everything that they have done at work for the day including times and dates. I managed to get the information pulled through to my local DB (Wamp Server) Now I want the head of the department to be able to get reports and results from those pages using php. I am using check boxes for the head to choose what she wants to see..i.e: "<tr> <td class="grey"><p><span class="grey"> <input name="username" type="checkbox" class="User" id="username" value="48"/> User Name </span> </p> <p> <input name="requestedby" type="checkbox" id="requestedby" value="49"/> Requested By </p> <p> <input name="type" type="checkbox" id="type" value="50"/> Type </p> <p> <input name="memberno" type="checkbox" id="memberno" value="51"/> Member No </p> <p> <input name="scheme" type="checkbox" id="scheme" value="52"/> Scheme </p> <p> <input name="fromtime" type="checkbox" id="fromtime" value="53"/> From Time </p> <p> <input name="fromdate" type="checkbox" id="fromdate" value="54"/> From Date </p> <p> <input name="totime" type="checkbox" id="totime" value="55"/> To Time </p> <p> <input name="todate" type="checkbox" id="todate" value="56"/> To Date </p> <p> <input name="comments" type="checkbox" id="comments" value="57"/> Comments </p> <p> <input type="submit" value="Send"> <input name="Reset" type="reset" value="Clear"> " This look good, but i need the code to assist with (for example) the head of the department selects 3x tick boxes.i.e comments, username and fromtime, the information should then be taken from existing db's like..'stats' or systemletters' and then be complied in one page all together so that we can place that on a report? I hope this make sense. My wording is sometimes less understandable Please help.. I can send more info aswell if needed. (I have attached what I have come up with thus far) Thanking you in advance. show1.php