ACCOUNTS
CONTACTS
QUOTES
">
Quote:
Name:
" size="25" maxlength="25">
Active:
>
Date In :
" size="25" maxlength="25">
Assigned to:
"; // form the query for selecting info from accounts include("db_connect.php"); $query="SELECT * FROM users"; $result = mysql_query($query); mysql_close(); // loop through all records and populate dropdown list while ($row = mysql_fetch_assoc($result)) { $acc_id = $row['id']; $acc_name = $row['user_name']; echo "
$acc_name
"; } echo ""; ?>
Account Name :
"; // form the query for selecting info from accounts include("db_connect.php"); $query="SELECT * FROM accounts ORDER BY name"; $result = mysql_query($query); mysql_close(); // loop through all records and populate dropdown list while ($row = mysql_fetch_assoc($result)) { $acc_id = $row['id']; $acc_name = $row['name']; echo "
$acc_name
"; } echo ""; ?>
Status:
"; // form the query for selecting info from accounts include("db_connect.php"); $query="SELECT * FROM status_types"; $result = mysql_query($query); mysql_close(); // loop through all records and populate dropdown list while ($row = mysql_fetch_assoc($result)) { $acc_id = $row['id']; $acc_name = $row['name']; echo "
$acc_name
"; } echo ""; ?>
Contact:
"; // form the query for selecting info from accounts include("db_connect.php"); $query="SELECT * FROM contacts ORDER BY last_name"; $result = mysql_query($query); mysql_close(); // loop through all records and populate dropdown list while ($row = mysql_fetch_assoc($result)) { $acc_id = $row['id']; $acc_first = $row['first_name']; $acc_last = $row['last_name']; echo "
$acc_last, $acc_first
"; } echo ""; ?>
Priority:
" size="25" maxlength="25">
Board Ref :
" size="25" maxlength="25">
PO #:
" size="25" maxlength="25">
Board # :
" size="25" maxlength="25">
Qty Ordered:
" size="25" maxlength="25">
Product :
"; // form the query for selecting info from accounts include("db_connect.php"); $query="SELECT * FROM product_types"; $result = mysql_query($query); mysql_close(); // loop through all records and populate dropdown list while ($row = mysql_fetch_assoc($result)) { $acc_id = $row['id']; $acc_name = $row['name']; echo "
$acc_name
"; } echo ""; ?>
Qty Shipped:
" size="25" maxlength="25">
Syntracote:
>