Select query doesn't return the first row from the table

Asked Jun 06 '23 at 09:36

Active Jun 06 '23 at 09:57

Viewed 36 times

I have a two table joined by a certain order_id, it selects from table number 2 based on table 1. Its working but not selecting the first row of table 2 for example below its return id 6 and 7 leaving 5 whereas they share the same order_id Table2 structure

Here is the result

Is it my code or its something esle i cant seem to figure out? I am testing this on XAMPP below is my php code

if (isset($_GET['id'])) {
    $id = (int)$_GET['id'];
}
$conn = $pdo->open();
try {
    $stmt = $conn->prepare("SELECT *, invoice_address.id as invaid, invoice.id as invid FROM invoice_address LEFT JOIN invoice ON invoice.order_id=invoice_address.invoice_no WHERE invoice_address.id= :id");
    $stmt->execute(['id' =>$id]);
} catch (Exception $e) {
    $_SESSION['error'] = '.......'.$e->getMessage();
}
    
foreach($stmt as $row){
    $output .= '<tr>
        <td>'.$row["item_name"].'</td>
        <td><small>'.$row["item_no"].'</small></td>
        <td>'.$row["qty"].'</td>
        <td>R '.$row["price"].'</td>
        <td>R '.$row["amount_total"].'</td>
    </tr>';
}
echo $output;

edited Jun 06 '23 at 09:57

asked Jun 06 '23 at 09:36

the_guru

You do not `fetch` the row. – Markus Zeller Jun 06 '23 at 09:44
@MarkusZeller if i do $result = $stmt->fetchAll(PDO::FETCH_ASSOC) it gives me the same result – the_guru Jun 06 '23 at 09:47
Change to `while($row = $stmt->fetch())`. – Markus Zeller Jun 06 '23 at 09:50
@MarkusZeller they do – Your Common Sense Jun 06 '23 at 09:52
@MarkusZeller No change! – the_guru Jun 06 '23 at 09:52
`ON invoice.order_id = invoice_address.invoice_no` -> `ON invoice.order_id = invoice_address.order_id` ? – Sergey Ligus Jun 06 '23 at 09:53
Check the query itself in a DBMS. I think the JOIN is improper. Show us the table structure, please. – Markus Zeller Jun 06 '23 at 09:53
Have added an image of the table structure – the_guru Jun 06 '23 at 09:58
@YourCommonSense OMG! PDOStatement extends an iterator interface. And all the years I used manual fetch calls :) – Markus Zeller Jun 06 '23 at 09:58

Select query doesn't return the first row from the table

0 Answers0