taz321

As i believe i have the correct Date/Time format, would anyone have an idea on how i can find the difference in time with the following fields - Date/time submitted AND Date/time completed Many Thanks in advance.

I have changed my system so that the DATE-TIME is in this format - $today = date("F j, Y, g:i a"); // March 10, 2001, 5:16 pm This is an okay format to use for what i need ? Thanks

Okay thanks, im going to go through my system now and place the date and time in one field, once iv done that i will come back lol Cheers

Hi I was wondering if anyone had an answer to my question. I have 4 fields in my table called - dateactioned timeactioned datecompleted timecompleted The format of the date is - e.g Thursday, 12, March 2008 AND the time is - 22:10 I require a calculation which works out the difference between the two sets of dates and time. Thank you in advance for any help

Hi Was wondering if i could get a quick hand in this, i have an email facility in my program which automatically send emails. Now i am spending too much time getting the look of the email right and am not getting anywhere, i am trying to get bold texts around the main headings in the email by putting the <b>, </b> but they just appear on the actual message. Does anyone have a idea on the code for bold text and aligning texts. Many Thanks This is my code $to = "gds@googlemail.com"; $subject = "Technical Query Progress"; $body = "Dear Client\n There has been an amendment made in your submitted Query \n \n Enquiry Number ".$formID."\n Issue Title ".$issuetitle."\n System Affected ".$systemaffected."\n\n Issue Details by the Client\n ".$issuedetails."\n Analyst Support Comments\n ".$supportcomments."\n\n Priority Level ".$prioritylevel."\n\n Status of Query ".$status."\n Thank You Jupiter Development Support Analyst ... This is an automated message, PLEASE DO NOT REPLY

Thanks for all your help, im going to implement this now Thanks

Does anyone know have an idea on my sql question ? Thanks

Just a quick question. I need the email to read from 2 tables, which are: - Client Form From client i would need - email From Form i would need - issuetitle, systemaffected, issuedetails & supportcomments. Would i need to join the two tables together in the SQL statement and create another table in my database to show this? Any suggestions how i could do this ? Thanks

The database is set up in a file called "connect.php" so i would put the following code on top of what you've given me. require "connect.php"; Il try that and see where i get.. Thanks

Hi Im not quite understanding the code given above. I have looked at a few different sites and have seen this code come up a few times <?php $to = "someone@example.com"; $subject = "Test mail"; $message = "Hello! This is a simple email message."; $from = "someonelse@example.com"; $headers = "From: $from"; mail($to,$subject,$message,$headers); echo "Mail Sent."; ?> But i want the $to, $subject and $message to read from the database instead of me hardcoding it (like above). Any ideas how i could do this. Thanks in advance.

Thanks for your help, im going to try and adapt that into my system. Cheers

Sorry this is the code - <a href="mailto:??"> Im developing this is PHP, mysql if thats what you mean. Thanks

Sorry may have worded it badly. Didnt mean to sound like i wanted it done for me, im just at a lost with this and just wanted some advice on how to go about doing it. This is the code i have already - <a href="mailto:??"> but not sure how i would express the code here to read from the database. Thanks

Hi Iv developed a help desk system and want an section in the system where a user would inform a client of the progress of their query by emailing them. I believe Dreamweaver (which i am using to design my system) has this as a feature but not the way i would like it. Within my system is stored (Client table) the clients contact details such as email address. I would like to email that particular client with their email address from the database pre-filled in when i click on the email button with details of the query filled in as well (all read from the database) I hope thats clear. Any help would be appreciated. Thanks

Thanks, i guess i need to create another as you mentioned to get this working..Il have ago at it and see where i get. Thanks

Hi I was wondering if i can get some help on this please. 1) I have developed a help desk system, where a client would login and fill in an blank form and submit it. 2) I would like the systems administrator to assign the tasks to the users. 3) An user would then login and see queries ONLY assigned to them. How would i go about getting the admin user to assign these tasks. The tables i have which would hopefully make are - Employee (the users of the system) Form (Where clients submit their query to) Any help would be appreciated

excellent Thanks, iv changed it to viewed now so hopefully that should work.

This is my SQL statement This displays all queries in the works queue. Thanks

I have just inserted a new row called read in my database and my SQL query is fine, but my system is not accepting it. Any reason ? Is mySQL quite volatile to new rows been inserted halfway through Thanks

