PHP script question

Anon

Hi Guys,
I'm creating an admin section for my site. In this area there are two links. One goes to the "Add new band" page and the other goes to "Add new album". The reason there seperate is because quite often a band will have more than one album.
When i click to goto the "Add new band" page this brings up a php generated form. Upon filling out the form with the band info and submitting it, another php script is generated to insert the info into a database. This all works fine.
Now, when the user clicks on the "Add new album" link they are taken to a php generated page that displays the band names as links. The user then chooses a band in which they want to insert album information about. This will then bring up the form page for inserting album details.
This also works fine in that it inserts the data correctly into the albums table in the database but i can't get the band_id in the albums table to equal that of the band_id in the bands table. Can anyone help?

kareem

rrijnders

<b>"i can't get the band_id in the albums table to equal that of the band_id in the bands table."</b>

Why not?

Anon

Have you got any ideas why it's not?

mmilano

you explained that very well, .. but i think you need to show an example of some of the code that is not working.

just a thought..

Anon

I can insert a value into the band_id of the albums table as shown below:

$query = "insert into albums(band_id, name, track_list, info, year_released, album_pic_thumb, album_pic)
values('1','$name','$track_list','$info','$year_released','$album_pic_thumb','$album_pic')";

but how can i dynamically put the value in. eg. can the value "1" be exchanged for $band_id....the same band_id value from the bands table?

Anon

You'll first need to do a SELECT query to get the band_id, AND THEN insert the album with the band_id that you got from the first query.

So you'll be doing 2 queries from 2 different tables.

Diego

zalath

Or possibly, if you have the band_id on the first form, pass it to the second script as a GET variable:
<A href="secondscript.php?band=<?print $band_id?>"> etc.

-L-