mehulkaklotar/DailyDabba — pull request #17 by vshukla8991 (2013-10-30 10:29:30+00:00)
Title: Commit: Changes by Vivek

I have commited whatever i have changed in project. check it. and i changed a procedure "getAllVendor" as

CREATE DEFINER=`root`@`localhost` PROCEDURE `getAllVendors`()
NO SQL
SELECT v.VendorName,v.UserName,v.Status, c.CityName, a.AreaName, v.MobileNo, v.EmailID, v.Lane, v.OwnerName, v.LandlineNo
FROM vendor v, city c, area a
WHERE v.areaID=a.areaID
AND a.CityID=c.CityID