Lesson 5

#!/bin/csh
#############################
# Report generator using MYSQL
# Solution for P1 using Mysql
#############################

mysql -u=XXXXX -D XXXXX < 'sql2.sql'  > $$tmp

 echo "<HTML><HEAD><TITLE>SQL REPORT</TITLE>"
 echo "</HEAD>" 
 echo "<BODY>"
 echo "<CENTER><H1>SQL Report</H1><CENTER>"
 echo "<CENTER><TABLE BORDER=1 BORDERCOLOR=blue BGCOLOR=#DDEEFF>"
 echo "<TR BGCOLOR=#EEDDEE><TD>Order Id</TD><TD>Product</TD><TD>Unit Price</TD><TD>Quantity</TD><TD>Amount</TD></TR>" 
  
 awk -F, '{if(NR!=1)print "<TR><TD>"$1"</TD><TD>"$2"</TD><TD>"$3"</TD><TD>"$4"</TD><TD>"$5"</TD></TR>"}' $$tmp

  echo "</TABLE></CENTER></BODY></HTML>"

rm $$tmp