Issue with display all results from mysql using php

Question

I use this SQL query to get results from different tables

<?
$sql = "SELECT gtem.gname AS itmnme, gvendor.gname AS vendor, gtem.col AS qty
FROM gpopackageline
LEFT JOIN gpo ON gpo.gpoid = gpopackageline.gpoid
LEFT JOIN gtem ON gpopackageline.gtemid = gtem.gtemid
LEFT JOIN gvendor ON gitem.gvendorid = gvendor.gvendorid
WHERE gpopackageline.gpoid='".$sdo['swelid']."' ";
$row = dblib_get_row_list($sql);
?>
<td class="contents51" width="100%"><?=$row['itmnme']?> </td>
<td class="contents51" width="100%"><?=$row['vendor']?> </td>
<td class="contents51" width="100%"><?=$row['qty']?> </td>

Issue is I get only 1 and first result printed. When i test query in phpmyadmin I get all the results Does anyboby can help with this Thank You

How does your dblib_get_row_list function look like?

Jonny 5
– Jonny 5

2014-01-09 14:57:17 +00:00
Commented Jan 9, 2014 at 14:57 — Jonny 5
– Jonny 5, Commented Jan 9, 2014 at 14:57
What is "dblib_get_row_list"?

dwjv
– dwjv

2014-01-09 14:57:26 +00:00
Commented Jan 9, 2014 at 14:57 — dwjv
– dwjv, Commented Jan 9, 2014 at 14:57
Maybe you need a cycle for each $row?

Pedro Monteiro
– Pedro Monteiro

2014-01-09 14:57:42 +00:00
Commented Jan 9, 2014 at 14:57 — Pedro Monteiro
– Pedro Monteiro, Commented Jan 9, 2014 at 14:57
I think it needs a loop.

Abhik Chakraborty
– Abhik Chakraborty

2014-01-09 14:57:53 +00:00
Commented Jan 9, 2014 at 14:57 — Abhik Chakraborty
– Abhik Chakraborty, Commented Jan 9, 2014 at 14:57

ʰᵈˑ · Accepted Answer · 2014-01-09 14:57:54Z

1

You need to loop through your results, either by a while, or foreach - depending on your logic.

For example

<?
$sql = "SELECT gtem.gname AS itmnme, gvendor.gname AS vendor, gtem.col AS qty
FROM gpopackageline
LEFT JOIN gpo ON gpo.gpoid = gpopackageline.gpoid
LEFT JOIN gtem ON gpopackageline.gtemid = gtem.gtemid
LEFT JOIN gvendor ON gitem.gvendorid = gvendor.gvendorid
WHERE gpopackageline.gpoid='".$sdo['swelid']."' ";
$getRows = dblib_get_row_list($sql);  //Assuming this returns everything in an assoc array
foreach($getRows as $row) {
?>
<td class="contents51" width="100%"><?=$row['itmnme']?> </td>
<td class="contents51" width="100%"><?=$row['vendor']?> </td>
<td class="contents51" width="100%"><?=$row['qty']?> </td>
<?php
}
?>

answered Jan 9, 2014 at 14:57

ʰᵈˑ

11.4k3 gold badges31 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ʰᵈˑ Over a year ago

No problem at all :) Glad to be of help.

Awlad Liton · Accepted Answer · 2014-01-09 15:02:03Z

I don't know what is your dblib_get_row_list is return. If it returns array then it should work as you expected.

 <?
    $sql = "SELECT gtem.gname AS itmnme, gvendor.gname AS vendor, gtem.col AS qty
    FROM gpopackageline
    LEFT JOIN gpo ON gpo.gpoid = gpopackageline.gpoid
    LEFT JOIN gtem ON gpopackageline.gtemid = gtem.gtemid
    LEFT JOIN gvendor ON gitem.gvendorid = gvendor.gvendorid
    WHERE gpopackageline.gpoid='".$sdo['swelid']."' ";
    $result = dblib_get_row_list($sql);
    foreach($result as $row ){
    echo "<td class='contents51' width='100%'>".$row['itmnme']."</td>";
    echo "<td class='contents51' width='100%'>".$row['vendor']."</td>";
    echo "<td class='contents51' width='100%'>".$row['qty']."</td>";

    }

Collectives™ on Stack Overflow

Issue with display all results from mysql using php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related