reference inside the same table...???

thedream

Hi there,

I am loosing my mind. I can't remeber how to separate inside the same TABLE and to display it how you want with a simple query.

Imagine this simple query:

SELECT * from ichat ORDER BY name ASC

in my table it is like this one:

id - name - address - lang
1 - name1 - address 1 - lang1
2 - name2 - address 2 - lang2
3 - name3 - address 3 - lang1
etc...

The trick is how would be able to do a loop, that could give me:

lang1
-name 1
-name 3

lang 2
-name2
etc...

BUT, because this is the most important part:
For all the languages (lang field) i will have in my table (I can't predict how much) I would be able to display separately, all the fields for EACH languages as the example upside. And to do a layout in PHP as I want.

Please help, I can't remember how to do that....

Marc

barand

First you need to ORDER BY lang so all names for each language are together in the output

SELECT lang, name from ichat ORDER BY lang, name

Then loop through the results and output the language when it changes.

last = '';
while (list($Lang, $name) = mysql_fetch_row($result)) {

     if ($lang != $last) echo $lang, '<br>';
     $last = $lang;

     echo ' - ', $name, '<br>';
}

devinemke

$result = mysql_query('SELECT * from ichat ORDER BY name');
while ($row = mysql_fetch_assoc($result))
{
	$array[$row['lang']][$row['id']] = $row;
}
print_r($array);

thedream

Thank you to both of you, but nothing working !

The first code give the id as lang !?! and they are not grouped by lang.
The second one gives nothing !.

I'm always looking for a solution...

tsinka

Hi,

did you change the query like suggested by barand ?

Alternatively, try this one if you need the other fields like id, too:

$result = mysql_query("SELECT * from ichat ORDER BY lang,name";
$last = "";
while ($row = mysql_fetch_array($result)) { 
  $lang = $row['lang'];
  $name = $row['name'];

  if ($lang != $last) {
    echo $lang, '<br>'; 
    $last = $lang; 
 }

  echo ' - ', $name, '<br>'; 
}

Thomas

thedream

thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you, thank you !

Thank you Tsinka, you great !

But how can I separate the first $lang from the second, etc.. to put them in an HTML table for my layout. I was thinking to an array, but how to include it in your code?

And could you explain it?

Marc 🙂

tsinka

To build a simple array you can do something like this:

<?PHP
$result = mysql_query("SELECT * from ichat ORDER BY name");

$data = array();
while ($row = mysql_fetch_assoc($result)) { 
  $lang = $row['lang'];
  $name = $row['name'];
  $id   = $row['id'];
  $data[$lang][$id] = $name;
}

// just to test
print_r($data);
?>

print_r prints an array in a readable way. You can use the array $data to display the table. The code devinemke posted should work.

Thomas

thedream

yes, it was a mistake of my part sorry, i'm trying your last code...
thank you

marc

thedream

I am loosing my mind....

What I want to be able to is:
To have the number of different 'lang',
and to have the ability to publish only all the 'name' of the 4th 'lang'.

How can I do that?

MArc

thedream

pictures are better than words some time, go there and you will see what I want exactly:
iChat Rooms Listing

Looking for your answer

tsinka

Ok,

so you want to take the data from ichat and display it in a way like e.g.:

lang1       lang2       lang3
  name1_1     name2_1     name3_1
  name1_2     name2_2     name3_2
  name1_3

lang4       lang5       lang6
  name4_1     name5_1
              name5_2

And you want to have links to e.g. the aim url to that chat rooms and that url/address is stored in the field "address" ?

Thomas

thedream

Yes, you absolutely right, my tiny website will be correct and up to date ! Could you help me?

tsinka

Hi,

I had some lot of work to do the last days so I couldn't visit PHPBuilder very often.

I visited your site and saw the current table layout ...

language
  name_with_aim_link1    link_to_website1
  name_with_aim_link2    link_to_website2

language2
  name_with_aim_link3    link_to_website3
  name_with_aim_link4    link_to_website4

.....

Do you still want to display the info in another way (I have some time now) or is that layout ok ?

Thomas

thedream

Thanks for replying.

The trick is, I have done this layaout to update my website, but I would like to be able to do the folowing you made, or to have the control as we wrote before:

lang1       lang2       lang3
  name1_1     name2_1     name3_1
  name1_2     name2_2     name3_2
  name1_3

lang4       lang5       lang6
  name4_1     name5_1
              name5_2

Thanks again.
You will find my email on the website if you prefer.

MArc

tsinka

Ok,

here's an example:

  function getTable($data,$category) {

// Section title and table start
$retVal  = "    <p class=\"categtitle2\">$category</p>\n";
$retVal .= "    <table width=\"489\" border=\"0\" align=\"center\" cellpadding=\"0\""
          ."cellspacing=\"0\">\n";

foreach($data as $lang=>$arrData) {
  // print language
  $retVal .= "      <tr>\n"
            ."        <td align=\"left\" valign=\"top\" width=\"489\" colspan=\"4\""
            ." class=\"titre_tableau2\">$lang</td>\n"
            ."      </tr>\n";    

  $cnt=0;

  foreach($arrData as $data) {
    // start a new row every three rooms
    if ($cnt%3 == 0) {
      if ($cnt!=0) {
        $retVal .= "      </tr>\n";
      }
      $retVal .= "      <tr>\n        <td>&nbsp;</td>\n";
    }

    // urlencode the address and print link
    $address = urlencode($data['address']);
    $retVal .= "        <td>"
              ."<a href=\"aim:gochat?RoomName=$address\" class=\"categsubtitle\">."
              .$data['name']
              ."</a></td>\n";

    $cnt++;
  }

  // fill up last row with empty cells if neccessary
  while ($cnt%3 != 0) {
    $retVal .= "        <td>&nbsp;</td>\n";
    $cnt++;
  }

  // close the last row
  $retVal .= "      </tr>\n";
}

// return table HTML code
return $retVal;
  }

You can get the table by calling that function with e.g.:

<?PHP
$localeTable = getTable($arr,".Localized");
?>
// later on in the HTML code
...
<body>
  ....
<?=$localeTable?>
</body>
...

use the following code to build the array $arr:

$result = mysql_query('SELECT * from ichat ORDER BY name'); 
$arr = array();
while ($row = mysql_fetch_assoc($result)) 
{ 
    $arr[$row['lang']][] = $row; 
}

Do you store the other sections in database tables, too ? You can use that function to create the other sections too, but you might need to tweak the function and/or SQL queries a little bit.

Thomas

thedream

Thank you very much. I am gonna testing it, and I will let you know the result.

Thank you again,
Marc