[RESOLVED] arry problem

rbblue8

hey,

I have a form with a bunch of tables in it. The amount of tables is deteremend by sql query. basically it's for a while() statment that generates the tables and filles out there fields.

I need to take thoes fields and based upon there data do something.
the layout is as follows.

description (text box);
Delete (check box);
order (drop down menue);
id (hidden text field);

All field names are called information[] (the [] makes it an aray).

so i have the following code in my php script.

//code to update the picture description
if(!isset($error) and isset($_POST['update_descriptions']))
    {//start of if statment (change descritption)

if(is_array($_POST['information']))
	{//start of if statment
	$data=$_POST['information'];

	}//end of if statment

}//end of if statment (change descritption)

I have tried so many things to try and pull out the data into seperate values with no luck.

basically my end result here would be a mysql string per html table. So if the script generates two html tables... i will need two mysql querys.

I know this can be done with some while() statments or foreach() statments... i'm just stuck on how to code it / format the code.

can ya help?

rbblue8

ok so i changed it up a little and came up with this.

//code to update the picture description
if(!isset($error) and isset($_POST['update_descriptions']))
    {//start of if statment (change descritption)
    $id=$_POST['id'];
    $order=$_POST['order'];
    $desc=$_POST['desc'];

while(list($k, $i) = each($id))
    {

    while(list($k, $d) = each($desc))
        {

        while(list($k, $o) = each($order))
            {

            $string=("UPDATE pictures SET order='$o', description='$d' WHERE picture_id='$i'");
            echo $string.'<br />';
            }
        }
    }

}//end of if statment (change descritption)

which outputs the following
UPDATE pictures SET order='1', description='' WHERE picture_id='6'
UPDATE pictures SET order='3', description='' WHERE picture_id='6'

description should NOT be blank and picture_id not = 6 both times.

any ideas?

Bobulous

I could be wrong (it's been a while) but if I recall correctly, you'd only want to use an array notation for form elements that can return a variable number of values. Such as a multiple-select box.

For other form elements, you should give each field, textarea, select box a unique name.

rbblue8

hey..

sorry.. the above post (the 2nd post in this form) has done that. and each box it's own name and is made into an aray.

Bobulous

I'm sorry, I don't think I understood how your script is supposed to work.

HeyRay2

See my reply to your other post on this subject for a possible solution.

http://www.phpbuilder.com/board/showthread.php?t=10326305

Let me know if it solves your problem.

rbblue8

HeyRay2 wrote:
See my reply to your other post on this subject for a possible solution.

http://www.phpbuilder.com/board/showthread.php?t=10326305

Let me know if it solves your problem.

hey,

thanks for getting back to me.. i auctally re did the design of the page and the script. I made each html table it's own form and made a buttion in each block for each picture. Yeah it will suck that you can not update a load of them @ once.. but i have spent to much time on that part of the script.

thanks... and if i have free time before launch date.. I shall try again with the orig. design.

HeyRay2

No problem. I'm glad you found a solution.

I've written quite a few scripts that process multiple SQL rows in one form using similar code, so you definitely don't need to have a form for each result printed on your page.

However, the nice thing about PHP is that there are a bazillion "right" ways to do one thing, so don't be afraid to try something different if your current code isn't work the way you want it to.

Let me know if you end up using a similar solution to what I suggested. I like knowing if my code actually works... 😃