inserting array to database

thanks to Shiju for this code, inserting array from form into database. But it give an 'no such index in string error'. I tried $bands[]=HTTP_POST_VARS[band]; and all it does is insert the last value of the array

Garrick

$bands=$HTTP_POST_VARS[band];
$days=$HTTP_POST_VARS[day];


for($a=0;$a<count($bands);$a++){

$query="INSERT INTO tbl set day='$days[$a]',band='$bands[$a]'";

mysql_query($query,$connection);


}

HTTP_POST_VARS[band] and [day] are not arrays so $bands and $days will not be arrays. Count will work (returns 1 for non-arrays) but you can't refer to them with an index.