jeca

<?php 

SELECT CAST(REPLACE(prix, ' ', '') AS SIGNED) as valeur

FROM laTable 

ORDER BY valeur 

?>

<?php

  function colonneVide($nb)

  {

    return str_repeat('\'\',', $nb);

  }

//--------------------------------------------------------

//--------------------------------------------------------

//--------------------------------------------------------

//-- valeurs forcées pour voir la tête de la requête -----

  $txtdelta = 'texte delta';

  $urlimage = '\'url_image/';

  $intercab = 'intercab';

//--------------------------------------------------------



//-- il est considèré que le nom des objets correspond ---

//-- au nom des colonnes de la table ---------------------

  $separateur = '!#';

  $finLigne = '\r\n';

  $sql = 'SELECT ref, transac, type, cp, localis, ' .

                 colonneVide(5) . '

                 prix, ' .

                 colonneVide(4) . '

                 honoraire, ' .

                 colonneVide(3) . '

                 nb_piec, ' .

                 colonneVide(2) . '

                 libel, CONCAT_WS(\' - \', descr, accroche, \'' . $txtdelta . '\'), ' .

                 colonneVide(128) .

                 $urlimage . 'img1\', ' .

                 $urlimage . 'img2\', ' .

                 $urlimage . 'img3\', ' .

                 $urlimage . 'img4\', ' .

                 colonneVide(44) .

                 '\'' . $intercab . '\', ' .

                 colonneVide(136) . '

                 id_prod

          INTO OUTFILE \'leFichier.txt\'

          FIELDS TERMINATED BY \'' . $separateur . '\' OPTIONALLY ENCLOSED BY \'"\'

          LINES TERMINATED BY \'' . $finLigne . '\'

          FROM laTable';

  echo $sql;

?>

<?php

  $var = 'a=toto,b=tata,c=titi';

  $tab = explode(',', $var);



  $tableaufinal = array();

  foreach ($tab as $ligne)

  {

    $a = explode('=', $ligne);

    $tableaufinal[$a[0]] = $a[1];

  }



  echo '<pre>';

  print_r($tableaufinal);

  echo '</pre>';

?>

INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6),(...),(...)

select *

from taTable

where date_format(date_nais, '%m-%d') > date_format(curdate(), '%m-%d')

order by date_format(date_nais, '%m-%d') desc

limit 0, 5