Em Andamento

Discount tire project

Thank you for positive work on discount tire project. If you'd like to move forward on a report on customers with 3 objectives.

Have a small project where the loading of edit page is correct as shown on this link (A), except it's only 1 record showing in list despite SELECT *.

A. [url removed, login to view]

- 3 project goals

~1. Select & Print select all fields (as shown on link A) from tbl_customers & create report

- many fields are concatenated for report, easy to see

~2. Align Footer as shown in <php? require('[url removed, login to view]'); ?>

~3. Drop Down Query Selections

Would make modifications to either this file B or C:

B. /[url removed, login to view] (easy to view)

1. Modifications are farther along on the B link

2. All screen fields should update to tbl_customers. Some fields in tbl_customers are left for other/later use

C. Simple User Report Queries:

Am seeking 7 set query options that users can select just by selecting from dropdown, then (adding) a submit button

Prefer a user friendly/ few error method to allow users option to set selection by company, last name (cus_lname), & zip code.

code may be similar to section within blue brackets as shown in lines 78-97.

[predetermined queries: begin] C. /[url removed, login to view]

$sql1 = mysql_query("SELECT * FROM tbl_customers");

$sql2 = mysql_query("SELECT * FROM tbl_customers WHERE tir_name LIKE '%$tirename%' ");

$sql3 = mysql_query("SELECT * FROM tbl_customers ORDER BY cus_billingstotal");

$sql4 = mysql_query("SELECT * FROM tbl_customers ORDER BY cus_billingsytd");

$sql5 = mysql_query("SELECT * FROM tbl_customers WHERE cus_company != ' ' ");

$sql6 = mysql_query("SELECT * FROM tbl_customers WHERE cus_company LIKE '%$cuscompanypick%' ");

$sql7 = mysql_query("SELECT * FROM tbl_customers WHERE cus_email != ' ' ");

$sql8 = mysql_query("SELECT * FROM tbl_customers WHERE tir_name LIKE '%$cuspickzip%' ");

<option value="pick">Pick Sort</option>

<option value=<?php .$sql1 = mysql_query("SELECT * FROM tbl_customers"); ?>All</option>

<option value=<?php $sql2 = mysql_query("SELECT * FROM tbl_customers WHERE tir_name LIKE '%$tirename%' "); ?>All</option>

<option value=<?php $sql3 = mysql_query("SELECT * FROM tbl_customers ORDER BY cus_billingstotal"); ?>Total Billings</option>

<option value=<?php $sql4 = mysql_query("SELECT * FROM tbl_customers ORDER BY cus_billingsytd"); ?>Yearly Billings</option>

<option value=<?php $sql5 = mysql_query("SELECT * FROM tbl_customers WHERE cus_company != ' ' "); ?>Companies</option>

<option value=<?php $sql6 = mysql_query("SELECT * FROM tbl_customers WHERE cus_company LIKE '%$cuscompanypick%' "); ?>Company</option>

<option value=<?php $sql7 = mysql_query("SELECT * FROM tbl_customers WHERE cus_email != ' ' "); ?>Email</option>

<option value=<?php $sql8 = mysql_query("SELECT * FROM tbl_customers WHERE tir_name LIKE '%$cuspickzip%' "); ?>Zip Code</option>

[predetermined queries: end]

Current problem is making query term fit within the screen.

Michael

michael@[url removed, login to view]

Habilidades: HTML5, Linux, Microsoft Access, MySQL, PHP

Ver mais: simple tire, michael query, michael michael, discount, project user friendly, tire company, zip align, multiple options paypal button, friendly query, simple small project php, small project report, create multiple price options paypal button, php total project, user friendly query, small project problem, simple project report, billings, code project print order, php small submit button, simple list report php, project update query, companies zip code, small submit button php, php require view page, edit button php project

Acerca do Empregador:
( 4 comentários ) Columbus, United States

ID do Projeto: #5141672

Premiar a:

jbhasin83

Hired by the Employer

$20 USD / hora
(2 Avaliações)
2.2