So I have a new computer and I'm trying to set everything up for some projects. When I try to import some databases I'm getting this message after the import fails in phpmyadmin: Missing expression. (near "ON" at position 25)…
I've looked at similar questions, and the answers I get is to put limit in my query, which I did. Here is the query $sql = DB::table('inventorysku_tb as isku') ->leftJoin('inventorytrackingmodules_tb as itm', function ($join) { $join->where('itm.coID', '=', 4) ->whereBetween('itm.effectiveDate', ['2021-05-01',…
I'm making one custom app that already has over 10.000.000 users. I had to create one custom query that extracts users from a specific member type. The problem is if I want to see only 20 users and do pagination,…
Essentially I want to order by "title", while grouping movies with the same, non-NULL "series_id" together within that order. Titles where series_id IS NULL should order by title only, while non NULL series_ids should order by "series_order" and be listed…
I want all the 'acteurs' of a table in the value of a option, but I don't know how to. I have two tables, 'auteurs' and 'posts'. In the posts table I have a column named 'auteur_id' that has a…
I have 2 table, warehouse and item category, i wanna show my table in select option ajax. I managed to display select option item category. My Ajax Code $(function () { var i = 0; $("#add-more-item").click(function () { ++i; $.ajax({…
I got 2 different databases and 2 tables Here's Table.1: Table.1 username | date | phone number | rank | user1 | 2021 | xxx xxx xxxx | ALL | user2 | 2021 | xxx xxx xxxx | river, domain,…
Hello :) here is my docker compose : version: "3.8" services: web-server: build: . volumes: - ./:/var/www/html/ ports: - "8000:80" links: - "db:db" db: image: mysql:5.6 ports: - "3306:3306" environment: MYSQL_ROOT_PASSWORD: root phpmyadmin: image: phpmyadmin/phpmyadmin ports: - "8001:80" links: -…
I'm using Linux with xampp, I have a problem with MySQL. When I use this command sudo /opt/lampp/lampp start, it starts everything correctly, and when I use sudo service mysql start when MySQL of xampp is already running, the command…
Please I need help with the right query for this query below... SELECT compute_num, SUM(`shar_cr`) AS shar, SUM(`thri_cr`) AS thri, SUM(`vol_cr`) AS volun FROM `member_transacting` WHERE date BETWEEN '$from_date' AND '$end_date' RIGHT JOIN regist_members ON member_transacting.compute_num=regist_members.m_compute_num ORDER BY date DESC…