rsammy

thanx for ur reply! now, in this line: print("<input class='sbttn' type='submit' name='action' value='Approve for Billing' onClick=\"location.href='billingMgtList.php?approved=yes'\">"); can i use my variable as is? say something like this... print("<input class='sbttn' type='submit' name='action' value='Approve for Billing' onClick=\"location.href='billingMgtList.php?$requestforApproval=yes'\">"); ????? im still not comfy with php. need some kinda spoon feeding here!

i am trying to post some variables to the previous screen. i am trying to display fileds on current screen and then hiding and displaying a button based on a flag value from the database. this is my code... [code]                  <table width="562" border="0" cellspacing="0" cellpadding="0">                     <tr>                       <td height="49" valign="top">                         <hr>                         <? if ($visit_type == ICN) { print (" <font class='inputLbl'>STATUS: </font><font class='plnTxtBl'>$visit_status </font><br> <font class='inputLbl'>VISIT DATE:</font><font class='plnTxtBl'> $dcn_dov </font><br> <font class='inputLbl'>VISIT TIME:</font><font class='plnTxtBl'> $visit_time </font><br> <font class='inputLbl'>ATTENDING PROVIDER:</font><font class='plnTxtBl'> $phy_fname  $phy_lname  </font><br> <font class='inputLbl'>LOCATION:</font><font class='plnTxtBl'> $visit_loc </font><br> <font class='inputLbl'>ROOM NUMBER:</font><font class='plnTxtBl'> $visit_room_no </font><br> <font class='inputLbl'>DIAGNOSIS: </font><font class='plnTxtBl'>$diag_diag </font><br> <font class='inputLbl'>PROCEDURE: </font><font class='plnTxtBl'>$proc_proc </font><br> <font class='inputLbl'>MEDICATION: </font><font class='plnTxtBl'>$med_med </font><br> <font class='inputLbl'>IMAGING: </font><font class='plnTxtBl'>$dcn_img </font><br> <font class='inputLbl'>FOLLOW UP NOTES: </font><font class='plnTxtBl'>$dcn_foll </font><br> <font class='inputLbl'>SEE CONSULTANT: </font><font class='plnTxtBl'>$dcn_cons </font><br> <font class='inputLbl'>SEE PROVIDER: </font> <font class='plnTxtBl'>$dcn_doc </font><br> <font class='inputLbl'>TRANSACTION ID:</font><font class='plnTxtBl'> $visit_palm_db_id </font><br><br><br><br><br><br><br><br><br> <font class='inputLbl'>POSTED FOR BILLING:</font><font class='plnTxtBl'> &nbsp;&nbsp;&nbsp;&nbsp;$dcn_posted_for_billing </font><br> <font class='inputLbl'>APPROVED FOR BILLING:</font><font class='plnTxtBl'> $dcn_approved_for_billing </font><br><br><br> "); if ($dcn_posted_for_billing =="No") { if ($dcn_approved_for_billing =="Yes") { $requestforApproval='No'; print("<input class='sbttn' type='submit' name='action' value='Remove from Billing Batch' onClick=\"location.href='billingMgtList.php'\">"); } else { $requestforApproval='Yes'; print("<input class='sbttn' type='submit' name='action' value='Approve for Billing' onClick=\"location.href='billingMgtList.php'\">"); } } else { $requestforApproval='Yes'; } } ?>                       <p>&nbsp;</p></td>                     </tr>                   </table></td>                 <td width="15">&nbsp;</td>               </tr>               <tr>                 <td width="15">&nbsp;</td>                 <td width="15">&nbsp;</td>               </tr>               <tr>                 <td width="15" height="85"><img src="../images/clear.gif" width="15" height="8"></td>                 <td width="15" height="85"><img src="../images/clear.gif" width="15" height="1"></td>               </tr>               <tr>                 <td colspan="3" height="2"> <div align="center">                     <form name="fax" method="post" action="PrintRecorddetails.php" onSubmit="return validate()">                       <div align="center">                         <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#666666">                           <tr>                             <td>&nbsp;</td>                             <td>&nbsp;</td>                           </tr>                         </table>                         <p>                           <input type="hidden" name="visit_id" value="<? print ("$visit_id"); ?>">                           <input type="hidden" name="visit_type" value="<? print ("$visit_type"); ?>">                           <input type="hidden" name="visit_time" value="<? print ("$visit_time"); ?>">                           <input type="hidden" name="visit_status" value="<? print ("$visit_status"); ?>">                           <input type="hidden" name="visit_loc" value="<? print ("$visit_loc"); ?>">                           <input type="hidden" name="visit_loc" value="<? print ("$visit_room_no"); ?>">                           <input type="hidden" name="pat_first_name" value="<? print ("$pat_first_name"); ?>">                           <input type="hidden" name="pat_last_name" value="<? print ("$pat_last_name"); ?>">                                                  <input type="hidden" name="pat_phy_id" value="<? print ("$pat_phy_id"); ?>">                           <input type="hidden" name="phy_fname" value="<? print ("$phy_fname"); ?>">                           <input type="hidden" name="phy_lname" value="<? print ("$phy_lname"); ?>">                           <input type="hidden" name="pat_dob" value="<? print("$pat_dob"); ?>">                           <input type="hidden" name="pat_ssn" value="<? print("$pat_ssn"); ?>">                           <input type="hidden" name="pat_sex" value="<? print ("$pat_sex");  ?>">                           <input type="hidden" name="enter_date" value="<? print ("$enter_date");  ?>">                           <input type="hidden" name="activate_date" value="<? print ("$activate_date");  ?>">                                                    <input type="hidden" name="visit_timestamp_received" value="<? print ("$visit_timestamp_received");  ?>">                           <input type="hidden" name="visit_palm_db_id" value="<? print ("$visit_palm_db_id");  ?>">   <input type="hidden" name="username" value="<? print ("$USER_NAME");  ?>">   <input class="sbttn" type="submit" align="center" name="action" value="Print-Friendly Page">                         </p>                       </div>                     </form>                   </div></td>               </tr>             </table></td>         </tr>       </table>       <p>&nbsp;</p></td>   </tr>   <tr>     <td align="left" valign="top" width="276"> </td>     <td colspan="3" width="624">&nbsp;</td>   </tr> </table>[/code] is this code correct? in this code - how do i post the value of "$requestforApproval" to billingMgtList.php in this block of code: if ($dcn_posted_for_billing =="No") {       if ($dcn_approved_for_billing =="Yes")       { $requestforApproval='No'; print("<input class='sbttn' type='submit' name='action' value='Remove from Billing Batch' onClick=\"location.href='billingMgtList.php'\">");       }       else       { $requestforApproval='Yes'; print("<input class='sbttn' type='submit' name='action' value='Approve for Billing' onClick=\"location.href='billingMgtList.php'\">"); }       }       else       {             $requestforApproval='Yes';       } I am stuck here. not sure if i can do a post here. if yes, how can i? i need to post the value for the variable "$requestforApproval" to billingMgtlist.php i also need to post another couple of variables too from the same block of code. is thispossible? if yes, how? if not, alternatives? help pleeeeeeaaaaaaaase ???

