[Resolved] Displaying All Query Results

[obrienkev]

The following result only displays one set of results.

How do I get it to display all results in database??

$query="select * 
  from subfund as s
inner
  join director as d
    on s.director_ID = d.director_ID
inner
  join client as c
    on s.client_ID = c.client_ID
inner
  join contact as co
    on s.contact_ID = co.contact_ID
inner
  join domicile as dm
    on s.domicile_ID = dm.domicile_ID
inner
  join entity as e
    on s.entity_ID = e.entity_ID
inner
  join manager as m
    on s.manager_ID = m.manager_ID";


$result = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($result);


$items = array();

while ($row = mysql_fetch_assoc($result))
{
$items[] = $row;
}


$currentRow=4;

foreach ($items as $item)
{
         $array_to_write = array($item['client'], $item['director'], $item['manager'], $item['subfund']);
         $cart->writeRow($currentRow, 0, $array_to_write);
         $currentrow++;
} 

[bpat1434]

select * from subfund

~Brett

[obrienkev]

What should I change this to??

[bpat1434]

From:

$query="select *
  from subfund as s
inner
  join director as d
    on s.director_ID = d.director_ID
inner
  join client as c
    on s.client_ID = c.client_ID
inner
  join contact as co
    on s.contact_ID = co.contact_ID
inner
  join domicile as dm
    on s.domicile_ID = dm.domicile_ID
inner
  join entity as e
    on s.entity_ID = e.entity_ID
inner
  join manager as m
    on s.manager_ID = m.manager_ID";

To:

$query="select *
  from subfund";

~Brett

[obrienkev]

Thanks! Don't know how I didn't spot that. Yesterday was a slow day!!

Anyway prolem now is that it just displays the last entry in the database table and nothing else.

Why is this??

Thanks again!

Kevin.

[bpat1434]

$currentRow = 0;

while ($row = mysql_fetch_assoc($result))
{
    $array_to_write = array($row['client'], $row['director'], $row['manager'], $row['subfund']);
    $cart->writeRow($currentRow, 0, $array_to_write);
    $currentRow++;
}

~Brett