[RESOLVED] Data from two different tables

[Ali_baba]

Hello,
I am trying to take data from two different tables. They are not related to each other by any means.

Here is my code:

$result = mysql_query("SELECT display, IPA, time FROM users WHERE username= '$username' 
UNION 
SELECT * from translations where lang = '$lang'");
while ($array = mysql_fetch_array($result))  {
....

Actually I am trying to get the real name (display) and IP address (IPA) from users table and the translations (*) from the translations table based on the brower language (lang). The lang variable is comming from the previous script. And I don't know how to take the data from two different table using one query.

Thanks in advance 🙂

[Ali_baba]

Never mind. I solved it.

like this:

$result = mysql_query("SELECT display, IPA, time FROM users WHERE username= '$username'");
while ($array = mysql_fetch_array($result))  {
  $result1 = mysql_query("SELECT * FROM translations WHERE lang= '$lang'");
  while ($array1 = mysql_fetch_array($result1))  {
...............