php value='00-0123'

[vehto]

Help newbie
I have a PHP script with a dash in a value field



Problem: mysql is interpeting the dash (-) as a minus sign
can anyone help with this ??

 

[sleipnir214]

If you're handing that to MySQL, it is a string. All strings should be inside single quotes inside a query. Only numeric values should be passed in "bare".

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

So to be more explicit:

$foo = '00-123';

$query = "SELECT * from bar WHERE col = '" . $foo . "'";

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[vehto]

Yes I ampassing the value to mysql

mysql_query ("insert into testdb (user_id, act_id) values ($user '$act')&quot

WOW its working !!


Thanks sleipnir