On September 26, 2009 05:10:23 am bharani kumar wrote: > 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_t >bl&token=dc325199a0d6782e1a4bbb6f96ec0ff8&primary_key=+%60courier_details_tb >l%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&to >ken=dc325199a0d6782e1a4bbb6f96ec0ff8&sql_query=DELETE+FROM+%60courier_detail >s_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%2Bha >s%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 Getting answers to your questions is easier if you can show you have done a little backround work to try to find the answer. Case in point: http://lmgtfy.com/?q=datediff+in+mysql
Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
