Multiple column ordering in Zend Framework

There are different ways to multiple column ordering in Zend. Following are two different ways to do multiple column ordering in Zend Framework. you can use either First way OR Second way.

First Way

->order(array('first_name asc','last_name desc'));

Second Way

->order('first_name asc')->order('last_name desc')

In above code snippet, First It will sort by first_name in ascending order then sort by last_name in descending order. you can also add more than two column in ordering.


Multiple column ordering in MySQL

select * from users order by first_name asc, last_name desc

First It will sort by first_name in ascending order then sort by last_name in descending order.

Best Related Posts are Following:

1. Zend framework Disable the layout and Change the Layout in ZF1.
2. Zend Framework How to delete a table row from foreach loop.
3. Zend framework pagination with array adapter - with code snippets.
4. Youtube v3 API Sample API Requests and Response - Search Videos - Get Video Details.
5. How to set authorization header in Curl using zend framework.
6. How to delete the Zend Cache files from server.
7. How to send an email using Email Template in Zend Framework.
8. Get Youtube video-details and comments using PHP.
9. How to send Attachment in Email in zend framework1 - Send PDF File.
10. How to send Email in Zend Framework - HTML Email.
11. Send Email from Gmail SMTP using Zend Framework.
12. Google trends api php - How to get hot trends.
13. Multiple column ordering in Zend Framework.
14. Current time zone for a city- Free API.
15. Zend Gdata Youtube API - Search Video - View Video Detail.
16. Download Videos from Amazon S3 - PHP.
17. How to set Cron in Zend Framework.
18. Zend Cache Tutorial - Zend Framework 1.12.
19. Zend Framework Interview Questions and Answers for Experienced.
20. Zend Framework Interview Questions and Answers.
21. Zend Framework - Free Google Analytics API.
22. Zend_Filter_Input - Zend_Filter - Zend Framework.
23. PHP Upload File In Amazon S3 Bucket - Code Snippets.
24. Difference Between Zend framework 2 VS Zend framework 1.
25. Zend Database Query - Zend Profiler Example - Code Snippets.

mysql_fetch_field - Get column information from a result

object mysql_fetch_field ( resource $result [, int $field_offset = 0 ] )

Get column information from a result and return as an object

Returns an object containing field information. This function can be used to obtain information about fields in the provided query result.


<?php
$conn = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$conn) {
    die('Could not connect to mysql server: ' . mysql_error());
}mysql_select_db('database'); //setup of database$result = mysql_query('select * from table');
if (!$result) {
    die('MySql Error: ' . mysql_error());
}/* get column metadata */$i = 0;
while ($i < mysql_num_fields($result)) {
    echo "Information for column $i:<br />\n";
    $meta = mysql_fetch_field($result, $i);
    if (!$meta) {
        echo "No information available<br />\n";
    }
    echo "<pre>
blob:         $meta->blob
max_length:   $meta->max_length
multiple_key: $meta->multiple_key
name:         $meta->name
not_null:     $meta->not_null
numeric:      $meta->numeric
primary_key:  $meta->primary_key
table:        $meta->table
type:         $meta->type
unique_key:   $meta->unique_key
unsigned:     $meta->unsigned
zerofill:     $meta->zerofill
</pre>";
    $i++;
}mysql_free_result($result);?>

Best Related Posts are Following:

1. PHP 7 new features.
2. What is session_set_cookie_params.
3. imagecreatefrompng - Create a new image from file or URL - PHP.
4. count_chars - Count Number of character of string with PHP.
5. Check if string contains specific words - PHP.
6. New features of PHP 5.5 with Examples.
7. New features of PHP 5.4 with Examples.
8. How To Track the Real IP Address Behind the Proxy - PHP - REMOTE_ADDR.
9. date_sunrise - Returns time of sunrise for a given day and location.
10. Convert image to Binary Data and vice versa in PHP.
11. Difference between in_array and array_key_exists in php with Example.
12. get_class_vars PHP Function.
13. get_class_methods PHP Function.
14. mysql_fetch_field - Get column information from a result.
15. PHP mktime() Function - Get Unix timestamp for a date.
16. Strtolower - Returns string with all alphabetic characters converted to lowercase.
17. PHP file_get_contents Function - Reads entire file into a string.
18. PHP utf8_encode Function - Encodes an ISO-8859-1 string to UTF-8.
19. com_create_guid Generate a globally unique identifier.
20. spl_autoload What is spl_autoload function in php.
21. parse_ini_string - Parse a configuration string.
22. stream_socket_client - Open Internet or Unix domain socket connection.
23. imagecopyresampled-Copy and resize part of an image with resampling.
24. What is proc_close.
25. What is str_getcsv.
26. spl autoload extensions in PHP.
27. Parse a binary IPTC block into single tags.
28. Perform a regular expression search and replace.
29. fputcsv - Write in CSV File with PHP.
30. realpath - Get the Real path of File with PHP.
31. ob_get_level -Return the nesting level of the output buffering mechanism.
32. openssl decrypt - Decrypts data.
33. Domain Name Server.
34. iterator_apply - Call a function for every element in an iterator - PHP.
35. openssl private encrypt.
36. openssl_pkcs12_read.
37. mb_check_encoding.
38. imagegrabwindow.
39. imagealphablending.
40. Gets options from the command line argument list.
41. Embeds binary IPTC data into a JPEG image.
42. session_set_save_handler.
43. mcrypt_encrypt.
44. imagegrabscreen.
45. imagecreatefromjpeg.
46. stat Gives information about a file - PHP.
47. fsockopen Open Internet or Unix domain socket connection- PHP.
48. intval - Get Integer value from string in PHP.
49. register_shutdown_function.
50. setcookie - Store Cookie in Browser with PHP.
51. header_remove - Remove the Header.
52. proc_open.
53. ucwords - Uppercase the first character of each word in a string.
54. getimagesize -Get the size of an image - PHP.
55. phpinfo - Outputs information about PHP's configuration.
56. spl_autoload_register.
57. json_encode - Returns the JSON representation of a value.
58. mcrypt_decrypt.
59. PHP Magic Methods with Examples.