There is a table: id(num), name(text), fld1(num), fld2(num), fld3(num)
In this case, the sample is conducted on the specified properties, for example

 SELECT id FROM $db_table WHERE fld1 LIKE '1' AND fld2 LIKE '4'.

There is a task:

  1. Display the total count of conditional database records.
  2. If the choice of options, in the database there is nothing - replace the element.

In general, this is probably my 20th query in SQL - and I still don’t really understand how to generate it, and then - parse it, and the deadlines - until Monday%)

  • @cyadvert 20 request, not a question - korytoff
  • a :) well yes ... blame :) - cyadvert

1 answer 1

Suitable:

 SELECT Count(id) FROM $db_table WHERE fld1 = '1' AND fld2 = '4'