Inserting multiple values into MySQL

[Anon]

I am trying to insert multiple text fields into a MySQL database for my music collecition

for ($i=1; $i <= $album_number_of_songs; $i++)

{

print "echo $i; <input type = 'text' name = 'song_$i_name' size = '20'>";
print "<P>";
}

//this will create the text boxes based on the album_number_of songs

To insert the data is where I need some help:

for ($i=1; $i <= $album_number_of_songs; $i++)
{

$namevar = "song";
$namevar = $namevar . $i;
$namevar = $namevar . 'name';

$insert_songs = mysql_query("INSERT INTO TEST (song_name) VALUES ('$namevar')") or die ("not inserted, songs");

//this is inserting song_1_name, song_2_name, etc. into the database.

another user suggested trying this:

use an array,

for ($i=0;$i<$num_of_songs_you_want_to_enter;$i++)
{
Song name:<input type=text name=song_name[]><p>
song length:<input type=text name=song_length[]><p>

etc

}

Then in your target script:
$values="";
$i=0;
while (song_name[$i]!="") // don't have to worry if not all form elements used
{
if ($i!=0) $values.=",";
$values.="('$song_name[$i]','$song_len[$i]',$album_id[$i],$artist_id[$i],$song_number')";
}

$query="insert into songs (song_name, song_length) VALUES $values";
$result=mysql_query($query);

This has not worked either, I am getting an error on :
while (song_name[$i]!="")

sam

[Anon]

In the result script, you have some variables of the form "song".$i."name" where $i < $album_number_of_songs. It is possible that some of them are not defined. You just have to insert the values that are defined in the database :

for ( $i = 0 ; $i < $album_number_of_songs ; $i++ ) {
$var = "song".$i."name" ;
if ( ${$var} ) {
$query = "insert into test (songname) values ('".${$var}."')" ;
mysql_query($query) ;
}
}

It's like your first solution, but the value that interests you is not "song".$i."name" but ${"song".$i."name"}, if it exists.

[Anon]

I have found out what works:

The form is like this:

for ($i=1; $i <= $album_number_of_songs; $i++)

{

print "Song #";
echo $i;
print " <input type = 'text' name = 'song_name[]' size = '20'>";
print "<P>";

//each song is a part of the array song_name

}

?>

Then, to insert the values into the table use:

for ( $i = 0 ; $i < $album_number_of_songs ; $i++ ) {

$song_names = $song_name[$i];

$insert_songs_result = mysql_query("INSERT INTO TEST (song_name) VALUES ('$song_names')") or die ("not inserted, songs");

next($song_name);
    }