amitinddr

Thanks Micheal for your help. I think I am all good now.

That was Genius Michael. It worked like a charm.

Unlike before, it does not show all the data in the table now. That is something good for me. Is there a way I can hide the table on page load and show it only after receiving inputs for search OR show all the data in table?

Also, the form fields do not retain the values that were selected. Can we have the fields remember the values so that the user knows what results the user is looking at?

Last one, previously, I could search for a city and it would show all results of that city for all blood groups. But now, the fields work only in combination i.e. I cannot input any one field and leave other blank. Is there a workaround for that?

Thanks for your help so far.

Thanks
Amit

Thanks for the information Micheal but seems I do not understand much. I am a newbie ??

Can you please help me re-writing this form so that I get accurate results?

<form action=”” method=”POST”>
City:<select name=”city”>
<option value=”Exton”>Exton</option>
<option value=”Malvern”>Malvern</option>
</select>
Blood Group:<select name=”bloodgroup”>
<option value=”O+”>O+</option>
<option value=”O-“>O-</option>
<option value=”A+”>A+</option>
<option value=”A-“>A-</option>
<option value=”B+”>B+</option>
<option value=”B-“>B-</option>
<option value=”AB+”>AB+</option>
<option value=”AB+”>AB-</option>
</select>
<input type=”submit” />
</form>
[cfdb-datatable form=”Registration” filter=”City~~/$_POST(city)/i&&Blood-Group~~/$_POST(bloodgroup)/i” show=”Name,City,Blood-Group”]

Thanks
Amit

It would be great if you can please do that for me. Here is the screenshot – https://www.dropbox.com/s/pfcmynmkm6kokkn/form-screenshot.jpg?dl=0

(Sorry, seems you provided incorrect email ID)

Thank you for quick response. Sorry but I am not much techie. As far as I know, Firebug will just change it on the front end for that particular session. Is there a way I can peep into database and change it for all sessions for always?

Ah sorry, I missed that. Thanks ??