[SOLVED] Question of ordering!!!

[jomagi]

Hi there!

 

I'm using MySQL 5.0.67, and I'm bilding a website with php.

 

I want to order the data by initial letter of the content, but not ascending or descending but order by letter J, then C, then W, then O and the others letters dont matter because just have with this initial letters. It's for displaying the data by styles in the php page, with the jazz style in top.

 

Thanks for the help!

 

[Mchl]

http://imthi.com/blog/programming/mysql-order-by-field-custom-field-sorting.php

[fenway]

Just not that that code does NOT deal with the situation where there are other values in your list other than the ones your explicit "rank" -- careful.

[Mchl]

I suppose that FIELD() will return 0 for those, so they'll be grouped at the top in order of primary key.

[jomagi]

Hi try but dont work and for what I understand this is for ordering by field name and what I need is ordering the records with base in the field "estilo" and that appear on top the "Jazz" records Letter "J", next the records beggining letter "C", next beggining letter "W" and for last letter "O".

 

Thanks for the help!

[Mchl]

Try:

SELECT * FROM table ORDER BY FIELD(SUBSTRING(estilo,1,1),"J","C","W","O")

[fenway]

I suppose that FIELD() will return 0 for those, so they'll be grouped at the top in order of primary key.

Yup... so you have to order using an "inverted" FIELD()....

[jomagi]

Dont work!!!

 

mysql_select_db($database_dargil_site, $dargil_site);
$query_listdestaques = "SELECT * FROM destaques ORDER BY FIELD(SUBSTRING(estilo,1,1),"J","C","W","O")";
$listdestaques = mysql_query($query_listdestaques, $dargil_site) or die(mysql_error());
$row_listdestaques = mysql_fetch_assoc($listdestaques);
$totalRows_listdestaques = mysql_num_rows($listdestaques);
?>

 

This is the code I have in this moment!

Thanks

[Mchl]

Of course it doesn't.

 

You're using double quotes in double quoted string. Either escape them, or enclose the string in single quotes. (Or change internal quotes to single quotes)

$query_listdestaques = "SELECT * FROM destaques ORDER BY FIELD(SUBSTRING(estilo,1,1),"J","C","W","O")";

 

[jomagi]

That resolve the problem!

 

Thankyou very much and keep the good work!