I have three tables i want to search for customer data depending on the equipment type.
$test = "SELECT custid, equipment FROM customer WHERE custid='$id'";
$data = @mysqli_query ($dbcon, $test);
$equip = mysqli_fetch_array($data, MYSQLI_ASSOC);
if($equip['equipment'] = "cellphone" ){
// Make the query:
$q = "SELECT custid, cdate, custName, customer.equipment, customer.manufacturer, customer.model, customer.imei, notes, workdesc, hardware, status, cost, pickup_date
FROM customer
INNER JOIN cellrepair
ON customer.custid=cellrepair.cust_id
WHERE custid='$id'";
$result = @mysqli_query ($dbcon, $q); // Run the query.
$members = mysqli_num_rows($result);
if ($result) { // If it ran OK, display the records.
// Table header.
echo '<table id="result">
<tr>
<th><b>ID</b></th>
<th><b>Date</b></th>
<th><b>Name</b></th>
<th><b>Equipment</b></th>
<th><b>Manufacturer</b></th>
<th><b>Model</b></th>
<th><b>IMEI</b></th>
<th><b>Notes</b></th>
<th><b>Work Done</b></th>
<th><b>Hardware</b></th>
<th><b>Status</b></th>
<th><b>Cost</b></th>
<th><b>Pickup Date</b></th>
</tr>';
// Fetch and print all the records:
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo '<tr>
<td>' . $row['custid'] . '</td>
<td>' . $row['cdate'] . '</td>
<td>' . $row['custName'] . '</td>
<td>' . $row['equipment'] . '</td>
<td>' . $row['manufacturer'] . '</td>
<td>' . $row['model'] . '</td>
<td>' . $row['imei'] . '</td>
<td>' . $row['notes'] . '</td>
<td>' . $row['workdesc'] . '</td>
<td>' . $row['hardware'] . '</td>
<td>' . $row['status'] . '</td>
<td>' . $row['cost'] . '</td>
<td>' . $row['pickup_date'] . '</td>
</tr>';
}
echo '</table>'; // Close the table.
mysqli_free_result ($result); // Free up the resources.
}
} elseif($equip['equipment'] = "tablet" ){
// Make the query:
$q = "SELECT custid, cdate, custName, customer.equipment, customer.manufacturer, customer.model, customer.imei, notes, workdesc, hardware, status, cost, pickup_date
FROM customer
INNER JOIN cellrepair
ON customer.custid=cellrepair.cust_id
WHERE custid='$id'";
$result = @mysqli_query ($dbcon, $q); // Run the query.
$members = mysqli_num_rows($result);
if ($result) { // If it ran OK, display the records.
// Table header.
echo '<table id="result">
<tr>
<th><b>ID</b></th>
<th><b>Date</b></th>
<th><b>Name</b></th>
<th><b>Equipment</b></th>
<th><b>Manufacturer</b></th>
<th><b>Model</b></th>
<th><b>IMEI</b></th>
<th><b>Notes</b></th>
<th><b>Work Done</b></th>
<th><b>Hardware</b></th>
<th><b>Status</b></th>
<th><b>Cost</b></th>
<th><b>Pickup Date</b></th>
</tr>';
// Fetch and print all the records:
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo '<tr>
<td>' . $row['custid'] . '</td>
<td>' . $row['cdate'] . '</td>
<td>' . $row['custName'] . '</td>
<td>' . $row['equipment'] . '</td>
<td>' . $row['manufacturer'] . '</td>
<td>' . $row['model'] . '</td>
<td>' . $row['imei'] . '</td>
<td>' . $row['notes'] . '</td>
<td>' . $row['workdesc'] . '</td>
<td>' . $row['hardware'] . '</td>
<td>' . $row['status'] . '</td>
<td>' . $row['cost'] . '</td>
<td>' . $row['pickup_date'] . '</td>
</tr>';
}
echo '</table>'; // Close the table.
mysqli_free_result ($result); // Free up the resources.
}
} elseif ($equip['equipment'] != "cellphone" || "tablet") {
// Make the query:
$q = "SELECT custid, cdate, custName, customer.equipment, customer.manufacturer, customer.model, customer.serial, notes, pcrepair.workdesc, hardware, software, status, cost, pickup_date
FROM customer
INNER JOIN pcrepair
ON customer.custid=pcrepair.cust_id
WHERE custid='$id'";
$result = @mysqli_query ($dbcon, $q); // Run the query.
$members = mysqli_num_rows($result);
if ($result) { // If it ran OK, display the records.
// Table header.
echo '<table id="result">
<tr>
<th><b>ID</b></th>
<th><b>Date</b></th>
<th><b>Name</b></th>
<th><b>Equipment</b></th>
<th><b>Manufacturer</b></th>
<th><b>Model</b></th>
<th><b>Serial</b></th>
<th><b>Notes</b></th>
<th><b>Work Done</b></th>
<th><b>Hardware</b></th>
<th><b>Software</b></th>
<th><b>Status</b></th>
<th><b>Cost</b></th>
<th><b>Pickup Date</b></th>
</tr>';
// Fetch and print all the records:
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo '<tr>
<td>' . $row['custid'] . '</td>
<td>' . $row['cdate'] . '</td>
<td>' . $row['custName'] . '</td>
<td>' . $row['equipment'] . '</td>
<td>' . $row['manufacturer'] . '</td>
<td>' . $row['model'] . '</td>
<td>' . $row['serial'] . '</td>
<td>' . $row['notes'] . '</td>
<td>' . $row['workdesc'] . '</td>
<td>' . $row['hardware'] . '</td>
<td>' . $row['software'] . '</td>
<td>' . $row['status'] . '</td>
<td>' . $row['cost'] . '</td>
<td>' . $row['pickup_date'] . '</td>
</tr>';
}
echo '</table>'; // Close the table.
mysqli_free_result ($result); // Free up the resources.
}
}
else { // If it did not run OK.
// Public message:
echo 'no shit';
echo '<p class="error">The current record could not be retrieved. We apologize for any inconvenience.</p>';
// Debugging message:
//echo '<p>' . mysqli_error($dbcon) . '<br><br>Query: ' . $q . '</p>';
}
// }
?>
<p><a href="customer_search.html.php">Search Database</a></p>
</div>
I keep getting only data for cellphone and nothing else. I have tried everything but still not working. Any assistance as to how to simplified this repetitive task or correct the error.
