alias table

[bjamin021]

Hi everyone. Okay, what I have is a table of users (tbluser) with the typical fields (field name words separated with under scores). I also have another table of alias names to be used for the users table, this table has a field for english version of the fields found in the users table (with spaces between words) nices names. This table also has field for the spanish version of the fields found in the users table. Here is what I am trying to do is display the data from the users table, but allow the users of the site to select between english or spanish versions of the column headers pulled from the alias table. Side note, I also have it designed to allow the users to alpha sort columns of their choice by clicking the column header of the column they want sorted. I hope that is enough for someone to go with. I have heard this technique called alias table and also nice names. Any help with this challenge would be great. Thank you.

Ben

[zhabala]

And where you do have a problem ?

[PHPMagician]

Okay, This is an example (untested).

Have both tables the same scheme (ie. same field names) but in the table which stores the username store the username, and the field that has the alias have the translation. What I mean is that 'username' is the field name for both.

The only difference would be to have a language parameter tacked on the end of the alias table.

So, you would query like this:

<?php
$result=mysql_query("SELECT * FROM alias WHERE language='es'",$query);

$alias = mysql_fetch_array($result,MYSQL_ASSOC);


$result=mysql_query("SELECT * FROM users");

while($row = mysql_fetch_array($result))
{
    while(list($key,$value) = each($row))
    {
        echo $alias[$key] . ' : ' . $value . "<br />\n";
    }
}
?>

That is a quick hack (obviously put more work into database management). There probably is a better way of doing it, I didn't put too much though into it.