PHP MYSQL select query strip spaces from column -

-

i have query 

mysql_query("select * codes code='222 '");

i want strip spaces in column in query should 

mysql_query("select * codes code=strippedstring('222 ')"

what best way this

try

$value=trim('222 '); mysql_query("select * codes code=$value"

note:- stop using mysql_* deprecated

learn trim()


Comments

Post a Comment

Popular posts from this blog

node.js - StackOverflow API not returning JSON -

-
i using node.js script gather data stackoverflow. know responses gzipped, put code in should take care of that. script follows: var request = require('request'); var zlib = require('zlib'); function getstackoverflowresponse(url, callback){ request(url, {encoding: null}, function(err, response, body){ if(response.headers['content-encoding'] == 'gzip'){ zlib.gunzip(body, function(err, dezipped) { callback(dezipped); }); } else { callback(body); } }); } var url = "https://api.stackexchange.com/docs/questions#pagesize=2&order=desc&min=2014-01-04&max=2014-02-02&sort=activity&tagged=apigee&filter=default&site=stackoverflow&run=true"; getstackoverflowresponse(url, function(questions) { console.log(questions); }); instead of getting json output, i'm getting following response: buffer 0d 0a 0d 0a 0d 0a 0d 0a 3c 21 44 4f 43 54 59 50 45 20 48...
Read more

php - Laravel 4.1 to Heroku: SQLSTATE[HY000] [2002] No such file or directory -

-
i deployed laravel 4.1 app in heroku following article http://phpartisan.tumblr.com/post/71580870739/running-laravel-4-on-heroku the static html homepage loaded okay when trying log-in, getting error sqlstate[hy000] [2002] no such file or directory my local setup laravel 4.1 & mysql. i don't think there database created when deployed. do need manually? how , settings then? thanks! the problem environment might still point local. in cli, type heroku run php artisan env find out. else, might wanto run php artisan migrate --env=production set correct production environment. you might encounter issue this: php fatal error: call undefined function symfony\component\console\mb_convert_variables() in /var/www/mysite/vendor/symfony/console/symfony/component/console/application.php on line 1154 trust me, tt has nothing mb_string module post stated. laravel: call undefined function symfony\component\console\mb_convert_variables()? the problem @ e...
Read more

visual studio - How to generate shader debug information (pdb) in VS2012 -

-
i'm trying debug shaders in directx 11 sdk application using graphics diagnostics tool in vs2012, when click start debugging on 1 of shaders in graphics pixel history panel i'm getting pixel shader.pdb not loaded , i'm not able find pdb file anywhere. i tried compiling shaders @ runtime using d3dx11compilefromfile d3dcompile_debug flag using hlsl compiler debugging information turned on (/od /zi) none of these options producing pdb file use in graphics diagnostics tool. how generate these files? i think "pixel shader.pdb not loaded" message misleading. no .pdb files generated hlsl-compiler. debug info integrated binary (either memory blob or .cso file). shader file named "pixel shader" ? maybe says not shader, kind of visual studio's internal source files (shader debugger in vs2012 unstable sometimes) some ideas that, probably, can solve issue: make sure debug , release output binaries not messed up. check both debug , r...
Read more