Store Account Id of Submitting User in Submission

[grahame]

Hi

I am getting so close I can taste it!

I have manually added a text field, account_id, to my form then changed my hook to a Code Hook in ft_create_blank_submission,end

Code:

$account_id = $account_info["account_id"];
$table_prefix = "ft_";
$query = "UPDATE {$table_prefix}form_{$form_id}
  SET account_id = 'Account_ID='{$account_id}
          WHERE submission_id = $new_submission_id";
@mysql_query($query);

Eh voila! My account_id field gets updated with the "Account_ID=" text ….but still not the $account_id…..

So anyone know how I grab the account_id of the currently logged in user please?

Thanks