really need some help

[Vizionz]

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...
<?
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


<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.

[Delphiprogrammi]

well,

this line


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

[Vizionz]

<?
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,

[sabret00the]

untested but the basic idea is

<?
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.

[Antivirus]

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?