Split Table (Newbie Question)

harris97

Hi guys....i need help please.
let say i have table in mysql like this:
ID | LANGUAGES | TEXT |
1 | English | Yes |
1 | German | Ja |
1 | French | Oui |
.........etc

What i want to do is display that records like this (Horizontally):
ID| English | German | French |...etc
1 | Yes | Ja | Oui |...etc

So..it will display records from left to right depends on how many records there are. But i don't know how to build query for that. Thanks for your help.

brandonschnell

try this:

$result = mysql_query("SELECT id, languages, text FROM table");

echo "ID";
while ($row = mysql_fetch_array ($result))
{
echo "|",$row["languages"];
$id = $row["id"];
}

echo "<BR>\n";
mysql_data_seek($result,0);

echo $id;
while ($row = mysql_fetch_array ($result))
echo "|",$row["text"];

harris97

Okay thanks that works for me...but the problem ocurs when the tables have more than one ID. for example like this :
ID | LANGUAGES | TEXT |
1 | English | Yes |
1 | German | Ja |
2 | English | No |
2 | German | Kein |

ID no.1 wouldn't display. All i need is display like this :
ID |English | German |
1 | Yes | Ja |
2 | No | Kein |

i'm sorry for requesting your correct query again because i'm so confused and stupid about this. Thanks

brandonschnell

try this:

$db = "db_prod";
$table = "test";

mysql_pconnect("localhost",$user_name,$password)
or die("Failed to Connect! Reason: ".mysql_error());

$lang_result = mysql_db_query($db,"SELECT DISTINCT languages FROM $table ORDER B
Y languages ASC");
$id_result = mysql_db_query($db,"SELECT DISTINCT id FROM $table ORDER BY id ASC"
);

echo "ID";

while ($lang_row = mysql_fetch_array ($lang_result))
echo "|",$lang_row["languages"];

echo "<BR>\n";

while ($id_row = mysql_fetch_array ($id_result))
{
$id = $id_row["id"];
echo $id;

 $text_result = mysql_db_query($db,"SELECT languages,text FROM $table where

id = $id ORDER BY languages ASC");

 mysql_data_seek($lang_result,0);

 $text_row = mysql_fetch_array ($text_result);
 while ($lang_row = mysql_fetch_array($lang_result))
      {

      if(!strcasecmp($lang_row["languages"], $text_row["languages"]))
           {
           echo "|",$text_row["text"];
           $text_row = mysql_fetch_array ($text_result);
           }
      else
           echo "|N/A";
      }

 echo "<BR>\n";
 }

harris97

You really make me happy..it works...
thanks so much for your help and kindness.