Barand

You show two different outputs. Which one do you want? Or do you want a third version and, if so, what? What is your database structure?

Because you are LEFT JOINing to signup and children tables you cannot put selection conditions on those tables in a WHERE clause. If you do then the LEFT JOINS will behave like INNER JOINS. You need to put those criteria in the ON clauses for the joins, SELECT * FROM activities LEFT JOIN signupActivity ON activityID = SignupActivityID LEFT JOIN children ON signupActivitychildID = childrenID AND childrenID = 33 WHERE activitySection = 3 (DON'T use SELECT *, specify just those columns you need)

Well, you've certainly moved the goal posts since your original post on which my solution was based. Provide an SQL data dump of the necessary table, so I don't waste more of my time setting up test data, and I will look at it again for you.

If there's no id field, what is the primary key on that table?

Somewhere you need a table which would tell the query that 30 books were available for item_id 8 if you want to know how many you can loan

Mine relied on each row in mecze table having a unique "id" column. My output is copy/pasted from mysql command line

try SELECT mot , COUNT(*) as nmbr , GROUP_CONCAT(pseudo ORDER BY pseudo SEPARATOR ', ') as players FROM unanimo GROUP BY mot HAVING nmbr > 1 ORDER BY nmbr DESC; +--------+------+-------------------+ | mot | nmbr | players | +--------+------+-------------------+ | beetle | 3 | Mary, Paul, Peter | | spider | 3 | Mary, Paul, Peter | | animal | 3 | Mary, Paul, Peter | | bird | 2 | Mary, Paul | | bug | 2 | Mary, Peter | | cow | 2 | Mary, Paul | | dog | 2 | Mary, Paul | +--------+------+-------------------+

try SELECT country ,Competition ,match_date ,ko_time ,home ,away ,Result ,Profit ,cum_profit FROM mecze INNER JOIN ( SELECT id , @cum:=@cum+profit as cum_profit FROM mecze JOIN (SELECT @cum:=0) init ORDER BY ko_time, id ) cum USING (id) ORDER BY ko_time DESC, id DESC; +---------+----------------+------------+----------+--------+--------------+--------+--------+------------+ | country | Competition | match_date | ko_time | home | away | Result | Profit | cum_profit | +---------+----------------+------------+----------+--------+--------------+--------+--------+------------+ | Europe | Europa League | 2015-11-05 | 20:05:00 | Sparta | Schalke | L | -10 | -12 | | Denmark | Superliga | 2015-11-05 | 18:00:00 | Aarhus | Sonderjyske | L | -10 | -2 | | Europe | Europa League | 2015-11-05 | 18:00:00 | Plzen | Rapid Vienna | W | 10 | 8 | | Europe | Europa League | 2015-11-05 | 18:00:00 | Celtic | Molde | W | 8 | -2 | | Bahrain | Premier League | 2015-11-05 | 15:00:00 | Manama | East Riffa | L | -10 | -10 | +---------+----------------+------------+----------+--------+--------------+--------+--------+------------+

this query should calculate the scores for you SELECT pseudo , SUM(nmbr) as score FROM unanimo INNER JOIN ( SELECT mot , COUNT(*) as nmbr FROM unanimo GROUP BY mot HAVING nmbr > 1 ) tot USING (mot) GROUP BY pseudo ORDER BY score DESC; Data and results

Use password_hash() and password_verify(). http://php.net/manual/en/function.password-hash.php (You may find the notes on that page useful if you are not yet on PHP5.5+)

Yes. But unlink() is a function, not a variable.

Is it something simple like that page is missing the session_start() call at the beginning of the script?

Don't put FiscalYear condition in the WHERE clause, put it in the table join condition LEFT JOIN eventtbl e ON c.cid = e.cid AND e.FiscalYear = 'FY16'

BTW, "dog"=<"Image/Dog.jpg" should be "dog"=>"Image/Dog.jpg"

You could check if the age value is numeric. If it isn't (header), skip the insert.

Exclude dates that you don't want to display in the original query. Don't select them then hide them.

You said that "CNT_TXT_WARNING_EMAILSENTOK" is defined in a text file. How do you get it from said text file to that script?

It worked well enough for me to produce that output. You may have to make one or two minor tweaks to adapt it to your database and table.

I already gave you the code that produced that output. How much more help do you need?

My guess, and what my code in #8 above gives, was

Do have CNT_TXT_WARNING_EMAILSENTOK defined anywhere, for example define("CNT_TXT_WARNING_EMAILSENTOK", "This is a message to say it is OK");

Your implementation is nothing like my example. The STR_TO_DATE() in my example is in the VALUES(..) part, you have just added in the columns part.

You need to put dates into the database in yyyy-mm-dd format so if your datepicker is using dd/mm/yy then the date needs converting. You can do this in SQL with the method shown in this example INSERT INTO table (mydate) VALUES (STR_TO_DATE($datepickerdate, '%d/%m/%y') )

Moving to AJAX forum

You need to concatenate header("Location:../presupuesto.php?msg=" . CNT_TXT_WARNING_EMAILSENTO);