Below you can find a simple update statement for PHP in Joomla!

$db =& JFactory::getDBO();
$query = "UPDATE #__courseinfo SET courseQuota =". $quota." WHERE id=".$row- >courseCode ;
echo"$query";
$db->setQuery( $query );
$db->query();