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

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"));

• Next in forum: Re: why does this not work...pulling my hair out.....
• Prev in forum: Auto-increment numbers and letters possible?
• Thread view: why does this not work...pulling my hair out.....

[Reply to this message]