problem with arrays & mysql

[Anon]

Hi,

I'm using PHP and have a 2-d array called vol[][]. i just index into
the array numerically and this code cycles through and prints the
contents out ok:

for($i=0;$i<24;$i=$+1){
echo "<p>";
for($j=0;$j<10;$j=$j+1){
echo vol[$i][$j];
echo " ";
}
}

this prints the contects out fine (just strings) but when i do:

$query = "INSERT into tabname (a1,a2) VALUES ('$vol[1][1]','$vol[2][1]')";

it executes fine but when i look at the table in phpMyAdmin or from
command prompt the entries are shown as "Array" and not the individual
values that should be there.

any suggestions welcomed.

thanks.

[[deleted]]

That is because you cannot put a multidimentional array inside quotes.

Putting variables inside quotes is never a good idea. it is convenient, but causes way too many problems.

try this instead:

$query = "INSERT into tabname (a1,a2) VALUES ('".$vol[1][1]."','".$vol[2][1]."')";

[Anon]

that solved it, fantastic 🙂

thankyou vincent.