Re: Problem inserting array of rows

2001-07-15 Thread David
Hi, I was missing two single quotes in the $val line after $id[$i] and before songname : Here is the corrected code $vals .=", ('$id[$i]', '$songname[$i]', '$rating[$i]', '$video[$i]', '$album_id[$i]', '$movie[$i]')"; Now the problem is it only inserts one row into the table, when there s

Re: Problem inserting array of rows

2001-07-15 Thread Dvořáček Michal
Hi, if you have 6 colums, you are inserting only 5 in table INSERT INTO songs VALUES (' 1, blah', ' ***', ' 45', ' 2', ' ') [1th ] [2nd] [3rd] [4th] [5th] i think that first apostrophe is shifted to left side should be: INSERT INTO songs VALUES (1, 'blah', ' **