"Nothing" entered in the search gives error

[MatsP]

When using the Genus + Species search on the Cat-eLog homepage, if you enter "nothing" in both fields, we get:

Error: Query failed: 'SELECT clog_species.id, clog_species.species, clog_species.sl, clog_species.min_temp, clog_species.max_temp, clog_species.counter, clog_genera.genus, clog_families.family FROM clog_species JOIN clog_genera ON clog_species.genus_id = clog_genera.id JOIN clog_families ON clog_genera.family_id = clog_families.id WHERE;'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 11

Checking that EITHER species or genus has at least something in it should fix that.

--
Mats

[Jools]

Good spot, I have fixed that now.

Jools

[MatsP]

And, I'm sorry to say you broke the whole thing - any entry of any sort gives "no good, both fields empty".

--
Mats

[Jools]

Code: Select all

$genus == "" && $species = ""

instead of

Code: Select all

$genus == "" && $species == ""

, doh! However my regression testing sucked.

Fixed now.

Jools