courier_id consignor_name consignor_address consignor_destination consignor_phone consignee_name consignee_address consignee_destination consignee_phone s_date s_date_mm s_date_ss r_date r_date_mm r_date_ss consignment_description no_packages weight frieght_charges loading_charges unloading_charges tax amount remarks courier_status user_id consignor_email consignee_email status [image: Edit]<http://localhost:91/tbl_change.php?db=seva360&table=courier_details_tbl&token=dc325199a0d6782e1a4bbb6f96ec0ff8&primary_key=+%60courier_details_tbl%60.%60courier_id%60+%3D+1&sql_query=SELECT+%2A+FROM+%60courier_details_tbl%60&goto=sql.php> [image: Delete]<http://localhost:91/sql.php?db=seva360&table=courier_details_tbl&token=dc325199a0d6782e1a4bbb6f96ec0ff8&sql_query=DELETE+FROM+%60courier_details_tbl%60+WHERE+%60courier_details_tbl%60.%60courier_id%60+%3D+1+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dseva360%26table%3Dcourier_details_tbl%26token%3Ddc325199a0d6782e1a4bbb6f96ec0ff8%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560courier_details_tbl%2560%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_structure.php> 1 gfdsgdfs gdfsgsdf gdfsg 43534 gdfsg gfdsgs gfdsgdf 5435345 2009-10-02 05 15 0000-00-00 fadsfads 33 23 23 2 3 3 32 1 1 0 [image: With selected:]
Hi All , Above is my table structure , table name is *details_tbl<http://localhost:91/tbl_structure.php?db=seva360&table=courier_details_tbl&token=dc325199a0d6782e1a4bbb6f96ec0ff8> * <http://localhost:91/tbl_structure.php?db=seva360&table=courier_details_tbl&token=dc325199a0d6782e1a4bbb6f96ec0ff8> Am working in courier project , Once the goods despatch , then we show the staus as sent , Assume if user , track the courier after 30 day's , Then i have to show the message contact admin , If they tried with in 30 days , then i have to show message , like courier SENT / PEND / FAILED , Can u please tell the query , If the *r_date *(recive date) greater then of 30 days , they i have to show message like contact admin.... Please tell the query , Thanks
