rendered paste body<html>
<head><title> Test Query </title></head>
<body>
<?php
$conn = @ db2_connect("in", "du", "is");
$user = $_POST["d"];
$pw = $_POST["is"];
$db = $_POST["in"];
$conn2 = @ pg_connect("dbname=$db user=$user password=$pw");
$part1 = "SELECT artistid FROM public.artists WHERE artist='madonna'";
$query = "SELECT BRAND_NAME, PRODUCT_ID, PRODUCT_NAME, SRP FROM public.product";
echo "Your query : <tt> $query </tt> <br><br>";
$result = db2_exec($conn, $query, array('cursor' => DB2_SCROLLABLE));
$result2 = pg_exec($conn2, $query, array('cursor'=> PG_SCROLLABLE));
$columns2 = pg_num_fields($result2);
$columns = db2_num_fields($result);
$rows2 = pg_num_rows($result2);
$rows = db2_num_rows($result);
echo "<p>The query returned $rows entries:\n";
echo "<table width=90% border=2>\n
<tr bgcolor=\"#EAECEF\"><th>#</th>";
for($i=0; $i < $columns; $i++)
echo "<th>".db2_field_name($result, $i). "</th>\n";
echo "</tr>\n<tr>";
$counter = 1;
while(db2_fetch_row($result)) {
echo "<tr>\n<td>".$counter++. "</td>";
for($i=0; $i < $columns; $i++)
echo "<td>".db2_result($result, $i)."</td>\n";
echo "</tr>\n";
}
echo "</tr></table>";
echo "<table width=90% border=2>\n
<tr bgcolor=\"#EAECEF\"><th>#</th>";
for($i=0; $i < $columns2; $i++)
echo "<th>".pg_field_name($result2, $i). "</th>\n";
echo "</tr>\n<tr>";
$counter = 1;
while(pg_fetch_row($result2)) {
echo "<tr>\n<td>".$counter++. "</td>";
for($i=0; $i < $columns2; $i++)
echo "<td>".pg_result($result2, $i)."</td>\n";
echo "</tr>\n";
db2_close($conn);
pg_close($conn2);
?>
</body>
</html>