[RESOLVED] someone pls help

[hazel999]

Hi

I have a question .... i want to display the sub data under a header title, hmm i dont really know how to explain that in words. the example should show it clearly:

Title:
sub title1
sub title2
sub title3
sub title4 ...

Title1:
sub title1
sub title2 ...

Title2: ...

and so on... All the title are under main item. How do i extract the datas all from 1 table?? and arrange them like above as shown.

[kakki]

suppose you have a table like that:
id, title, subtitle ....

$oldTitle='';
$q=mysql_query( "SELECT * FROM table ORDER BY title, subtitle" );
while( $line=mysql_fetch_array( $q ) )
{
     if ( $line[ 'title'] != $oldTitle )
     {
         echo '<h1>'.$line[ 'title' ].'</h1>';
     }
     echo $line[ 'subTitle' ] .'<br />';
     $oldTitle=$line[ 'title' ];
}

[hazel999]

Hi Kakki

Thanks for your reply. I managed to select and show the titles and subtitles but i how can i show it accordingly under each title? what i managed to do is to select the subtitles and titles where all these are under one of a main header. i hope u can understand. now i cant do is to arrange it under the correct title. how do i use foreach loop for it? any idea?? anyone?? some example code would be better 🙂

[leatherback]

Hazel: Did you use kaki's code? It does exactly that. It spits things out by title, and adds the title above each list.

[kakki]

you have to rely on the "ORDER BY" ending ... to do that
AND you'll need that table/view/select that looks like the one above
( title, subtitle ) .... if you join that, you can do a slightly different thing with that
( like "ORDER BY title_id, subtitle_id" ) ....

i still think code will work that way

[hazel999]

because by showing the title and subtitles, user have to select a choice before getting to the title and subtitles. and then i use 'join' to join up the two tables and use where clause to get title and subtitles according to the choice. i can show them but all the subtitles falls under the first title. i cannot get them to arrange accordingly. how do i still do the 'order' to the datas from the result of the joined tables?? and use the method of what kakki said.

[leatherback]

Hazel,

Could you please show how you retrieve your data at the moment. Otherwise it is dificult to assess where the trouble come from

[hazel999]

to get the datas from the table:

$result2 = @("select * from table1 where pro_id = '" . $FID . "'");

if suceed in retrieving records then:

$result3 = @("select * from table1, table2 where table1.ID = table2.v_id and table1.pro_id = '" . $FID . "'");

In displaying the datas:
while ($row2 = @mysql_fetch_array($result2))
{
$VersionID = $row2['ID'];
$Pversion = $row2['prod_version'];
echo("<p><strong>$Pversion</strong></p>");

while ($row3 = @mysql_fetch_array($result3))
{
$versionid = $row3['version_id']
$SWV = $row3['ID'];
$software = $row3['software_version'];
echo("<p>$software ". " <a href ='CL_changelog.php? software_version=$SWV'> " . " ChangeLog</a></p>");
}
}

[hazel999]

how do i still use the order by method after doing the joining of table?

[kakki]

pls change

$result3 = @mysql_query("select * from table1, table2 where table1.ID = table2.v_id and table1.pro_id = '" . $FID . "'");

into

$result3 = @mysql_query("select * from table1, table2 where table1.ID = table2.v_id and table1.pro_id = '" . $FID . "' ORDER BY table1.ID,table2.v_id");

for displaying:

 $oldID='';
$q=mysql_query( "select * from table1, table2 where table1.ID = table2.v_id and table1.pro_id = '" . $FID . "' ORDER BY table1.ID,table2.v_id");
while( $line=mysql_fetch_array( $q ) )
{
     if ( $line[ 'ID' ] != $oldID )
     {
         echo '<h1>'.$line[ 'prod_version' ].'</h1>'; // show header here
     }
     echo "<p>$line['software_version'] ". " <a href ='CL_changelog.php? software_version=$line['ID']'> " . " ChangeLog</a></p>".'<br />';// all infos for subtitle here
     $oldID=$line[ 'ID' ];
} 

[hazel999]

Hi kakki, thanks its working. but slightly different from what i want. because now the titles goes like that:

title1
subtitle
title1
subtitle
title2
subtitle

each title only able to contain 1 subtitle, which i want to combine all same title for subtitle together. ive tried the whole day but cant work.

[hazel999]

Hey kakki, I managed to solve the problem. its because of the $line[ 'ID' ], it should be $line['v_id'].

Thanks so much!!!

[kakki]

you're welcome