[RESOLVED] Need to pass 2 numbers separated by hyphen, but is always subtracts

[ChetUbetcha]

I want to pass 2012-007. One variable gives me 2012 and the other gives me 007. I want to pass the two with a hyphen, but it performs the math first and I end up with 2005. How do I pass the two variables and insert them into the database as 2012-007?

[bradgrafelman]

What does "pass" mean? Pass from where to where, and in what way?

Can you show us any actual code?

[ChetUbetcha]

Quick and dirty:

$value1 = '2012';
$value2 = '007';

I want to pass/submit/insert $passed_value to the database:

$passed_value = $value1.'-'.$value2;

But it runs the math. i just want the two numbers separated by a hyphen.

[Ashley_Sheridan]

The code you posted won't run any maths on the variables, you're using string concatenation, not mathematical operators. So what other code are you using where you are seeing the maths performed?

[bradgrafelman]

Agree with what Ashley said above. Since you mentioned a database, I'm betting you aren't handling the string correctly. Note that this:

2012-007

is either a string or a mathematical equation. Since you don't want the latter, it has to be the former.

As such, are you treating this string correctly in the SQL query? (Hint: all strings must be surrounded with single quotes.)

[Ashley_Sheridan]

I've just re-read through your post, and it seems that it could be that you're not escaping the values when you run the query. As it's a string and not a number, you need to properly quote it inside your SQL query.

beaten to it by bradgrafelman

[ChetUbetcha]

Thank you! I've removed my head from its hiding place. Single quotes fixed it.