i am actually able to post the variable now! it carries the current value in the database. but i shud be able to change the flag value when i click on the button! where shud i change the value. not sure where exactly in the code shud i assign or change the value of the flag so i can update using the update qeury after i post it.

where do i put this javascript code?

i am able to get the values in both pages. but, i need to update the flag(s) as either Yes or No based on button clicked and send control back to same page(previous page where we came from) when either of the button is clicked. is thispossible? to send control back to same page irrespective of which button is clicked. i have one update query and it works. how do i do it for the other button and where?

sorry bout that. i created another thread. and ive used the # tags in that. ill lock this topic. please help me out in the other one!!!

i am working on a php module where in i have to set a flag to either YES or No. Based on this flag, I need to display the records from teh database on the next screen. I have two flags in dcn table called:  dcn_approve_for_billing and dcn_posted for billing. both flags are defaulted to 'no' initially. i have a page, billingMgt.php where I am displaying all records and also displaying the dcn_approved_for_billing flag. also on the record is a link that will enable me to expand the record and view the details(clicking on this link takes me to RecordDetails.php page). in this page, I have two buttons, Approve for Billing and Remove from Billing. these buttons are enabled or grayed out based on values of the two flags in the dcn table. and also displaying the dcn_approved_for_billing flag. also on the record is a link that will enable me to expand the record and view the details(clicking on this link takes me to RecordDetails.php page). in this page, I have two buttons, Approve for Billing and Remove from Billing. these buttons are enabled or grayed out based on values of the two flags in the dcn table. this is the code for enabling disabling buttons based on the flag values... it works fine: [code]<form name="fax" method="post" action="billingMgt.php" onSubmit="return validate()"> <div align="center"> <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#666666"> <tr> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </table> <p> <input type="hidden" name="visit_id" value="<? print ("$visit_id"); ?>"> <input type="hidden" name="visit_type" value="<? print ("$visit_type"); ?>"> <input type="hidden" name="visit_time" value="<? print ("$visit_time"); ?>"> <input type="hidden" name="visit_status" value="<? print ("$visit_status"); ?>"> <input type="hidden" name="visit_loc" value="<? print ("$visit_loc"); ?>"> <input type="hidden" name="visit_loc" value="<? print ("$visit_room_no"); ?>"> <input type="hidden" name="pat_first_name" value="<? print ("$pat_first_name"); ?>"> <input type="hidden" name="pat_last_name" value="<? print ("$pat_last_name"); ?>"> <input type="hidden" name="pat_phy_id" value="<? print ("$pat_phy_id"); ?>"> <input type="hidden" name="phy_fname" value="<? print ("$phy_fname"); ?>"> <input type="hidden" name="phy_lname" value="<? print ("$phy_lname"); ?>"> <input type="hidden" name="pat_dob" value="<? print("$pat_dob"); ?>"> <input type="hidden" name="pat_ssn" value="<? print("$pat_ssn"); ?>"> <input type="hidden" name="pat_sex" value="<? print ("$pat_sex");  ?>"> <input type="hidden" name="enter_date" value="<? print ("$enter_date");  ?>"> <input type="hidden" name="activate_date" value="<? print ("$activate_date");  ?>"> <input type="hidden" name="visit_timestamp_received" value="<? print ("$visit_timestamp_received");  ?>"> <input type="hidden" name="visit_palm_db_id" value="<? print ("$visit_palm_db_id");  ?>"> <input type="hidden" name="username" value="<? print ("$USER_NAME");  ?>"> <input type="hidden" name="approved_for_billing" value="<? print ("$dcn_approved_for_billing");  ?>">         <? if ($dcn_posted_for_billing =="Yes") { ?> <input name="action" type="submit" class="sbttn" value="Approve for Billing" disabled="disabled"> <? } else if ($dcn_approved_for_billing =="Yes") { ?> <input name="action" type="submit" class="sbttn" value="Approve for Billing" disabled="disabled"> <? } else { ?> <input class="sbttn" type="submit" name="action" value="Approve for Billing"> <? } ?> </p> </div> </form> <form name="fax" method="post" action="billingMgt.php" onSubmit="return validate()"> <div align="center"> <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#666666"> <tr> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </table> <p> <input type="hidden" name="visit_id" value="<? print ("$visit_id"); ?>"> <input type="hidden" name="visit_type" value="<? print ("$visit_type"); ?>"> <input type="hidden" name="visit_time" value="<? print ("$visit_time"); ?>"> <input type="hidden" name="visit_status" value="<? print ("$visit_status"); ?>"> <input type="hidden" name="visit_loc" value="<? print ("$visit_loc"); ?>"> <input type="hidden" name="visit_loc" value="<? print ("$visit_room_no"); ?>"> <input type="hidden" name="pat_first_name" value="<? print ("$pat_first_name"); ?>"> <input type="hidden" name="pat_last_name" value="<? print ("$pat_last_name"); ?>"> <input type="hidden" name="pat_phy_id" value="<? print ("$pat_phy_id"); ?>"> <input type="hidden" name="phy_fname" value="<? print ("$phy_fname"); ?>"> <input type="hidden" name="phy_lname" value="<? print ("$phy_lname"); ?>"> <input type="hidden" name="pat_dob" value="<? print("$pat_dob"); ?>"> <input type="hidden" name="pat_ssn" value="<? print("$pat_ssn"); ?>"> <input type="hidden" name="pat_sex" value="<? print ("$pat_sex");  ?>"> <input type="hidden" name="enter_date" value="<? print ("$enter_date");  ?>"> <input type="hidden" name="activate_date" value="<? print ("$activate_date");  ?>"> <input type="hidden" name="visit_timestamp_received" value="<? print ("$visit_timestamp_received");  ?>"> <input type="hidden" name="visit_palm_db_id" value="<? print ("$visit_palm_db_id");  ?>"> <input type="hidden" name="username" value="<? print ("$USER_NAME");  ?>"> <input type="hidden" name="approved_for_billing" value="<? print ("$dcn_approved_for_billing");  ?>"> <? if ($dcn_posted_for_billing =="Yes") { ?> <input name="action" type="submit" class="sbttn" value="Remove from Billing Batch" disabled="disabled"> <? } else if ($dcn_approved_for_billing =="Yes") { ?> <input class="sbttn" type="submit" name="action" value="Remove from Billing Batch"> <? } else { ?> <input name="action" type="submit" class="sbttn" value="Remove from Billing Batch" disabled="disabled"> <? } ?> </p> </div> </form>[/code] Here, when i click on the Approve for Billing button, I need to change the defaulted flag dcn_approved_for_billing to 'Yes' and display the billingMgt.php screen again showing 'Yes' for the Approve for Billing field which was 'No' the first time round. Also, if I click on Remove from Billing button on RecordDetails.php page(this is enabled only if value for dcn_approve_for_billing flag is set to 'Yes'), the flag value should be changed back to 'No' and that should again be displayed on the billingMgt.php screen. In other words, I need to pass the value back to the previous screen. the situation here is, two diiferent buttons on one screen when clicked, change the value of the same flag(dcn_approve_for_billing) and take me to the same page (billingMgt.php) that was the first page in the chain!! I need help in passing this changed flag value to the next/previous page - billingMgt.php from RecordDetails.php page. I am stuck at this point and not able to move any further. shud i write a funtion or something like that in php that'll return a Yes or No for the flag when button is pressed? if yes, how do i do it? ditto with javascript???!!! thanx in advance

