6 replies to this topic

[oxida]

This is the situation:

I have a database where you can add bands ( theire albums, genre other info)

For the album part they can add for each album the songs.


So what do i want:

When i show the results there only shoul display the bandname which should be a link to the more detailed info like albums biography etc.

How do I do that.

Is there a name for this and are there any tutorials.

thx in advance

[jlhaslip]

What do you have for a Database design so far?
Without any coding or SQL information, it will be difficult to guess the changes you need to make.

I would use three tables. Band, Album, Songs.

Each band can have several Albums, and each Album can have a flexible number of Songs.
The Bio information can be placed into the Band Table.

[asglu]

oxida, on Jul 22 2008, 01:46 PM, said:

This is the situation:

I have a database where you can add bands ( theire albums, genre other info)

For the album part they can add for each album the songs.
So what do i want:

When i show the results there only shoul display the bandname which should be a link to the more detailed info like albums biography etc.

How do I do that.

Is there a name for this and are there any tutorials.

thx in advance

easy thing here is an example

<?php
$db_host = "";///// put your host name
$db_user = "";///// put your database username
$db_pass = "";////// put your database passowrd if it is passworded
$db_name = "";///// put your database name
$dbc = mysql_connect($db_host, $db_user, $db_pass);///mysql connetion
$dbs = mysql_select_db($db_name);/seleting mysql db
$result = mysql_query("SELECT album,genre FROM mysql_table_name ORDER BY time ")or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo "$row[0]  $row[1] ";
 echo "------------<br />";
}
?>

Like this use multiple arrayed argument and use echo "<a href>..........,</a>"; to link it

[oxida]

@jlhaslip

i have the following tables:

bands with the following rows

bandid, int(10), NOT NULL, AUTO_INCREMENT, PRIMARY KEY
bandname, VARCHAR(30), NOT NULL

bandsinfo with the following rows:

infoid, int(10), NOT NULL, AUTO_INCREMENT, PRIMARY KEY
bandinfo, VARCHAR(30), NOT NULL
genre, VARCHAR(30), NOT NULL
bio, VARCHAR(30), NOT NULL

Genre which is a dropdown box this isnt relevant.

@Asglu

Thx I will try this.

[jlhaslip]

I would make that as one Table only and avoid breaking it into two tables.
Add an album Table

alb_id
alb_name
alb_release date
alb_description

And a track or song Table to add the tracks for each album. Keeping the tracks separate from the album allows for flexability in the number of tracks on the album.

track Table

track_id
track_alb_id (link back to album)
track_title
track_description

Something along those lines should work nicely for you.

[oxida]

Thank you jlhaslip

this has brought me to use master/detail pages which will do the trick.

If i have the page finished i will try to make a tutorial.
Because I think it would help a lot of people.


*Problem solved*

[jlhaslip]

Topic is resolved.

Please PM any moderator to continue this discussion. Until then, this topic is closed.