Simple HTML display of a select query

[flit]

Hi all,

How Can I do in the simplest way, display in html one table with the
return of 3 collums?
Like
1- consult mysql base
2- make the select query
3- show the values.

I am a kind of lost in the frameworks, and modules.
I think a lot of them with little documentation.
Just a simple display in html for this, nothing more.
No need this time for right coding, if I need to remake the program in
the future its ok..

 

[Larry Bates]

Hi all,

How Can I do in the simplest way, display in html one table with the
return of 3 collums?
Like
1- consult mysql base
2- make the select query
3- show the values.

I am a kind of lost in the frameworks, and modules.
I think a lot of them with little documentation.
Just a simple display in html for this, nothing more.
No need this time for right coding, if I need to remake the program in
the future its ok..

You don't do it much differently than you would to display them
on a regular screen or a piece of paper, except that you must wrap
the values in html table (not tested). I hope I'm understanding
your question.

print "<table>"
print "<th>Column 1</th><th>Column 2</th><th>Column 3></th>"
for row in rowsreturnedbysqlquery:
print "<tr><td>%s</td><td>%s</td><td>%s</td></tr>" % \
(row[0], row[1], row[2])

print "</table>

Now the fun comes when you wish to embellish this with font
sizes, colors, background colors, .... then the frameworks
come in really handy.

-Larry Bates