SQL - Search specific and all

-

i have website searches predefined data. basically, pictures 2 different categories @ same time. 2 search list predefined. works great.

in database have statcode such clearance, best seller, special. have major category, such country art, christmas art, animal art, floral art,etc. when selects country -clearance, returns right thing. when select selection out of both columns selects right things.

the problem when selects "all" in category.
the default value of sql expression in recordset takes precident. if have set "0", looks "0". want when selects "all" want return in category , filter other. or if select in both, want every thing show.

please help..

if confusing, try explain more.

the principle you'd use like. eg

where category 'mm_colparam'

and use default of % parameter.

--
jules
http://www.charon.co.uk/charoncart
charon cart 3
shopping cart extension dreamweaver mx/mx 2004





More discussions in Develop server-side applications in Dreamweaver


adobe

Comments

Post a Comment

Popular posts from this blog

Connecting Raspberry Pi 2 to P10(1R)-V706 LED Dot Matrix - Raspberry Pi Forums

-
Image
hello everyone, name kedi.. make system connecting raspberry pi 2 , arduino uno arduino adc of 1 dust sensor sharp gp2y1010au0f , 4 gas sensor. want show decision of air quality system in running text @ p10 16x32 led dot matrix display. in raspberry pi 2, connect p10 pins in gpio25, gpio12, gpio16, gpio13 & gpio26. now, i'm finish circuit , don't know must connect p10's vcc & ground (red & black wire). can me? , code in python controlling p10(1r)-v706 dot matrix?.. regards, kedi i can't python code (did mine in basic on risc os) regarding power, panels each require 2.5a, you'll need separate supply them. if attempted power them pi, pi's polyfuse blow immediately. alternatively, use supply capable of giving 10a supply both panels , pi. raspberrypi
Read more

TypeError: <unknown> is not a numpy array - Raspberry Pi Forums

-
hi, thank help. question simple: how convert raspistill data opencv processing. code: select all def capture(settings, width, height): command = "raspistill %s -w %s -h %s -t 200 -e bmp -n -o -" % (settings, width, height) imagedata = stringio.stringio() imagedata.write(subprocess.check_output(command, shell=true)) imagedata.seek(0) im = image.open(imagedata) buffer = im.load() imagedata.close() return im,buffer code: select all image1, buffer1 = capture(camerasettings, testwidth, testheight) cv2.imshow('image',image1) want use different opencv processing techniques, before need know doing wrong. bests svato raspberrypi
Read more

datso and removing imagetitle - Joomla! Forum - community, help and support

-
hello everybody i have installed datso v. 1.3.8 , remove imagetitles http://www.galleri-kbh.dk/index.php?opt ... ry&catid=2 on datsos  homepage there no names, can't find function in parameters in administration?? http://www.datso.fr/datsogallery/viewcategory/2.html can me. vh jan found way it  :d delete line 307 "$tle = ereg_replace('"', '', $row1->imgtitle);" in file components/com_datsogallery/datsogallery.php Board index Joomla! Older Version Support Joomla! 1.0 Extensions - 1.0.x Components
Read more