Skip to content

Tag: php

SQL – Get multiple values when limit 1

If I have a table like this: And use this query: SELECT ident,COUNT(*) FROM sales WHERE status=? AND team=? AND DATE(date) = DATE(NOW() – INTERVAL 1 DAY) GROUP BY ident order by COUNT(*) DESC LIMIT 1 I get the value: cucu1, since that has the most rows. But if my table is like this: It should return bot…

PHP how to send and receive multiple choice box

I need suggestion. I have an list of position from database, displayed in table and in the last table row is an option to select “TAK” – YES and “NIE” – NO, please tell me is it possible and if it, how to send and receive it all selected to “TAK” fields at file …