Display data by alphabetical order

[RON_ron]

I want to pull the mysql data in an alphabetical order suburbz. This code is not getting the results in an alphabetical order. Please help.

 

$SomeVar = $_POST['disloc'];
$query = "SELECT * FROM  books WHERE statez = '".$SomeVar."' ORDER BY suburbz ASC";
$results = mysql_query($query);

[Rifts]

try

 

$SomeVar = $_POST['disloc'];
$query = "SELECT * FROM  books WHERE statez = $SomeVar ORDER BY suburbz ASC";
$results = mysql_query($query);

[RON_ron]

No luck as yet!!

[Rifts]

post the error you get.

[RON_ron]

NO data was shown.

[the182guy]

I want to pull the mysql data in an alphabetical order suburbz. This code is not getting the results in an alphabetical order. Please help.

 

$SomeVar = $_POST['disloc'];
$query = "SELECT * FROM  books WHERE statez = '".$SomeVar."' ORDER BY suburbz ASC";
$results = mysql_query($query);

 

Use mysql_error() to get a description of the problem. It's most likely either the table or a field name is wrong or the data that is being posted contains bad chars and is causing the query to break due to not escaping the string before putting it in the query.

[chintansshah]

Can you tell me what you get in $_POST['disloc']?

 

No data found then problem with your input.

 

Please try query without WHERE, if you get correct output what you expect then you have problem with inputs.

 

$query = "SELECT * FROM  books ORDER BY suburbz ASC";
$results = mysql_query($query);

[RON_ron]

the182guy: Typical asian answers! Thanks! 

[fenway]

the182guy: Typical asian answers! Thanks! 

So, solved?