Simple database: Difference between revisions

Line 1,526:
#sql execute(sql$)
goto [sho]
 
 
' ------------------------------------
Line 1,558 ⟶ 1,557:
print what$
html "<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0>"
html "<TR align=center><TD>Client<br>Num</TD><TD>Name</TD><TD>Client<br>Date</TD><TD>Category</TD></TR>" ' heading
html "<TD>Client<br>Num</TD>"
html "<TD>Name</TD>"
html "<TD>Client<br>Date</TD>"
html "<TD>Category</TD>"
html "</TR>"
#sql execute(sql$)
WHILE #sql hasanswer()
Line 1,572 ⟶ 1,566:
category$ = #row category$()
 
html "<TR><TD align=right>";clientNum;"</TD><TD>";name$;"</TD><TD>";clientDate$;"</TD><TD>";category$;"</TD></TR>"
html "</TD>"
html "<TD align=right>";clientNum;"</TD>"
html "<TD>";name$;"</TD>"
html "<TD>";clientDate$;"</TD>"
html "<TD>";category$;"</TD>"
html "</TR>"
WEND
html "</TABLE>"
Anonymous user