|
|
Posted by Paul Charlton-Thomson on 09/28/36 11:19
$_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"));
Navigation:
[Reply to this message]
|