Searching two tables - one blank search field

-

i have databse links locations regions of uk , type. type , regions stored in 2 separate tables both of type 2 fields id , text. ids link table (location) has regionid , typeid field refere detail tables. have search page allow search region , type works fine if select in both text boxes returns nothing if 1 left blank. how round this?

sounds manual coding me. if understand correctly
you have 2 search fiels , if 1 blank no results.

questions
- platform?
- want users enter info both fields?
- how large table or how large be?

quick suggestion
- if table small quick , dirty way use wild cards both
fields.




More discussions in Develop server-side applications in Dreamweaver


adobe

Comments

Post a Comment

Popular posts from this blog

Convierte tu Raspberry en un NAS. Firmware fvdw-sl 15.3 - Raspberry Pi Forums

-
¿conocéis este proyecto? fvdw-sl 15.3 para raspberry pi. convierte la raspi en un nas. http://plugout.net/viewtopic.php?f=31&t=1880 llevo tiempo intentando encontrar la forma de hacer que una de mis raspberry se comporte como un nas. configurando samba, minidlna, transmision, ftp, nfs, etc. pues con esta distribución lo tengo todo hecho. lo instalé ayer y me tiene soprendido. ahora mi raspi es un nas, hecho y derecho. caracterísitcas. - interfaz web. que cambia en función de si eres el administrador o un usuario. - gestión de usuarios. puediendo dar distintos permisos carpetas y funciones. - gestión de carpetas - vpn - ftp - nfs - webdav - varios servidores dlna como minidlna, townky, etc - varios gestores de descarga como transmision, mldonkey, etc - gestión de periféricos usb como impresoras o webcam. - gestión de cron para automatizar procesos. - creo que se basa en arch linux. por cierto, estoy creando una tarea para que me exporte un archivo txt del dis...
Read more

How to format a Get Request

-
i have external server running mysql. have installed php script that, when accessed http deliver data 1 of tables. works fine browser: code: [select] http://www.seti.net/php/getevents.php i cannot figure out how send command arduino. have ethernetclient library working , can access google in example. when send command through client: code: [select] client.println("//get /php/getevents.php http/1.0"); the server returns: code: [select] </head><body> <h1>method not implemented</h1> <p>get /php/getevents.php not supported.<br /> what correct way format in arduino? i use send temperature web server. note lack of http version , additional blank line after - not sure whether difference important works: code: [select] void  sendtemptoserver() { char getrequest[80]; if (client.connect(server, 80))   {   sprintf(getrequest,"get /cgi-bin/arduino.cgi?reading=%s&arduino_id=23&sensor_id=1",t...
Read more

avrdude: verification error, first mismatch at byte 0x0000 0x0c != 0x62

-
hello, im confused uno r3, uploaded code quite few months in uno, working fine. now without having altered of circuits, trying upload code changes,im getting strange error "avrdude: verification error, first mismatch @ byte 0x0000          0x0c != 0x62" i tried research able solve issue,  im running kind of fuse bit being changed or clock speed altered, im pretty sure did not play around these items. any people, please . . thanks taz Arduino Forum > Using Arduino > Installation & Troubleshooting > avrdude: verification error, first mismatch at byte 0x0000 0x0c != 0x62 arduino
Read more