Sorry, i was having a memory lapse, after thinking about it, it seems alot more clearer. Thanks, i think i can manage now

Yeh i saw the response to my last post and i got the sql bit working now (dumb i know lol). Im not quite understanding whether or not it was answered in my last post. Basically i will have 4 screens. 1) one screen will contain all the queries that have been issued. 2) The other 3 screens will each contain a list of queries relating to their status. eg one screen will contain all resolved, another pending and another unresolved. 3) Basically in point one, i want to give all queries an status, and once that happens id want that query to dissappear from that screen so it looks like that all the queries have been answered, a blank screen would mean all queries have been answered. Im sure its a simple sql query if i think about it ?

Hi I was wondering if anyone can help me - 1) I have a helpdesk system where a user would fill in an blank query form and submit to a works queue. 2) Another user would go into the works queue and see a list of queries. 3) They would then click on a particular query and open it. 4) They would view the query and add their own comments to the form (so updating that record) and give it an status level either resolved, unresolved or pending. 5) Once a status level is given i want that query to dissappear from the works queue as it would now be viewed on another screen i.e If pending chosen for status then it will be viewed in the pending screen. Now basically i want a query removed from the work's queue once a status level as been given I hope this is clear, any help would be grateful Thanks

Sorry i think i may have confused you with the code. I need the GET method there because i am updating the form. Basically when a user fills in a form they would submit it. Analyst would open that query and give it an status level from a drop down box and then clicks submit (so he is updating the query he opened by inserting extra data for that particular record). From the code you have given me, it looks alot more clearer but once a status level is given and then submitted would the query iv just submitted be removed from the work queue as it doesn't need to be there anymore ?

I have form checking code below, just need the code which would send a particular query which has been given as status level to be submitted to php pages - resolved.php, unresolved.php & pending.php <?php require "connect.php"; $formID = $_GET['formID']; $issuetitle = $_GET['issuetitle']; $datesubmitted = $_GET['datesubmitted']; $timesubmitted = $_GET['timesubmitted']; $systemaffected = $_GET['systemaffected']; $prioritylevel = $_GET['prioritylevel']; $issuedetails = $_GET['issuedetails']; $supportcomments = $_GET['supportcomments']; $clientFname = $_GET['clientFname']; $clientSurname = $_GET['clientSurname']; $teamname = $_GET['teamname']; $clientID = $_GET['clientID']; $status = $_GET['status']; $dateactioned = $_GET['dateactioned']; $timeactioned = $_GET['timeactioned']; $analystFname = $_GET['analystFname']; $analystSname = $_GET['analystSname']; if($prioritylevel == "Please Select") { $message1 = "Please select the issue topic"; header("Location: analystformedit.php?message1=$message1"); exit(); } if($status == "Please Select") { $message2 = "Please enter the system affected"; header("Location: analystformedit.php?message2=$message2"); exit(); } if($supportcomments == "") { $message3 = "Please enter details of the problem"; header("Location: analystformedit.php?message3=$message3"); exit(); } $query = "update form set issuetitle ='".$issuetitle."', datesubmitted ='".$datesubmitted."', timesubmitted ='".$timesubmitted."', systemaffected ='". $systemaffected."', prioritylevel ='".$prioritylevel."', issuedetails ='".$issuedetails."', supportcomments ='".$supportcomments."', clientFname ='".$clientFname."', clientSurname ='".$clientSurname."', teamname ='".$teamname."', clientID ='".$clientID."', status ='".$status."', dateactioned = '".$dateactioned."', timeactioned = '". $timeactioned."', analystFname = '".$analystFname."', analystSname = '".$analystSname."' where formID =".$formID; $result = mysql_query($query, $connection) or die ("Unable to perform query<br>$query"); header("Location: enquiryscreen.php?var=formID"); exit(); ?>

Hi I am developing an helpdesk system, a user would fill in an blank form and submit to a work queue (workqueue.php) An analyst would see the list of queries and open one of them, he would then give a query a status, either resolved, unresolved or pending. What im wanting is that the analyst to give a query a status level but once submitted that query would then leave the work queue and join another php page called resolved.php. I hope this is straight forward, this is a major bit of my system and am not understanding how to do it. Any help would be appreciated Thanks