Skip to content

Tag: jquery

Dense_Rank does not work as it is expected

I’m creating a query where I need to get the ranking depending on how many are duplicated in the column “MacAddress”(amount) in the table MacsUsers, this is the data: this is my SQL query: I think I’m doing well with the DENSE_RANK function but it does not work as it is expected, any possible solution? thanks advance Answer Your DENSE_RANK

Slow SQL Query / Displaying (PHP / jQuery)

I have a request to get data in my mySQL database (36,848 entries). Then I format and append them with jQuery on my web page. These two operations take 2 minutes and 30 seconds. During this time, no other operation is possible on the page. Is there a way to optimize this to speed up the process? Like this, it’s

Dropdown selection based on other dropdown [closed]

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question I am working on a webform that will allow the user to simulate a purchase of a movie ticket. The date/time should change dynamically based

How to access multiple variables outside foreach loop in php

I am not a php pro and have already explored different online search forums but could not find any suitable answer and that’s why posting my question here. Function One: Runs a query to database and define variables in foreach loop as follows: Function two: Now I want to get the values of those variables in another function as follows:

How to calculate aggregate on inner join

I have two tables, Post & Comment. Post table contains info about posts & comment table contains the comments data about each post. Below is there structure, I need to take post_id, post_title from post table and total no of comments (using aggregate function count) on each post from comment table & want the data to be showed like this.