Leaderboard
Popular Content
Showing content with the highest reputation on 03/16/2020 in Posts
-
the associative index for the COUNT(*) expression is actually something like $row['COUNT(*)']. to simplify this, add an alias name for the COUNT(*) expression in the query and use that alias name for the associative index. next, both of the query examples you have shown will/probably match at most one row. why you are using a loop to fetch the data. just fetch the single row without the loop.1 point
-
Why don't you do some good old experimentation and see where it works? Or you could look it up in a manual.1 point
-
Typing it is a good way. Put it after the FROM section and before the ORDER BY.1 point
This leaderboard is set to New York/GMT-04:00