Ordering an Output

[ecopetition]

Hello,

 

I'm trying to find a way to alphabetically order an output. I'm kind of new to PHP so this might be blindingly obvious but I just don't know what to do.

 

Feel free to probe me for info regarding the script and its context.

 

Peter

[wildteen88]

Where is the output coming from? How is the output stored within an array?

 

if its an array PHP has many functions for sorting array items, such as sort(), asort(), rsort() etc.

[ecopetition]

The output isn't from an array. It's just data taken from a database table which is just printed, but i'm wondering if the data can be processed to arrange it first.

[wildteen88]

You can use the ODERY BY column_name ASC clause in your query to sort your results by a column.

[revraz]

How are you pulling the data from the Database without using an array?

[.josh]

How are you pulling the data from the Database without using an array?

You don't need to use an array to pull or print info from a database, unless you plan on using the info later on after the loop.

 

$sql = "select col1, col2 from table";
$result = mysql_query($sql);
while ($info = mysql_fetch_row($result)) {
   echo "{$info[0]} {$info[1]} <br />";
}

 

$info is an array but it's an array of the columns/data which isn't really relevant for ordering the rows.

[ecopetition]

I dont know, I've kind of inherited this job from someone who left a project we were working on and am sort of hopeless at it just now.

 

Here's the code that is at least printing the string:

'OUTPUT'	  =>	implode(', ', $output_text[ $outputs[$i]['output_id'] ]),

 

(for the variables:)

$outputs = $output_text = array();

[wildteen88]

We'll need to see more code than that.