Query Help

-

i have forms page allow user select 11 criteria – can select 1 or more 11. not have select 11.

 

i have following query:

 

mysql_select_db($database_conndb1, $conndb1);

$query_rsname = sprintf("select distinct table1.search_id, table1.search1, table1.search2, table1.search3, table1.search4, table1.search5, table1.search6, table1.search7, table1.search8, table1.search9, table1.search10, table1.search11, table1.search12, table1.search13, table1.search14, table1.search15, table1.search16, table2.search_id table1, table2 table2.criteria1 = %s or table2.criteria2 = %s or table2.criteria3 = %s or table2.criteria4 = %s or table2.critertia5 = %s or table2.criteria6 = %s or table2.criteria7 = %s or find_in_set(%s, table2.criteria8) or table2.criteria9 = %s or table2.criteria10 = %s or table2.criteria11 = %s , table1.search_id = table2.search_id order table1.search2 desc", getsqlvaluestring($search1_rsname, "text"),getsqlvaluestring($search2_rsname, "text"),getsqlvaluestring($search3_rsname, "text"),getsqlvaluestring($search4_rsname, "text"),getsqlvaluestring($search5_rsname, "text"),getsqlvaluestring($search6_rsname, "text"),getsqlvaluestring($search7_rsname, "text"),getsqlvaluestring($search8_rsname, "text"),getsqlvaluestring($search9_rsname, "text"),getsqlvaluestring($search10_rsname, "text"),getsqlvaluestring($search11_rsname, "text"));

 

however, when query ran, pulls records – not ones based on search criteria. now, if change or , and select 11, works should.  thus, has or operand. however, cannot figure out wrong. operand can use besides or allow work – allow searcher select 1, 2, 3 or more criteria?

i figured out - had move parenthesis around cover entire clause or in it.



More discussions in Dreamweaver support forum


adobe

Comments

Post a Comment

Popular posts from this blog

Object Fitting Keyboard Shortcuts Disfuntional

-
my object fitting keyboard shortcuts not work.  however, these functions work fine when selected dropdown menus.  example, 'ctrl+alt+c' nothing, selecting 'fit frame content' dropdown menu works fine.  other object fitting options.  use these keyboard shortcuts time , them work.  how can fix this?    i using indesign cs6 windows (64bit).  have tried reloading/updating preferences , reinstalling indesign.  additionally, cannot add these shortcuts keyboard shortcuts defaults, system thinks loaded.  here, when attempt add 'ctrl+alt+c'  in 'new shortcut' box (under: edit - keyboard shortcuts) nothing happens - cannot add , not appear in box when press keys.  when attempt others 'ctrl+alt+e', et el, appear in box , assigned defaults (as should be).  ideas?  said, typically use these shortcuts regularly bit of pain not work currently.  did try copy set of custom shorcuts earlier version? taht might work cs5 or 5.5, e...
Read more

Markers not showing up after opening a saved project. Where did they go!?

-
my first time using prelude cs6 yesterday , had success ingesting, marking clips (into subclips, comments, etc.), saving marked movies, , them sending subclips premiere. dumped premiere expected.   however, morning started new project in premiere , planned on using same clips marked in prelude. wanted little more marking opened prelude project saved yesterday , movie files there none of subclips, comments, or other markers showing up.   the thing can think of did not rough cut in prelude, don't see why mean losing markers source footage.   am missing something? appreciated! thanks... -john i'd confirm steps: 1. ingest clips in pl add markers(subclip, comment, etc.) , save them. 2. create 1 new project in ppro , import same clips. 3. open project created @ step 1 in pl.   then @ step 2 , 3, found markers lost, right?   to locate issue quickly, if possible, share 1 of footage me? please reach me @ wyue@adobe.com . thanks. More discussions in Adobe Prelude ...
Read more

Photoshop javascript: Open files in all subfolders

-
hi guys   i'm new javascript, , general photoshop scripting. script coming on well, struggle working files , folders. it's lack of basic javascript knowledge, need work on. right now, i'm trying expand image open part of script, opens images regardless of whether in subfolder or not.   you can see input folder (c:/input). want able throw files in there, in folders, not. out of interest, outputs combined 1 output folder... bit fine.     var infolder = new folder("c:/input") if(infolder != null){ var filelist = infolder.getfiles(/\.(jpg|tif|psd|bmp|gif|png|)$/i); } for(var = 0 ;a < filelist.length; a++) { var docref = open(filelist[a]); //do things here }   is there easy way of expanding include files in subfolders? advice appreciated. thanks david folder.getfiles() works 1 folder @ time. files in folder in subfolders need scan each subfolder. 1 way recursive function. this:   var topfolder = new folder('~/desktop/test'); var fileandfolderar = scansub...
Read more