sorry, i dont c the # button. when i highlight the whole code and press # on my keyboard it overwrites it!

sorry, didnt get u??? ???

i am working on a php module where in i have to set a flag to either YES or No. Based on this flag, I need to display the records from teh database on the next screen. I have two flags in dcn table called:  dcn_approve_for_billing and dcn_posted for billing. both flags are defaulted to 'no' initially. i have a page, billingMgt.php where I am displaying all records and also displaying the dcn_approved_for_billing flag. also on the record is a link that will enable me to expand the record and view the details(clicking on this link takes me to RecordDetails.php page). in this page, I have two buttons, Approve for Billing and Remove from Billing. these buttons are enabled or grayed out based on values of the two flags in the dcn table. this is the code for enabling disabling buttons based on the flag values... it works fine: <form name="fax" method="post" action="billingMgt.php" onSubmit="return validate()"> <div align="center"> <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#666666"> <tr> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </table> <p> <input type="hidden" name="visit_id" value="<? print ("$visit_id"); ?>"> <input type="hidden" name="visit_type" value="<? print ("$visit_type"); ?>"> <input type="hidden" name="visit_time" value="<? print ("$visit_time"); ?>"> <input type="hidden" name="visit_status" value="<? print ("$visit_status"); ?>"> <input type="hidden" name="visit_loc" value="<? print ("$visit_loc"); ?>"> <input type="hidden" name="visit_loc" value="<? print ("$visit_room_no"); ?>"> <input type="hidden" name="pat_first_name" value="<? print ("$pat_first_name"); ?>"> <input type="hidden" name="pat_last_name" value="<? print ("$pat_last_name"); ?>"> <input type="hidden" name="pat_phy_id" value="<? print ("$pat_phy_id"); ?>"> <input type="hidden" name="phy_fname" value="<? print ("$phy_fname"); ?>"> <input type="hidden" name="phy_lname" value="<? print ("$phy_lname"); ?>"> <input type="hidden" name="pat_dob" value="<? print("$pat_dob"); ?>"> <input type="hidden" name="pat_ssn" value="<? print("$pat_ssn"); ?>"> <input type="hidden" name="pat_sex" value="<? print ("$pat_sex");  ?>"> <input type="hidden" name="enter_date" value="<? print ("$enter_date");  ?>"> <input type="hidden" name="activate_date" value="<? print ("$activate_date");  ?>"> <input type="hidden" name="visit_timestamp_received" value="<? print ("$visit_timestamp_received");  ?>"> <input type="hidden" name="visit_palm_db_id" value="<? print ("$visit_palm_db_id");  ?>"> <input type="hidden" name="username" value="<? print ("$USER_NAME");  ?>"> <input type="hidden" name="approved_for_billing" value="<? print ("$dcn_approved_for_billing");  ?>">   <? if ($dcn_posted_for_billing =="Yes") { ?> <input name="action" type="submit" class="sbttn" value="Approve for Billing" disabled="disabled"> <? } else if ($dcn_approved_for_billing =="Yes") { ?> <input name="action" type="submit" class="sbttn" value="Approve for Billing" disabled="disabled"> <? } else { ?> <input class="sbttn" type="submit" name="action" value="Approve for Billing"> <? } ?> </p> </div> </form> <form name="fax" method="post" action="billingMgt.php" onSubmit="return validate()"> <div align="center"> <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#666666"> <tr> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </table> <p> <input type="hidden" name="visit_id" value="<? print ("$visit_id"); ?>"> <input type="hidden" name="visit_type" value="<? print ("$visit_type"); ?>"> <input type="hidden" name="visit_time" value="<? print ("$visit_time"); ?>"> <input type="hidden" name="visit_status" value="<? print ("$visit_status"); ?>"> <input type="hidden" name="visit_loc" value="<? print ("$visit_loc"); ?>"> <input type="hidden" name="visit_loc" value="<? print ("$visit_room_no"); ?>"> <input type="hidden" name="pat_first_name" value="<? print ("$pat_first_name"); ?>"> <input type="hidden" name="pat_last_name" value="<? print ("$pat_last_name"); ?>"> <input type="hidden" name="pat_phy_id" value="<? print ("$pat_phy_id"); ?>"> <input type="hidden" name="phy_fname" value="<? print ("$phy_fname"); ?>"> <input type="hidden" name="phy_lname" value="<? print ("$phy_lname"); ?>"> <input type="hidden" name="pat_dob" value="<? print("$pat_dob"); ?>"> <input type="hidden" name="pat_ssn" value="<? print("$pat_ssn"); ?>"> <input type="hidden" name="pat_sex" value="<? print ("$pat_sex");  ?>"> <input type="hidden" name="enter_date" value="<? print ("$enter_date");  ?>"> <input type="hidden" name="activate_date" value="<? print ("$activate_date");  ?>"> <input type="hidden" name="visit_timestamp_received" value="<? print ("$visit_timestamp_received");  ?>"> <input type="hidden" name="visit_palm_db_id" value="<? print ("$visit_palm_db_id");  ?>"> <input type="hidden" name="username" value="<? print ("$USER_NAME");  ?>"> <input type="hidden" name="approved_for_billing" value="<? print ("$dcn_approved_for_billing");  ?>"> <? if ($dcn_posted_for_billing =="Yes") { ?> <input name="action" type="submit" class="sbttn" value="Remove from Billing Batch" disabled="disabled"> <? } else if ($dcn_approved_for_billing =="Yes") { ?> <input class="sbttn" type="submit" name="action" value="Remove from Billing Batch"> <? } else { ?> <input name="action" type="submit" class="sbttn" value="Remove from Billing Batch" disabled="disabled"> <? } ?> </p> </div> </form> Here, when i click on the Approve for Billing button, I need to change the defaulted flag dcn_approved_for_billing to 'Yes' and display the billingMgt.php screen again showing 'Yes' for the Approve for Billing field which was 'No' the first time round. Also, if I click on Remove from Billing button on RecordDetails.php page(this is enabled only if value for dcn_approve_for_billing flag is set to 'Yes'), the flag value should be changed back to 'No' and that should again be displayed on the billingMgt.php screen. In other words, I need to pass the value back to the previous screen. the situation here is, two diiferent buttons on one screen when clicked, change the value of the same flag(dcn_approve_for_billing) and take me to the same page (billingMgt.php) that was the first page in the chain!! I need help in passing this changed flag value to the next/previous page - billingMgt.php from RecordDetails.php page. I am stuck at this point and not able to move any further. thanx in advance

