PhpMyadmin Help

[hope@hope.com]

Hi All

Hope this is the right group

I'm using phpmyadmin
When I start up phpmyadmin it list my
table fields like

v_255_1
v_255_2
v_255_10
v_255_3
v_255_15
v_255_4

What I want is to sort it so it list them like
v_255_1
v_255_2
v_255_3
v_255_4
v_255_10
v_255_15


How can I do this please

Regards

John

[Janwillem Borleffs]

[email]hope@hope.com[/email] wrote:

> What I want is to sort it so it list them like
> v_255_1
> v_255_2
> v_255_3
> v_255_4
> v_255_10
> v_255_15
>
>
> How can I do this please
>

Here's a quick hack for the left navigation that I have tested on version
2.5.6:

Open the mysql_wrappers.lib.php file in the libraries/ directory and replace
the PMA_mysql_tablename function with the following:

function PMA_mysql_tablename($result, $i) {
global $sorted_tables, $num_tables;
if (!is_array($sorted_tables)) {
$ordered = array();
$sorted_tables = array();
for ($x = 0; $x < $num_tables; $x++) {
$ordered[] =
PMA_convert_display_charset(mysql_tablename($resul t,
$x));
}
natcasesort($ordered);
foreach ($ordered as $name) {
$sorted_tables[] = $name;
}
}
return $sorted_tables[$i];
}


This hack does not fix the sorting issue with the db_details_structure.php
file, but I'm sure that you will post again when you need help with this too
;-)


JW

[hope@hope.com]

Hi Jw

Thank you for the script , yes it worked great for the left panel view

BUT that was not the problem

1.....I start Phpmyadmin

2.....On the left panel I have all my data bases

3.....Click on one of my data bases

4.....Now in the left panel I see all my tables

5....Click on one of the tables

6....Now in the right panel I see all the structure for that table

7....Under the fields I have all my field names

8....This is where I wanted to sort them in order like

v_255_1
v_255_2
v_255_3
v_255_4
v_255_10
v_255_15

Regards

John





On Sun, 9 May 2004 01:59:19 +0200, "Janwillem Borleffs" <jw@jwscripts.com> wrote:

>hope@hope.com wrote:

>> What I want is to sort it so it list them like
>> v_255_1
>> v_255_2
>> v_255_3
>> v_255_4
>> v_255_10
>> v_255_15
>>
>>
>> How can I do this please
>>

>
>Here's a quick hack for the left navigation that I have tested on version
>2.5.6:
>
>Open the mysql_wrappers.lib.php file in the libraries/ directory and replace
>the PMA_mysql_tablename function with the following:
>
>function PMA_mysql_tablename($result, $i) {
> global $sorted_tables, $num_tables;
> if (!is_array($sorted_tables)) {
> $ordered = array();
> $sorted_tables = array();
> for ($x = 0; $x < $num_tables; $x++) {
> $ordered[] =
> PMA_convert_display_charset(mysql_tablename($resul t,
>$x));
> }
> natcasesort($ordered);
> foreach ($ordered as $name) {
> $sorted_tables[] = $name;
> }
> }
> return $sorted_tables[$i];
>}
>
>
>This hack does not fix the sorting issue with the db_details_structure.php
>file, but I'm sure that you will post again when you need help with this too
>;-)
>
>
>JW
>
>
>

[Janwillem Borleffs]

[email]hope@hope.com[/email] wrote:

> 8....This is where I wanted to sort them in order like
>
> v_255_1
> v_255_2
> v_255_3
> v_255_4
> v_255_10
> v_255_15
>

Not sure if this is what you mean, but try the following patch:

- In the mysql_wrappers.lib.php file, add the following function:

function PMA_natcasesort($array) {
natcasesort($array);
return array_values($array);
}

- In the tbl_query_box.php file, above line 155, insert the following call:

$fields_list = PMA_natcasesort($fields_list);


HTH;
JW

[Janwillem Borleffs]

Janwillem Borleffs wrote:

> Open the mysql_wrappers.lib.php file in the libraries/ directory and
> replace the PMA_mysql_tablename function with the following:
>

Here's an improved implementation of this function:

function PMA_mysql_tablename($result, $i) {
global $sorted_tables, $num_tables;
if (!is_array($sorted_tables)) {
$sorted_tables = array();
for ($x = 0; $x < $num_tables; $x++) {
$sorted_tables[] = PMA_convert_display_charset(
mysql_tablename($result, $x)
);
}
natcasesort($sorted_tables);
$sorted_tables = array_values($sorted_tables);
}
return $sorted_tables[$i];
}


JW

[bradfordh@gmail.com]

If I am using phpMyAdmin, how would I execute the command "mysql
--local-infile" ?

[Jerry Stuckle]

[email]bradfordh@gmail.com[/email] wrote:

> If I am using phpMyAdmin, how would I execute the command "mysql
> --local-infile" ?
>

Please see my update to your previous question on this topic.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[email]jstucklex@attglobal.net[/email]
==================