stajnert

<?php
/**
 * Function creates url properly slug from $text
 * 
 * @param string $text
 */
public function slugify($text)
{
    // replace non letter or digits by -
    $text = preg_replace('#[^\\pL\d]+#u', '-', $text);

stajnert

<?php foreach ($jobs as $i => $job): ?>
      <tr class="<?php echo fmod($i, 2) ? 'even' : 'odd' ?>">
<?php endforeach; ?>

stajnert

function getFileExtension($file_name)
{
   return substr(strrchr($file_name, '.'), 1);
}

stajnert

    /**
     * Metoda konfiguruje formularz
     */
     public function configure()
     {
        $this->widgetSchema['cities'] = new sfWidgetFormChoice(array(
                    'expanded' => true,
                    'multiple' => true,
                    'choices' => Doctrine_Core::getTable('hall')->getListNameForOpenHall(),
                    'renderer_options' => array('formatter' => array($this, 'formatter'))

stajnert

Single records:

SELECT column, COUNT(*) AS c
FROM table
GROUP BY column
HAVING COUNT(c) > 1

All records:

SELECT *

stajnert

UPDATE table SET column = REPLACE(REPLACE(column, '\r', ''), '\n', '');