</table>
<?php
if ($action == 'contact') {
$msg = "Name: " . trim(stripslashes($name)) . "\n";
if ($accountrow["accountid"]) {
$msg .= "Account ID: " . $accountrow["accountid"] . "\n";
}
$msg .= "Email: " . trim($email) . "\n";
$msg .= "Phone: " . trim($phone) . "\n";
$msg .= "Company: " . trim($company) . "\n\n";
$msg .= trim(stripslashes($comments));
if (strlike($msg, "cc:")) {
$error = "Your message could not be sent. The string \"cc:\" is not allowed. Please try again.";
echo $error;
} else {
@mysql_query("INSERT INTO contacts (accountid,timestamp,name,email,phone,company,comments) VALUES (\"" . $accountrow["accountid"] . "\",\"" . mytime() . "\",\"{$name}\",\"{$email}\",\"{$phone}\",\"{$company}\",\"{$comments}\")");
mail("*****@*****.**", "coloradowaterjet.com contact", $msg);
echo "Thank you for submitting the contact form. We will get in touch with you as soon as possible.";
include 'footer.php';
exit;
}
}
?>
<p>Send us an email by using the form below or use our <a href='/quote/index.php'>Request A Quote Form</a>.</p>
function get_field_type($tablename, $fieldname)
{
$sql = "SHOW COLUMNS FROM {$tablename} LIKE '{$fieldname}'";
$result = mysql_query($sql);
$type = false;
// WE COULD TRY UNBUFFERED IF WE CAN DO THE IF STATEMENT ON $row[1]
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_row($result);
$type = $row[1];
if (strlike($row[1], "(")) {
$type = substr($row[1], 0, strpos($row[1], "("));
}
}
return $type;
}
<table width="882" height="100%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr valign="bottom"><td colspan="2" width="882" background="/images/bluestripes.gif"><img src="/images/title_main.gif"></td></tr>
<tr valign="top" height="100%"><td class="gradient_left" width="328">
<table cellpadding="0" cellspacing="0" border="0" width="100%"><tr valign="top"><td width="100%">
<img src="/images/logo_bottom.gif"><br>
<img src="/images/clear.gif" height="1" width="116">
<div class="mynav">
<?php
if (strlike($_SERVER["PHP_SELF"], "admin")) {
echo "Admin";
echo "<ul>";
echo "<li><a href='/admin/quotes.php' class=\"nav\">Quotes</a></li>";
echo "<li><a href='/admin/photos.php' class=\"nav\">Photos</a></li>";
echo "<li><a href='/admin/photos_categories.php' class=\"nav\">Photo Categories</a></li>";
echo "</ul>";
echo "<br><br><br><br>";
}
?>
<a href='/index.php' class="nav">Home</a>
<br><br>
<a href='/capabilities.php' class="nav">Capabilities</a>
<br><br>
<a href='/applications.php' class="nav">Ideal<br>Applications</a>
<br><br>
echo "<td><select name=\"status_" . $row["quoteid"] . "\" onchange=\"document.quotes.quoteid.value='" . $row["quoteid"] . "';document.quotes.submit();\">";
for ($j = 0; $j < count($vals); $j++) {
if ($vals[$j] != 'incomplete') {
echo "<option value=\"" . $vals[$j] . "\"";
if ($vals[$j] == $row[$fieldnames[$i]]) {
echo " selected=\"selected\"";
}
echo ">" . $vals[$j] . "</option>";
}
}
echo "</select></td>";
} elseif ($fieldnames[$i] == "timestamp") {
echo "<td>" . date("m-d-y H:i", $row[$fieldnames[$i]]) . "</td>";
} elseif ($fieldnames[$i] == "quoteid") {
echo "<td><a href='/admin/quote.php?quoteid=" . $row[$fieldnames[$i]] . "'>" . $row[$fieldnames[$i]] . "</td>";
} elseif (strlike($fieldnames[$i], 'materials_supplied_by_')) {
if ($row[$fieldnames[$i]]) {
echo "<td>yes</td>";
} else {
echo "<td>no</td>";
}
} else {
echo "<td>" . nl2br(formvalue($row[$fieldnames[$i]])) . " </td>";
}
echo "</tr>";
}
// DESIGN FILES
$sql = "SELECT * FROM design_files WHERE quoteid='" . $row["quoteid"] . "'";
$temp = mysql_unbuffered_query($sql);
$files = "";
while ($t = mysql_fetch_array($temp)) {
