Array Problem

[Anon]

First I like to thank everyone for helping me with my first step that I have problems with.. Now that I have it working I am on 4th and final step and not get the results I was looking for.

In my db.table I have two fields name and value.

But I am only getting the one name and value being displayed properly, and when there is more then one it doesn't display it correctly.

$form_fields = DBQuery ("SELECT form_name, form_value FROM SalesAgents WHERE agent_id = '$default_agent' ");

while (DBFetchFields ($form_fields)) {
$add_fields = $form_name."=".$form_value;
} DBFreeResult ($form_fields);

I am only getting the following as my display, ?form1=value1

What I was hoping for was ?form1=value1&form2=value2 and so on.

I have tried explode, implode, even tried other methods to make an array.

Help most appreciated...

[Anon]

I see you're setting $add_fields in the loop, and then immediately setting it again, destroying its previous value.

I'd suggest replacing $add_fields with $fields_array[] inside the loop, and then after the loop ends saying

$add_fields=join('&',$fields_array);

To join all the bits of the query string together with '&'.