0

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.

3
Contributors
2
Replies
16
Views
3 Years
Discussion Span
Last Post by Topnews
0

Looks to me like the IF statement only runs once, there is no looping through the returned records. So the first result = 'cellphone' and thats all you see.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.