Trouble with some SQL core code

Does the submit button have to be ahah too or just the 'add more' button? It'd be better to use a non-ahah submit button and use a submit form handler instead. That way you could also avail of the form validation handlers too if you wanted.

Ignoring that, you are getting empty values in your table because you are inserting a variable ($node->Iname) which doesn't exist. Not sure where you got $node from but it's not a node form by the looks of it (difficult to tell without seeing full code, but that's the incorrect definition of it if it is) and it's not a variable passed into or set in that function either.

You're already checking the correct place for the value of the submit button ($form_state['values']['op']) so you know how to access the form values already - $form_state['values'] array.

Hope that helps.

Hi, sorry to be clogging the forums with my questions. Below are two snippets of code, the first one works, however the second one is the one I am interested in. The second allows a user to create multiple boxes to insert an input into but I'm having trouble referencing the multiple inputs.

EXAMPLE ONE

$form['Rname'] = array(
    '#type' => 'textfield',
    '#title' => t('Recipe Name'),
    '#size' => 36,
    '#default_value' => $form_state['values']['Rname'],
);

after submit is clicked

$dish = $form_state['values']['Rname'];
db_query("INSERT INTO {recipe} (Rname) VALUES ('%s')", $dish);

EXAMPLE TWO

    for ($i = 1; $i <= $quantity; $i++) {

// The element name needs to be different for each textfield, otherwise we will only get one value after the form is submitted.
$form['Iname']['Iname'. $i] = array(
'#type' => 'textfield',
'#title' => t('Ingredient'),
'#size' => 36,
'#default_value' => $form_state['values']['Iname']['Iname'. $i],
);

after submit is clicked

    $Ingred = $form_state['values']['Iname']['Iname.$i'];              //This seems to be the problem
    db_query("INSERT INTO {ingredient} (Iname) VALUES ('%s')", $ingred);

When I make $Ingred = $form_state['values']['Iname'], the insert works but only gives me the first item in the array. The addition of the 3rd array that expands with the addition of boxes should act as a marker to each new textfield but its not, it returns blanks rows (I've tried a for loop around the insert as well).

I am also wondering is there a way to manually assign and NID, VID and UID without creating a node?

again sorry for being a pain.

Apologies again, the multiple textfield problem was solved. I would still like to know if it is possible to set NID and the like manually.