$criteria = new Criteria();
$criteria->addAscendingOrderByColumn('salary');
// Fetch all the records from the 'employees' table
$employees = EmployeeQuery::create()->add($criteria)->find();
In this example, we create a new Criteria object and add the addAscendingOrderByColumn method with the 'salary' parameter to the object. We then pass this Criteria object to the EmployeeQuery class and use the find() method to fetch all the records from the 'employees' table.
Package library:
The addAscendingOrderByColumn method is a part of Propel, which is an open-source Object-Relational Mapping (ORM) library for PHP. It provides an easy-to-use interface to interact with the database and generates SQL queries based on the database schema.<?php
$c = new Criteria();
$c->AddAscendingOrderByColumn(CuentaPeer::NOMBRE);
$cuentas = CuentaPeer::doSelect($c);
$optCuenta[""] = "";
foreach ($cuentas as $cuenta) {
$optCuenta[$cuenta->getId()] = $cuenta->getNombre();
}
echo select_tag('alumno[fk_cuenta_id]', options_for_select($optCuenta, $alumno->getFkCuentaId()));
