Posted by Ashok on 06/24/05 15:26

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

Hi,
in insert into, change '$_SESSION[MM_Username]' to %s
At the end add
GetSQLValueString($_SESSION['MM_Username'], "text"));

Ashok.

• Next in forum: Re: UTF-8 ?? ISO etc etc
• Prev in forum: Re: <img width > in apache
• Thread view: Re: why does this code not work...pulling my hair out...

[Reply to this message]