Posted by Jerry Stuckle on 03/14/06 06:24

Stephen Preston wrote:
> Trying to load an multidimensional array into a MySQL table with columns as
> follows,
>
> level1,level2,level3,illust,item,description,partNo,qua,price,remarks,weight
> ,size,mass
>
> the array first line is $input[0][level1]Engine
> the array secondline is $input[0][level2]Cylinder Head
> etc..
>
> A 'foreach' inside a 'foreach' echo of the array gives the following, which
> is correct.
>
> 0, level1, Engine
> 0, level2, Cylinder Head
> 0, level3,
> 0, illust, 001.pdf
> 0, item, 1
> 0, description, Casting
> 0, partNo, 238356
> 0, qua, 1
> 0, price, 1,245.00
> 0, remarks, This is for the Z350 series
> 0, weight, 5
> 0, size, 5x5x5
> 0, mass, 37
> 1, level1, Engine
> 1, level2, Cylinder Head
> 1, level3,
> 1, illust, 001.pdf
> 1, item, 2
> 1, description, Valve, inlet
> 1, partNo, 452790
> 1, qua, 4
> 1, price, 5.46
> 1, remarks, This is for the Z350 series
> 1, weight, 5
> 1, size, 5x5x5
> 1, mass, 37
> 2, level1, Engine
> 2, level2, Cylinder Head
> 2, level3,
> 2, illust, 001.pdf
> 2, item, 3
> 2, description, Valve, exhaust
> 2, partNo, 345436
> 2, qua, 4
> 2, price, 5.99
> 2, remarks, This is for the Z350 series
> 2, weight, 5
> 2, size, 5x5x5
> 2, mass, 37
>
> etc..
>
> I have used the print_r to see all the data in the array also.
> I've tried the extract() function on the first key which I assume is also an
> array, inside and outside the loop to get at the column headings.
>
> I've tried allsorts of while and for loops but can't seem to work out how to
> get down to the last key to get the following statement to work. I'm trying
> the get the array to work through the first key [0] to fill the row, then
> the next key [1] to fill the next row in the table etc..
>
> $query2 = "INSERT INTO $tableName
> (level1,level2,level3,illust,item,description,partNo,qua,price,remarks,weigh
> t,size,mass) VALUES
> ('$level1','$level2','$level3','$illust','$item','$description','$partNo','$
> qua','$price','$remarks','$weight','$size','$mass')";
> $result = mysql_query($query2) or die("Couldn't insert data.");
>
> If I knock out the loops and have the above as a single statement, I can get
> the last row of records into the table.
>
> Hope someone can put a novice out of his misery.
>
> Thanks
> Stephen
>
>

Stephen,

How about showing us the failing code? It would be much easier to
troubleshoot what's going wrong.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]