[RESOLVED] trouble retrieving integer field

[mborish_2000]

I've got a unique problem. I can't seem to figure out the best way to resolve an Issue I've got. What I'm trying to do is retrieve an integer field that looks like this: 12-21-234-432-0000 I can't figure out if I shoud strip the dashes before I load the data into the database, or try and deal with the problem in the mysql query.

Basically, what happens if I try to execute WHERE statement for the above number e.g. WHERE row_name = '12-21-234-432-0000'; it subtracts the values from each other and I get an error. Any ideas?

[mborish_2000]

How can I keep the dashes from substracting the data and just display the field the way it is?

[NogDog]

If the value is quoted in a query, it should be treated as a string and thus no subtraction should occur:

$num = '12-34-567-890';
// should work OK:
$r1 = mysql_query("SELECT * FROM t1 WHERE c1 = '$num'");

// won't work: numbers will be subtracted:
$r1 = mysql_query("SELECT * FROM t1 WHERE c1 = $num");

[mborish_2000]

Thanks, that worked. I think that I need to brush up on my quotes.