passing multiple table value by a single function

[eluser]John_Betong[/eluser]
 
 
Here is a BIG KLUDGE to get the job doe and move on to your next problem

Code:

<?php
$sql['query1'] = array('apples','pears','bananas','coconuts','cherries','strawberries','guava','mango','pineapples','melon');
$sql['query2'] = array('OAK','PINE','CEDAR','BEECH','WALNUT','WILLOW','BIRCH','LARCH','HAZEL','HOLLY');
$sql['query3'] = array($sql['query1'], $sql['query2']);
$max   = count($sql['query1']);
echo '<ol>';
    for($i2=0; $i2<$max;    $i2++)
    {
        echo "<li>";
            echo     $sql['query3'][0][$i2];
        echo '</li>';
    
        echo '<li style="color:red">';
            echo     '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
        echo     $sql['query3'][1][$i2];
        echo '</li>';
    }
echo '</ol>';
?&gt;

 
 
 
Output:

Code:

.

   1. apples
   2.      OAK
   3. pears
   4.      PINE
   5. bananas
   6.      CEDAR
   7. coconuts
   8.      BEECH
   9. cherries
  10.      WALNUT
  11. strawberries
  12.      WILLOW
  13. guava
  14.      BIRCH
  15. mango
  16.      LARCH
  17. pineapples
  18.      HAZEL
  19. melon
  20.      HOLLY