Filter data

[DrTrans]

so I'm running a query on a database to get address's

 

$address = $row['address'];

 

it returns  "1234 Test St"

 

I want to be able to sort all the records by  the street name without the numbers

 

 

[DrTrans]

 query = "SELECT * FROM props WHERE loginid = '$loginid' AND active = '$active' ORDER BY address ASC ";

 

 

basically i want it to see what "address " and sort it by the second word ASC. 

 

 

[xyph]

You'll want to store it in it's own column. You COULD sort by first filtering the numbers out of the data, then sorting by that, but that's extremely inefficient.

[TFT2012]

I think you probably need seperate the "street" columns to like "street No." and "street Name". When you grab the both columns from database, you can perform array_multisort, like array_multisort($streetNo, SORT_DESC, $streetName, SORT_DESC);

[xyph]

Sort using SQL.

 

SELECT whatever FROM table ORDER BY streetName, streetNumber