| Customer Details |
| '; $db=dbconnect(); $sql="select *, CONCAT(fname, ' ', lname) AS aggregated_name from `customer` ORDER BY aggregated_name ASC"; $sql = "select fname, lname, CONCAT(fname, ' ', lname) AS aggregated_name, SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY id DESC), ',', 1) AS id from `customer` GROUP BY fname, lname, street, title, department, city, state, zip, phone, mobile, email, fax, status, step, product, date, baseunit, proj_desc, amount, days_to_ship, amount_2, conditions, payment_terms, comments, ordered, callback, company, request, saved_step, add2, city2, state2, zip2, email2, phone2, mobile2, fax2, is_deleted, interested_in ORDER BY aggregated_name ASC "; $rst=mysqli_query($db,$sql); echo ''; if(!empty($postFlag)){ echo ' Delete this Customer'; //echo ' New Inquiry to this Customer'; } echo ' | |
First Name: | |
Last Name: | |
Company: | |
Title: | |
Department: | |
Business: | |
Address: | |
City: | |
State: | |
Zip: | "; echo " |
Email | "; echo " |
Phone | "; echo " |
Mobile | "; echo " |
Fax | "; echo " |
CC (Spot 1) | |
Name: | |
Company: | |
Telephone: | |
Mobile: | |
E-mail: | |
CC (Spot 2) | |
Name: | |
Company: | |
Telephone: | |
Mobile: | |
E-mail: | |
CC (Spot 3) | |
Name: | |
Company: | |
Telephone: | |
Mobile: | |
E-mail: | |
CC (Spot 4) | |
Name: | |
Company: | |
Telephone: | |
Mobile: | |
E-mail: | |
Home | |
Address: | |
City: | |
State: | |
Zip: | "; echo " |
Email | "; echo " |
Phone | "; echo " |
Mobile | "; echo " |
Fax | "; echo " |
Comments | '; echo " |
| "; echo ""; echo " |