<TITLE>WebSmith's Concerts-we'd-like-to-see


<H1>WebSmith's Concerts-we'd-like-to-see Database</H1>

<H2>Master Concert Listing</H2>

<!-- Connect to the concerts database -->

<! msql connect >
<! msql database concerts >

<!-- Issue the query, here we are selecting all records ("*") from the
   "listings" table, placing the results in a query handle called "q1".
    This query handle will be used below to display the data. -->

<! msql query "select * from listings" q1>

<!-- Let's put the data in a table, it looks nicer -->

<TABLE border=1>

<!-- Some simple header info for the table -->


<!-- Here is where we have w3-msql display all the data retrieved from
   the query stored in the query handle "q1".
   Note the mixture of HTML and mSQL commands. Here, we
   are simply building a table "row"
   for every database "row" retrieved in the query. -->

<! msql print_rows q1
   <TD><font size=-1>@q1.0</font></TD>
   <TD><font size=-1>@q1.1</font></TD>
   <TD><font size=-1>@q1.2</font></TD>
   <TD><font size=-1>@q1.3</font></TD>
   <TD><font size=-1>@q1.4</font></TD>

<!-- When we are done, let's close
 the table properly -->


<!-- Free up the query handle -
 we are done with it -->
<! msql free q1>