sorting from database

[mus]

hi some people can help me im new in php. i want to sorting nummer in my table nam ( row)

 

$result = mysql_query("SELECT * FROM opi ordre by row desc")

 

 

have i done this right code

[requinix]

Almost. Take a closer look at what you typed.

 

And use

 tags when you post PHP code.

[IrOnMaSk]

just typo mistake

<?php
$result = mysql_query("SELECT * FROM opi order by row desc");//error message can go here after ;

 

[mus]

hi IrOnMaSk

<?php$result = mysql_query("SELECT * FROM opi order by row desc");//error message can go here after ;

 

i now this code will be error but i dont now how i can make this can some people help me

[voip03]

You need tp put  space between <? php and $result

<? $result = mysql_query("SELECT * FROM opi order by row desc"); 

[mus]

yes but code is not work please help me thanks

 

but thanks for help voip03

 

[WebStyles]

you have a row called row? that sounds weird and it's probably a mysql reserved name.

 

try this, but replace TABLE with your table name, and ROW with your row name (leave the backticks)

 

 

$result = mysql_query("select * from `TABLE` order by `ROW` desc");

 

[mus]

thanks you this code work good but if i want to have small nummer first.examples 1, ,2, 3,4 not 4, 3, 2, 1,

 

 

thanks

[WebStyles]

remove the word 'desc' from the query.

[voip03]

Sort by ASC or DESC

http://php.about.com/od/learnmysql/p/SQL_order_by.htm

[mus]

thanks u very much  WebStyles and voip03

 

[voip03]

please mark as solved. the topic solved button can be found at the bottom left of the page.

thank you