6
votes

Ordre personnalisé MySQL par ordre alphabétique par:

J'utilise la requête suivante:

$query = "SELECT * FROM `$table[$a]` ORDER BY FIELD(typeof,'pdf','swf','img','web')";

php mysql

0 commentaires

3 Réponses :

10
votes

SELECT * FROM `$table[$a]` 
ORDER BY 
  FIELD(typeof,'pdf','swf','img','web'), --first order by type
  filename  --then by filename

0 commentaires

2
votes

$query = "SELECT * FROM `$table[$a]` ORDER BY FIELD(typeof,'pdf','swf','img','web'), name ASC";
Not sure if that'll work

0 commentaires

2
votes

... ORDER BY FIELD(typeof,'pdf','swf','img','web'), name

0 commentaires