Re: [PHP] Re: Problem Inserting Array of Rows from form

2001-07-15 Thread David
I will try without single quotes for the id and other fields which have numeric values. For the original issue I was missing two single quotes. I was missing a single quote in the $val line after $id[$i] and before songname : I really don't need the quote for id since it is a numeric value. Here

[PHP] Re: Problem Inserting Array of Rows from form

2001-07-15 Thread James Tan
dear david, did u know u do not need to put single quote to enclose number type value?? notice ur field select syntax: INSERT INTO songs VALUES (' 1 // --> 1 is not enclosed with end quote... thus makes only 5 fields, not 6 , blah', ' ***', ' 45', ' 2', ' ') id[0]=: 2 try INSERT INTO songs VA