How to sort by two keys (columns) in PHPMyAdmin, and how to set a default view?

[Leafgreen]

Hey there! Obviously these are newbie PHPMyAdmin questions, but hey, I gotta start somewhere, and actually I did start at http://www.phpmyadmin.net/documentation/ but didn't find the answers there. :confused:

1. How to sort by two keys (columns) when browsing a table?
2. How to set the default view of more than 30 rows when browsing a table?
3. How to change the default font size when browsing a table?

TIA! :D

[MrCoder]

1 & 2

SELECT * FROM tableName ORDER BY fieldName1, fieldName2 (ASC/DESC) (LIMIT 100)

ASC / DESC = Ascending or Descending sort. (Use one or the other)
LIMIT 100 = Only show the first 100 results, this may override the default 30 you seem to be experiencing, but it may not depending on phpMyAdmin's pagination system.


3. Make your font size bigger in the browser?

[Guezt]

In "config.inc.php" (which resides in your phpMyAdmin folder), set

$cfg['MaxRows'] = 1000;

Now phpMyAdmin will show 1000 lines by default.

[Leafgreen]

Since my post a year ago, I stopped using the very limiting and rigid phpmyadmin interface after I learned about other ways to access the db. I used EMS SQL Manager and struggled with its bugs for a few months before switching to MySQL-Front. I am very happy with it.