No replies to this topic

[mutago]

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
of code

sum = price + %s, row[0]  

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[0]


 sum = price + %s, row[0]  

puts "sum"

 

   

         

rescue Mysql::Error => e

    puts e.errno

    puts e.error

    

ensure

    con.close if con

end