vb.org Archive - really need some help

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - really need some help (https://vborg.vbsupport.ru/showthread.php?t=149350)

really need some help

i been trying to learn to code and took on a project but nevermind all that i am stumped so i will show you the code. i need to be able to grab song listings from a database table and show them in a neat table.

if i go here info.php?artist=Artistname
with the below code it will show all the albums in the database and info to go with it but what ever i have tried i cant get it to show a table with all the songs in the database to go with the album...

Code:

<?

connectdbase();



$artist=str_replace("|","&",$artist);

$artist=str_replace("***","\'",$artist);

$sql="SELECT ID,title,artist,albumyear,genre,album, picture from songlist WHERE artist='$artist' GROUP BY album ORDER BY album";

$result=mysql_query($sql);

while($data=mysql_fetch_object($result))

                

if($data->album!=''){

echo "<table class=alt2 border=0 width=100%><tr><td>";

echo "<table border=0 width=100% height=96><tr><td class=thead height=21><p align=left><font color=#c0c0c0>".$data->album." | Fan Rating: 9.4  | Rate this album</font></a></p></td></tr>";                                

echo "<tr><td><table border=0 width=100%><tr><td><center><img src=pictures/".$data->picture."' border='1'width='130'height='130'></center></td><td width=30%><b>Artist</b>: ".$data->artist."</a><br><b>Album</b>: ".$data->album."<br><b>Release Date</b>: ".$data->albumyear."<br><b>Genre</b>: ".$data->genre."</td>";

echo "<td width=50%><p align=left>";

 <------ right here i want to display table---->

with the song listings for this current album

echo "</td>";

echo "</tr>";

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

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

$artist=mysql_escape_string($data->artist);

$album=mysql_escape_string($data->album);



$sql2="SELECT title from songlist WHERE artist='$artist' AND album='$album'";

$result2=mysql_query($sql2);

$tracks=0;

while($data2=mysql_fetch_object($result2))

        {

        $tracks++;

        }



        if($tracks>0){

                echo "$tracks</td></tr>";

                } else {

                echo "none";

        }

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

$count++;

}

?>

in the above code is what i have so far. and you can see a arrow and where i would like to throw in a table that grabs the songs for the album associated..
if i type ".$data->title." it will show the first track but no others. thats where i get stuck

the code below is standalone which will grab the songs for that artists if i call the page

info.php?artist=Artistname&album=albumname

Code:

<table>

                <tr align=center bgcolor="<? echo $tbl_hdr; ?>">

                <td>

                <font size=1 color="<? echo $text; ?>" face=tahoma>

                Num

                </td>

                <td>

                <font face=tahoma size=1 color="<? echo $text; ?>">

                TRACK NAME

                </td>



                <tr>

                <td>

                <font face=tahoma size=1 color="<? echo $highlight; ?>">

                        <?

                        $count=0;

                        $artist=$data->artist;

                        connectdbase();

                        $query2 = "select ID,title,trackno from songlist WHERE album='$album' and artist='$artist' ORDER BY trackno";

                        $result2 = mysql_query($query2);

                        while($data2=mysql_fetch_object($result2))

                        {

                        $count++;

                        if(($count % 2)==0){

                                $bgcolor=$dark;

                        } else {

                                $bgcolor=$light;

                        }

                        echo "<tr bgcolor=$bgcolor><td><font size=2 face=tahoma color='$highlight'>";

                        if($data2->trackno!='0'){

                        echo $data2->trackno;

                        } else {

                        echo $count;

                        }

                        echo "</td/><td><font face=tahoma size=2 color='$text'>";

                        echo $data2->title;

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

                        }

                        ?>

                </td>

                </tr>

        </table>

by itself and it will show the songs in a nice little table. but figure one allows me to grab all the artists albums in one spot. and now i just need to throw the songs for the albums in there.

well,

this line

PHP Code:


		
			
connectdbase();

that looks like a function call but the function is never defined you are requird to either include the file where you defined that function or you must define the function within the same file but before you make the call.Before you can retrieve data from a MySQL database(or any databaseserver for that matter) you must be connected to it

Code:

<?

session_start();



require "common.php";



?>

i'm getting the connection above code. and data shows. i just not getting the song listing like below.

1.track 1
2.track2
3.track3

all that i have been able to do is generate

TrackName

i need to grab the song listings and throw it in the top code. so every album thats in the database will generate the whole thing.

right now the top code. displays.

artist
genre
album
picture
total songs count
realease date

now that will show the stats for each album. i just havent been able to find away to throw all th songs for the album in there,

untested but the basic idea is

PHP Code:


		
			
<?
connectdbase();

$artist=str_replace("|","&",$artist);
$artist=str_replace("***","\'",$artist);
$sql="SELECT ID,title,artist,albumyear,genre,album, picture from songlist WHERE artist='$artist' GROUP BY album ORDER BY album";
$result=mysql_query($sql);
while($data=mysql_fetch_object($result))
        
if($data->album!=''){
echo "<table class=alt2 border=0 width=100%><tr><td>";
echo "<table border=0 width=100% height=96><tr><td class=thead height=21><p align=left><font color=#c0c0c0>".$data->album." | Fan Rating: 9.4  | Rate this album</font></a></p></td></tr>";                
echo "<tr><td><table border=0 width=100%><tr><td><center><img src=pictures/".$data->picture."' border='1'width='130'height='130'></center></td><td width=30%><b>Artist</b>: ".$data->artist."</a><br><b>Album</b>: ".$data->album."<br><b>Release Date</b>: ".$data->albumyear."<br><b>Genre</b>: ".$data->genre."</td>";
echo "<td width=50%><p align=left>";
 <------ right here i want to display table---->
with the song listings for this current album
echo "</td>";
echo "</tr>";
echo "</td></tr></table>";                                            
echo "</td></tr></table>";
$artist=mysql_escape_string($data->artist);
$album=mysql_escape_string($data->album);

$sql2="SELECT title from songlist WHERE artist='$artist' AND album='$album'";
$result2=mysql_query($sql2);
$tracks=0;
while($data2=mysql_fetch_object($result2))
    {
    $tracks++;
/*<table>
        <tr align=center bgcolor="<? echo $tbl_hdr; ?>">
        <td>
        <font size=1 color="<? echo $text; ?>" face=tahoma>
        Num
        </td>
        <td>
        <font face=tahoma size=1 color="<? echo $text; ?>">
        TRACK NAME
        </td>

        <tr>
        <td>
        <font face=tahoma size=1 color="<? echo $highlight; ?>">
            <?
            $count=0;
            $artist=$data->artist;
            connectdbase();
            $query2 = "select ID,title,trackno from songlist WHERE album='$album' and artist='$artist' ORDER BY trackno";
            $result2 = mysql_query($query2);
            while($data2=mysql_fetch_object($result2))
            {
            $count++;
            if(($count % 2)==0){
                $bgcolor=$dark;
            } else {
                $bgcolor=$light;
            }
            echo "<tr bgcolor=$bgcolor><td><font size=2 face=tahoma color='$highlight'>";
            if($data2->trackno!='0'){
            echo $data2->trackno;
            } else {
            echo $count;
            }
            echo "</td/><td><font face=tahoma size=2 color='$text'>";
            echo $data2->title;
            echo "</td></tr>";
            }
            ?>
        </td>
        </tr>
    </table>*/
    }

    if($tracks>0){
        echo "$tracks</td></tr>";
        } else {
        echo "none";
    }
echo "</td></tr>";
$count++;
}
?>

i commented it out to prevent the inevitable parse error.

that looks like wimpyplayer code. I did an integration with vbulletin on that sometime last year, but i didn't do it as a product, I hard-coded it into the system. Is it?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00980 seconds Memory Usage 1,759KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: