Insert file with ID "020822-2029" into MySQL, resulting entry subtracts first

[PictureChasers]

I am trying to "Insert" the value "020822-2029" into MySQL field, what instead ends up in the MySQL field is "18793". Somewhere this number apparently gets split into "20822" minus "2029".

Have tried using different field types in MySQL. I can manually enter the value "020822-2029" into MySQLAdmin, the value enters and stays as I wish.

I am using this query currently to insert the value

mysql_query("insert into Lightbox(cookieId, ID, qty) values('" . GetCartId() . "', $itemId, $qty)");

Any help would be appreciated, thanks

Darren Sweet
PictureChasers Photography

[e-mail]

www.PictureChasers.com
www.CelebrationofBeauty.com

[bodzan]

...I guess the problem appears because MySQL guesses that it is supposed to substract the values...

Try escaping value with mysql_real_escape_string()...

[PictureChasers]

[Try escaping value with mysql_real_escape_string()... [/B]

Have tried this but no success so far. The value that contains the "-" is the variable ID from the line below. I could not successfully use the real_escape_string to affect "ID".

Any more details I can try?

Darren Sweet
PictureChasers Photography

[e-mail]

www.PictureChasers.com
www.CelebrationofBeauty.com

[kburger]

Shot in the dark...

Have you tried something like this:

$cookieID = GetCartId();
mysql_query("insert into Lightbox(cookieId, ID, qty) values('$cookieID', '$itemId', '$qty')"); 

[bodzan]

Just echo $cookieID form kburgers suggestion...

Because the error might not be in the MySQL after all but in the function...