Hi everybody, in my database, am trying to print the value of total and then add it to the price,
i was able to fetch the value of total but when i tried to add it to to price so as to get value of sum in this line
sum = price + %s, row puts "sum"
nothing happens. where am i supposed to perform the operations, is outside the loop. below is the code, any help please
#!/Ruby19/bin/ruby require 'cgi' cgi = CGI.new puts cgi.header require "dbi" price = '100' begin # connect to the MySQL server conn = DBI.connect("DBI:Mysql:db:localhost", "root", "root566") rs = con.query("SELECT total from product where product_id = '20'") row = stmt.fetch do end puts "<font color=green size=4><b>get total values</b></font><br><br>" printf '<b>total:</b> %s<br>', row sum = price + %s, row puts "sum" rescue Mysql::Error => e puts e.errno puts e.error ensure con.close if con end