berndf52

Good morning Kim!

Following to my questions…

If I reduce the default where clause to just …

Name = httpGet[‘Name’]

… and enter a name existing in the table, I get an empty answer, i.e. no corresponding records.

But the default where clause is definetly used – I get an sql error when it is syntactically incorrect!

Thank you for your effort!

Best, Bernd

Hello Kim,

first thank you very much for your help and for sharing your demo – it really helped! On my web side I now have two pages: A form/query page with:

<form action="/napoleonische-akten/" method="get"><p>Name <input name="Name" type="text" placeholder="Suche Familienname" /></p><p>Geburtsort <input name="Geburtsort" type="text" placeholder="Suche Geburtsort" /></p><p>/**and so on if you want to add more fields**/<input type="submit" /></p></form>

… which gives on the form/query page:

When I fill the two fields with e.g. “Henry” and “Worms” and press the button “Daten absenden”, the URL https://landeskunde-saarland.de/napoleonische-akten/?Name=Henry&Geburtsort=Worms is “called”. But the result page always shows ALL rows in the table, not only the one I requested – no matter what I insert in the search fields – I allways get ALL rows.

The default where clause in the results page is:

(Name like httpGet[‘Name’] OR httpGet[‘Name’] like ” OR httpGet[‘Name’] is null) AND (Geburtsort like httpGet[‘Geburtsort’] OR httpGet[‘Geburtsort’] like ” OR httpGet[‘Geburtsort’] is null)

php-myadmin shows the following columns:

What am I doing wrong?

Best, Bernd Färber