Re: How to display returned rows in HTML page??

[Nick Roper]

Hi Naveen,

OK, once you have the data in the @record array you just need to print it out:

print $counter;

However, before doing that you need to generate the http headers for the page or you'll get an error. So, try :

#print the header (note the two \n\n escape sequences are importatnt - they tell the browser that the header has terminated and that what comes next is HTML)

print "Content-type: text/html\n\n";

#start the html for a table
print "<TABLE>\n";

#loop through the recorset returned by the query
while (@record = $sth->fetchrow()) {

$counter = $record[0];

print "<TR><TD>$counter</TD></TR>\n";

}

#close the html for the table
print "</TABLE>\n";


Hope this helps,

Nick

--
Nick Roper