2 replies to this topic

[fedlerner]

Hi!

I'm a bit new on working with MySQL on PHP.. I have the following code:

$result = mysql_query(sprintf('INSERT INTO portfolio (uid,symbol,shares) VALUES(%d,"%s",%d)

    ON DUPLICATE KEY UPDATE shares=shares+%d',

        $_SESSION["uid"], $s->symbol, $_POST["amount"], $_POST["amount"]));

Which isn't working.. Can anyone help me with it ?

Regards,
Federico.-

[Orjan]

why do you do the sprintf? any particular reason? normal concatenation would work as good I assume? have you tried to echo the content and see what it gives instead of sending it to the sql server?

$sql = 'INSERT INTO portfolio (uid,symbol,shares) VALUES('.$_SESSION["uid"].',".$s->symbol.",'.$_POST["amount"].') ON DUPLICATE KEY UPDATE shares=shares+'.$_POST["amount"];
echo $sql;
$result = mysql_query($sql) or die("Error: ".mysql_error());

that will get you the error outputs you might need...

[fedlerner]

I'm a stupid :P The error happened because the table is "portfolios", not "portfolio".
Thanks for your help, as your code printed me the error :)

Regards,
Federico.-