help with layout of multiple results in table... *SOLVED*

[brown2005]

hi....

i want to take some results from the database say

apples
attack
bob
brick
boys

etc, etc and display them like


A

apples, attack

B

bob, boys, brick

and so on based on the first letter and then in order...

any ideas please?

[shocker-z]

[code]$query = mysql_query("SELECT LEFT(field, 1)  as 'first', field FROM table ORDER by first ASC");
$letter='';
while ($row=mysql_fetch_array($query)) {
if ($row['first'] !== $letter) {
  $letter=$row['first'];
  echo "<B>$first</b><br>";
}
if ($row['first'] == $letter) {
  echo "$row[field]<br>";
}
}[/code]


i beleave that should* work but hasn't been tested

[HuggieBear]

[quote]
[code]$query = mysql_query("SLEECT LEFT(field, 1)  as 'first', field FROM table ORDER by first ASC");[/code]
[/quote]

Typo in SELECT...

Regards
Huggie

[shocker-z]

cheers huggie changed it :)

[brown2005]

$query = mysql_query("SELECT LEFT(topic_a, 1)  as 'first', topic_a FROM A ORDER by first ASC");

$letter='';

while ($row=mysql_fetch_array($query))
{

if ($row['first'] !== $letter)
{
 
  $letter=$row['first'];
 
echo "<B>$first</b><br>";

}

if ($row['first'] == $letter)
{
 
  echo "$row[topic_a]<br>";
 
}

}

i have used the above and get http://www.fantasy-comps.com/a.php

but hasnt actually done what I wanted... i wanted the letter above it and then in the same row, and if fills up the row the next row....

i.e.

[b]A[/b]

a, ab, ac, ad, ae, af
ag, ah, ai, aj

[b]B[/b]

b
b, ba, bb, bc

[brown2005]

Hi, I was wondering if anyone knew if this is posisble at all?

[brown2005]

Hi, I was wondering if there was anyone at all out there that can possibly help with this?

[Barand]

Do you mean
[code]
<?php

$query = mysql_query("SELECT LEFT(topic_a, 1)  as 'first', topic_a FROM A ORDER by topic_a");

$letter='';

while (list($first,$topic)=mysql_fetch_row($query))
{

  if ($first !== $letter)
  {

    $letter = $first;
    $count = 0;
    echo "<h3>" . strtoupper($first)  . "</h3>";
   
  }

  if (!$count) echo "$letter,";
  echo " $topic";
  $count++;
  if ($count%5 == 4) echo '<br>';
}

?>[/code]

[brown2005]

Hi, That is looking more like I want, but it needs a few adjustments, view [url=http://www.links-bid.com/1.php to]http://www.links-bid.com/1.php to[/url] and you will see.

I want the letter moved from the start, not the bold one the one say like a, and then it should have a , after every topic.....

Thanks for all your help

[Barand]

[code]
<?php

$query = mysql_query("SELECT LEFT(topic_a, 1)  as 'first', topic_a FROM A ORDER by topic_a");

$letter='';

while (list($first,$topic)=mysql_fetch_row($query))
{

  if ($first !== $letter)
  {

    $letter = $first;
    $count = 0;
    echo "<h3>" . strtoupper($first)  . "</h3>";
   
  }

  echo ($count) ? "," : "";
  if ($count && $count%5 == 0) echo '<br>';
  echo ($count) ? " $topic" : "$topic";
  $count++;
}

?>[/code]

EDIT: In your reply #4 you said you wanted letter on row
[quote]i wanted the letter above it and then in the same row, [/quote]

[brown2005]

awesome... thanks very much....

[brown2005]

    echo"<table width='500' border='1' cellpadding='0' cellspacing='0'>";
    echo" <tr>
          <td>";
     
  echo ($count) ? "," : "";
  if ($count && $count%10 == 0) echo '<br>';
    echo ($count) ? " $topics_topic" : "$topics_topic";

    $count++;

echo"</td>
      </tr>";
echo"</table>";

Hi i have tried putting the results in a table so they can be easily aligned and stuff, but it comes out all wrong....

check www.allinthissite.co.uk for what happens...

is this the best way to do it in a table or would i use a div or something else?

[HuggieBear]

Can you provide all of the code for this section, including the while loop...

Also use code tags as it's easier to understand... [b][[/b][b]code][/b]My code goes here[b][[/b][b]/code][/b]

Regards
Huggie

[brown2005]

its ok i have worked it out..... i just put a table around the while loop.. thanks anyway

[Barand]

or use css

[code]<STYLE content="text/css">
DIV.item {
    width: 100px;
    height: 20px;
    float: left;
    padding: 3px;
    text-align: left;
    font-size: 0.8em;
    font-weight: 300;
    border:  1px solid #EEE;
}
DIV.head {
    width: 500px;
    height: 40px;
    padding: 13px 3px ;
    text-align: left;
    font-size: 0.9em;
    font-weight: 600;
    margin-top: 15px;
}
BR {
    clear: both;
}
</STYLE>
<?php
include 'db2.php';
define ("COLS", 5);

$query = mysql_query("SELECT LEFT(topic_a, 1)  as 'first', topic_a FROM A ORDER by topic_a");

$letter='';

while (list($first,$topic)=mysql_fetch_row($query))
{

  if ($first !== $letter)
  {

        $letter = $first;
        $count = 0;
        echo "<br/><DIV class='head'>" . strtoupper($first)  . "</DIV>";
   
  }

  if ($count && $count % COLS == 0) echo '<br>';
  echo  "<DIV class='item'>$topic</DIV>";
  $count++;
}

?>[/code]