Am building a website using PHP and MYSQL and got stuck on how to get the number of comments for each individual post. I tried to do something but it was giving me the total number of approved comments for…
I admit that I am new to back-end work in general and I seem to be stuck (for several hours) following through with completing the setting up process for Magento 2.3 I was following https://devdocs.magento.com/guides/v2.3/install-gde/prereq/mysql.html for my commands but to…
I am fetching data from two tables using query with WHERE clause. Query is working fine in local xampp but when I try to run same query in online phpmyadmin then it showing all available result(instead of filtering with WHERE…
I want to make a Left Join in MySQL. The join is base on a condition. For example, if the value is 328, use Left Join <table A> ELSE use Left Join <table B> Below are the queries: SELECT *…
Im trying to insert Form information into the database.A very simple code. I've verified to all the other answers in the site but it does not work <?php session_start(); // variable declaration $school_name= ""; $dob = ""; $stu_name = "";…
I am new in docker and I try to connect to a mysql container from the local machine (host). I pulled the latest version of mysql with: docker pull mysql/mysql-server:latest and started this (and the myadmin container with the following:…
I know there are already some answers to this question but none of them seem to work for me. Basically, i've got tasks which are nothing more than presets sheduled over time : i want to update the tasks date…
I'm writing an api in nodejs and I'm trying to figure out how twitter and facebook shows posts from only the people that we follow.. My initial thought was loop through the posts and filter them according to followers ID,…
Currently have an issue with following query spawning multiple times: SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_a... Whatever it is, it's causing my CPU to spike to the roof... My ony solution so far is to reboot the…
I have a custom table in MySQL database, which I am trying to query using global $wpdb. I have defined my query using information available from the following two sources: https://codex.wordpress.org/Class_Reference/wpdb https://wordpress.stackexchange.com/questions/233021/display-data-on-word-press-site-posts-and-pages-from-mysql-table This is how the data is in phpMyAdmin:…