I have an sql database with table_invoices, fields `invoice` and `date`. I have a form with two text fields, "invoice" and "date". When user enters invoice #, I want the date to automatically appear when match found. Can some1 give me an idea of a php code for this? and also changes if they change invoice number or to null if invoice unknown, or page refresh. Thanks.