For-loop and mysql

[Dorland]

Well, I'm almost completely new to php, but have a project, where I'm adding articles to a sql database. The articles come from a html form, and are added to the db with php. Wasn't sure which forum I should go to.

In my code, if get a list of subjects separated by ";", I then make that string into an array with explode, and try to add a row to the database for every subject. But i get "Unable to insert subjects to database" every time i run it.

//Explode the subjects string into seperate subjects
$subjects  = $_POST["article_subjects  "];
$subjects_arr = explode(';', $subjects, 10);
 
for ($i = 0; $i <= 10; $i++) {
    if ($subjects_arr[$i] != null){
        $add_subject_sql = "INSERT INTO artikel_subject (artikel_id, artikel_subject) VALUES ('".$article_id."','".$subjects_arr[$i]."')";
$add_subject_res = mysql_query($add_subject_sql) or die("Unable to insert subjects to database");
    }
}
 

It works if I drop the loop and don't use $subjects_arr[$i], but use something like

$add_subject_sql = "INSERT INTO artikel_subject (artikel_id, artikel_subject) VALUES ('".$article_id."','".$_POST["article_subject"]."')"; 

But I wanted to add several keywords, and put them into different rows. Did i make an error, or is there a better way to do this?

[pbmods]

Heya, Dorland. Welcome to TSDN!

Try this instead:

$add_subject_res = mysql_query($add_subject_sql) or die("Unable to insert subjects to database:  " . mysql_error());
 

[Dorland]

Thanks :). Have not used the error function before. It turned out that it was an error in the db afterall. It was the wrong key which was primary.