Posted by toedipper on 10/10/19 11:19

Paul Charlton-Thomson wrote:
> $_SESSION['MM_Username'];
>
>
> "toedipper" <send_rubbish_here734@hotmail.com> wrote in message
> news:t6Hue.2352$BD2.1596@newsfe1-gui.ntli.net...
>
>>Hi,
>>
>>The code below is part of an insert.
>>
>>It inserts ok but the value for the last field userid is always written
>>back as blank. The userid should be filled from the session id
>>$_SESSION[MM_Username]
>>
>>Any ideas? On the same page that this is on I can echo
>>$_SESSION[MM_Username] and that works ok.
>>
>>Thanks,
>>
>>td.
>>
>>
>>
>>$insertSQL = sprintf("INSERT INTO software (title, shortdesc, `desc`,
>>version, minreqs, wareid, catid, hpage, dllink, dlsize, triallength,
>>price, keywords, liveyn, submitdate, submittime, userid) VALUES (%s, %s,
>>%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, 'N', current_date(),
>>current_time(), '$_SESSION[MM_Username]')",
>> GetSQLValueString($_POST['title'], "text"),
>> GetSQLValueString($_POST['shortdesc'], "text"),
>> GetSQLValueString($_POST['desc'], "text"),
>> GetSQLValueString($_POST['version'], "text"),
>> GetSQLValueString($_POST['minreqs'], "text"),
>> GetSQLValueString($_POST['wareid'], "int"),
>> GetSQLValueString($_POST['catid'], "int"),
>> GetSQLValueString($_POST['hpage'], "text"),
>> GetSQLValueString($_POST['dllink'], "text"),
>> GetSQLValueString($_POST['dlsize'], "text"),
>> GetSQLValueString($_POST['triallength'], "text"),
>> GetSQLValueString($_POST['price'], "double"),
>> GetSQLValueString($_POST['keywords'], "text"));
>
>
>
Thanks Paul rried that but then I get a Parse error for the line that
the insert command is on. Not much hair left....!

[Back to original message]