than you!!!

thanx for replying guys! this is what i'm doing in the confirmation page... $PatientEmployer=$_POST["PatientEmployer"]; shud i change this to... $PatientEmployer=$_POST["PatientEmployer"]; i tried that but, it gives a my_sql error. it shows up correctly on the confirmation page as Jay's  - but does not store it in the database!!! how do i disable magic_quotes_gpc ???

i am entering data in a field on screen. i update patients info on a screen. i enter Jay's restaurant in one of the fields. the next screen is a confirmation screen that shows Jay\'s as the value entered for this field. however, in the database, it is stored properly. when i do a qeury and pull this patient up the next time, it shows up as Jay's!!! how do i prevent it from showing Jay\'s on the confirmation screen?

im trying the exact same syntax u gave me here... do i need to include any quotes(" or ') before or after each & sign? i tried passing variables exactly same way u showed my here... <a href = 'somepage.php?var1=value1&var2=value2&var3=value3'>blah</a> but, it shows up as ... compose.php?m1=$m1&d1=$d1&y1=$y1&m2=$m2&d2=$d2&y2=$y2 when i point on the hyperlink! am i wrong somewehre. i know i am,...but not sure where

thanx crayon violet. i know i can use the GET thingy there. but, i need to know how to pass the m1, d1 y1, etc variables other than the mesg_id ... stuff. i only need to pass the month, day and year variabls and not the message id... hope im clear now!

i am working on an email module as part of a patient application. i need to post some date variables/parameters via one of the ahref links on the screen. my code for this bit is here... <tr> <td> <div align="left">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="images/selectedfolder-icon.gif"          width="16" height="13">Inbox </div></td> </tr> <tr>  <td> <div align="left">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="images/selectedfolder-icon.gif"          width="16" height="13">Sent Items </div></td> </tr> <tr> <td> <div align="left">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="images/compose-button.gif"            width="21" height="15"><a href="compose.php">Compose</a></div></td> </tr> in the above code, i need to pass some variables via the Compose ahref link. how do i do that? i am looking for something similar to ... <tr> <td><a href="view.php<?PHP             print("?mess_id=".$rowz["ID"]. "&m1=".$m1. "&d1=".$d1 . "&y1=".$y1. "&m2=".$m2 . "&d2=".$d2 . "&y2=".$y2 . "&incount=".$inboxcounter . "&sentcount=".$sentcounter  ); ?>"><?PHP print($rowz["subject"]); ?> </a> </td> </tr> i will need to pass the m1,  d1, y1 and m2, d2, y2 variables to compose.php ahref link in the code above. any help will be greatly appreciated. thanx

thanx a lot friend. it worked. appreciate ur help ;D

i am working on a patient application for a doc. i am working on a module where when i enter a patient info, the system first generates a 13 digit patient number - starting with the character 'P' and followed by 12 numerics - for this newly entered patient. i then have to update the patients info - name, address, contact info, ssn, etc. on another screen. now, before i update the patient info (or even while i am doing it) i need to store this system generated patient # along with the newly entered valid ssn in a new table - just for the record. the table that has the patient info is pat_info. and i want to maintain a history of patient #s created and overwritten in another table called temp_pat_ssn_history table. i can do this if i can differentiate between these two patient #s (temp 13 digit ssn and valid ssn). now, how do i differentiate the temporary, system generated pat # in php? in javascript i remember there is a length funtion. how do i do this in php though? any help with be greatly appreciated. thanx in advance

thanx, kenrbnsn! it worked!

OK. so how do i send in the date as YYYY-MM-DD format as $datebox now contains date in  MM/DD/YYYY format? Since the formats dont match, my database shows the value for pat_reg_date as 0000-00-00 00:00:00  :(  and does not show any numbers! help pleeeeeaaaaaase

i am trying to enter the date of registration into a table. i know mysql takes data in YYYY-MM-DD format. I have a field - pat_reg_date set up as timestamp. i am posting a date(entered on a previous screen) and entering this into the database. this is $datebox and it contains date in the MM/DD/YYYY format. now in my query ... INSERT INTO pat_dgraphics (pat_first_name, pat_mid_init, pat_last_name, pat_add, pat_city, pat_state, ..., pat_dob, pat_sex, pat_mar_sta, ...,  pat_reg_date, pat_client_id) VALUES('$PatientFirstName', '$PatientMiddleInitial','$PatientLastName', '$PatientAddress', '$PatientCity', '$PatientState',..., '$pat_dob_reformat', '$PatientSex', '$PatientMaritalStatus',..., '$datebox', '$client_id')" ; How do i send in a formatted date here?

thanx sir! but, the button does doesnt show up! i mean... how do i make the button show up and make it work? still need help

[quote author=legendx link=topic=117677.msg480272#msg480272 date=1165464954] <a href="<?=$_SERVER['HTTP_REFERER']?>">Back</a> http://us3.php.net/manual/en/reserved.variables.php Hope that helps. [/quote] thanx for replying, legendx. but, can u help me more? how can i use ur statement in my code? i'll have to use it in header...

i need help adding a BACK button in a php page. i just need to send control back to the previous page this is the code for a Reply button on the page: header("Location: compose.php?mess_id=".$_POST["mess_id"]. "&reply=".$_POST["reply"]. "&m1=".$_POST["m1"]."&d1=".$_POST["d1"]."&y1=".$_POST["y1"]."&m2=".$_POST["m2"]."&d2=".$_POST["d2"]."&y2=".$_POST["y2"]."&inboxcounter=".$_POST["inboxcounter"]."&sentcounter=".$_POST["sentcounter"]); I just need to add another button - Back button and transfer control back to the previous page. how do i do that? i know there is a code like javascript:window.history.back(-1) but, how do i incorporate it in this code. thanx in advance

i am working an application that involves sending and receiving emails from the system. the existing system shows email ids, subject and details in the inbox screen - say, [email protected]. these three items are shown as links and cliking the link will load the email body. here is the existing code : [code=php:0] if ($user_auth == "2") {   $queryz="SELECT message, user_id, status, from_p, subject,   DATE_FORMAT(received, '%m/%d/%Y') as date, ID, to_email, time_sent, grp_id FROM messages WHERE received >='$dbdates' and    received <='$dbdate' order by ID DESC ";   $querysent="SELECT messages.message, messages.user_id, messages.status, messages.from_p, messages.subject, DATE_FORMAT   (messages.received, '%m/%d/%Y') as date, messages.ID, messages.to_email, messages.time_sent, messages.grp_id FROM   messages, sent_messages WHERE messages.received >='$dbdates' and messages.received <='$dbdate' and messages.id =   sent_messages.message_id and sent_messages.user_id='$userid' order by messages.ID DESC"; } else {   $queryz = "SELECT message, user_id, status, from_p, subject, DATE_FORMAT(received, '%m/%d/%Y') as date, ID, to_email,   time_sent, grp_id FROM messages WHERE request !='settodelete' AND user_id='$userid'  and received >='$dbdates' and received   <='$dbdate' order by ID DESC ";   $querysent="SELECT messages.message, messages.user_id, messages.status, messages.from_p, messages.subject, DATE_FORMAT   (messages.received, '%m/%d/%Y') as date, messages.ID, messages.to_email, messages.time_sent, messages.grp_id FROM   messages, sent_messages WHERE messages.request !='settodelete' AND messages.user_id='$userid' and messages.received   >='$dbdates' and messages.received <='$dbdate' and messages.id = sent_messages.message_id and sent_messages.user_id='$userid'   order by messages.ID DESC"; }   $resultz = mysql_query($queryz);   $num_rowz = mysql_num_rows($resultz);   $rowz= mysql_fetch_array($resultz);   $inboxcounter = $num_rowz;   $from_p = $rowz["from_p"]; HTML display: <tr>   <td colspan="2" bordercolor="#006699" bgcolor="#0089B7"></td>   <td width="34" bordercolor="#006699" bgcolor="#0089B7"></td>   <td width="231" bordercolor="#006699" bgcolor="#0089B7"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"             color="#FFFFFF"><b>From</b></font></td>   <td width="175" bordercolor="#006699" bgcolor="#0089B7"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"             color="#FFFFFF"><b>Subject</b></font></td>   <td width="107" bordercolor="#006699" bgcolor="#0089B7"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"             color="#FFFFFF"><b>Received</b></font></td>   <td width="13" bordercolor="#006699" bgcolor="#0089B7"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"             color="#FFFFFF">&nbsp;</font></td> </tr> <?PHP $num_results=mysql_num_rows($resultz); $i=1; if(!isset($rowNum)) { $rowNum = 0; } $rowNumHold = $rowNum; $count = 1; $limit_results = 25; if ($num_rowz > 0) {   for($q=0;$q<$limit_results && $rowNum < $num_rowz;$q++)   {       if(mysql_data_seek($resultz, $rowNum++))       { if ($i++%2) {   print ("<tr  bgcolor=\"#cccccc\">"); } else {   print ("<tr>"); } if ($rowz = mysql_fetch_array($resultz)) { ?>   <td colspan="2">&nbsp;</td>   <td>     <?PHP if($rowz["status"] == 1) {   print("<img src=\"images/unopened-icon.gif\" width=\"18\" height=\"18\" border=\"0\">"); } else {   print("<img src=\"images/opened-icon.gif\" width=\"18\" height=\"18\" border=\"0\">"); } ?> <td><a href="view.php<?PHP               print("?mess_id=".$rowz                                        ["ID"]. "&m1=".$m1. "&d1=".$d1 . "&y1=".$y1. "&m2=".$m2 . "&d2=".$d2 . "&y2=".$y2 . "&incount=".$inboxcounter . "&sentcount=".$sentcounter );                                 ?>" >         <?PHP print($rowz["from_p"]); /*$queryfrom = "SELECT user_fname, user_lname, user_email FROM user_mgr WHERE                                       user_email='$from_p' "; //echo "$query"; $resultfrom = mysql_query($queryfrom); $rowfrom = mysql_fetch_array($resultfrom); //print($queryfrom); $fname= $rowfrom["user_fname"]; $lname=$rowfrom["user_lname"]; //$uname = $user_fname ." ". $user_lname; $uname = $fname ." ". $lname; print ($uname); */       ?></a></td> <td><a href="view.php<?PHP print("?mess_id=".$rowz["ID"]. "&m1=".$m1. "&d1=".$d1 . "&y1=".$y1. "&m2=".$m2 . "&d2=".$d2 . "&y2=".$y2 . "&incount=".$inboxcounter . "&sentcount=".$sentcounter  ); ?>"><?PHP print($rowz["subject"]); ?></a></td>   <td><a href="view.php<?PHP print("?mess_id=".$rowz["ID"]. "&m1=".$m1. "&d1=".$d1 . "&y1=".$y1. "&m2=".$m2 . "&d2=".$d2 . "&y2=".$y2 . "&incount=".$inboxcounter . "&sentcount=".$sentcounter  ); ?>"><?PHP print($rowz["date"]."&nbsp;&nbsp;".$row["time_sent"]); ?></a></td>       <!--<a href=\"Recorddetails.php?visit_id=$row->visit_id&visit_type=ICN&client_id=$row->client_id&visit_status=$row->visit_status&visit_loc=$row->visit_loc&pat_first_name=$row->pat_first_name&pat_last_name=$row->pat_last_name&phy_fname=$row->phy_fname&phy_lname=$row->phy_lname&pat_dob=$row->pat_birthday&pat_ssn=$row->pat_ssn&pat_sex=$row->pat_sex\">$row->diag_diag</a>-->   <td colspan="8">&nbsp;</td> </tr> <?         }   } } ?> [/code] ********** i was trying execute a qeury at thepoint where we are displaying from_p(email address of sender) to display name of the sender(code that i left commented there). something is wrong inthis code. it displays thename but, it displays the same name (the name on top of the list) for all the emails irrespective of whom it came from. i need help in fixing this. any help will be greatly appreciated.