dbconnect(); //Directs user to comproj.html if the request object comproj is true. if(request.comproj) { redirect("comproj.html?companyname=" + escape(request.companyname)) } if(request.up) { database.execute("UPDATE companies SET address = '" + request.address + "', city = '" + request.city + "', stateorprovince = '" + request.stateorprovince + "', postalcode = '" + request.postalcode + "', country = '" + request.country + "', mainphone = '" + request.mainphone + "', mainfax = '" + request.mainfax + "' WHERE companyname = '" + request.companyname + "'") redirect("company.html"); } if(request.del) { database.execute("DELETE FROM companies WHERE companyname = '" + request.companyname + "'") redirect("company.html"); } if(request.name) { company = database.cursor("SELECT * FROM companies WHERE companyname = '" + request.name +"'") //search for company by company name }

Company Information

if(company.next()) { write("") write("") write("") write("") write("") write("") write("") write("
Company Name" + company.companyname + "
Address
City
State
Zip
Country
Main Phone
Main Fax
") write("

") }