php - ON DUPLICATE KEY UPDATE keeping some sold values -

-

ive googled 1½ hour , cant come understanding how this.

i want update current row, keep values assigned. have checkbox either gives "1" or "0". if checkbox returns "0" dont want update there's no point updating. dont know how this.

if col1 duplicate entry, should update col2,3,4,5 if entry isnt filled "1" or if variable gotten form "0".

i lot of if statements id prefer not to. , aware code extremely messy right because im trying find solution. code fixed when result want to. code written in mysql because im more familiar in , ported pdo when done. please dont tell me "dont use mysql" , dont give me answer. gotten enough

 $insert_movie = "insert filmer (namn, rel_720p, rel_1080p, rel_dvdr, swesub, addate)  values ('$namn','$rel_720p','$rel_1080p','$rel_dvdr','$swesub',current_timestamp)  on duplicate key update  rel_720p = if('$rel_720p' not null, '$rel_720p', rel_720p), rel_1080p = if('$rel_1080p' not null, '$rel_1080p', rel_1080p), rel_dvdr = values(rel_dvdr), swesub = values(swesub)";  $result = mysql_query($insert_movie, $connection) or die (mysql_error());  mysql_close($connection);

pictures of whats happening: first entry: http://puu.sh/9in0p/91f0839b8f.png second entry: http://puu.sh/9in2q/8cafdb5422.png

look @ last row in there. first picture second should 1,1,1,1 , not 0,1,1,0.

probably not best solution, managed anyhow:

on duplicate key update rel_720p = if('$rel_720p'=1, 1, rel_720p), rel_1080p = if('$rel_1080p'=1, 1, rel_1080p), rel_dvdr = if('$rel_dvdr'=1, 1, rel_dvdr), swesub = if('$swesub'=1, 1, swesub)";

Comments

Post a Comment

Popular posts from this blog

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more

php - facebook and github login HWIOAuthBundle and FOSUserBundle in Symfony2.1 -

-
i have followed tutotial http://m2mdas.github.io/blog/2013/11/21/integrate-hwioauthbundle-with-fosuserbundle/ make github login work, seems working when clicked login land on github login page, , see 1 user registered on github application in github dashboard. not authencated in symfony. on symfony tool bar on bottom still says anonymous user, plus new row not added table fos_user. for facebook login, when click on generator login link facebook, gives me error "given url not permitted application configuration.: 1 or more of given urls not allowed app's settings. must match website url or canvas url, or domain must subdomain of 1 of app's domains." another doubt had in tutorial, in routing.yml says put, hwi_github_login: pattern: /secure_area/login/check-github as there no controller or resource specified, supposed put here controller action path or resource? config.yml fos_user: db_driver: orm # other valid values ...
Read more

hadoop - Sqoop installation export and import from postgresql -

-
i v'e installed sqoop , testing . tried export data hdfs postgresql using sqoop. when run it throws following exception : java.io.ioexception: can't export data, please check task tracker logs . think there may have been problem in installation. the file content : ustnu 45 mb1ba 0 gnbco 76 izp10 39 b2aoo 45 si7eg 93 5sc4k 60 2ihfv 2 u2a48 16 yvy6r 51 lnhsv 26 mz2yn 65 80gp3 43 wk5ag 85 vufyp 93 p077j 94 f1oj5 11 lxjkg 72 0h7np 99 dk406 25 g4krp 76 fw3u0 80 6ld59 1 07khx 91 f1s88 72 bnb0v 85 a2qm7 79 z6cat 81 0m3do 23 m0s09 44 kivwd 13 gnud0 78 um93a 20 19bhv 75 4of3s 75 5hfen 16 this posgres table: table "public.mysort" column | type | modifiers --------+---------+----------- name | text | marks | integer | the sqoop command is: sqoop export --connect jdbc:postgresql://localhost/testdb --username akshay --password akshay --table mysort -m 1 --export-dir mysort/input followed error: warning: /usr/lib/hcatalog not exist! hcatalog ...
Read more