I'm setting up a new web application, and i want to find out a way to insert a row from PHP in Greek language I make the connection with MySQLi from PHP like this: $con = mysqli_connect("localhost", "root", "", "Mydb");…
I am trying to query a simple table to get a users id based on their username. For some reason I am getting a null result for all of my queries. Table creation: CREATE TABLE users( user_id int not null…
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 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 *…
I want to display certain DIVs to certain users. To do that I have a column in phpMyAdmin, called "UserType" which indicates if the user is above or below 18. Based on that, if the user is below 18, I…
I'm building a website by opencart2.2. I have installed a module on my website with opencart2.2. This module is inculded a sql file as following code. Now I want to uninstall the module, but I don't know how to uninstall…
I am trying to execute the following. public function result_multi($sql) { try { mysqli_multi_query($this->db_connection,$sql); $result=mysqli_store_result($this->db_connection); $row=mysqli_fetch_row($result); } $b=new DB; $sql="INSERT INTO payout (mid, type, datetime) VALUES ('0','BC', NOW());SELECT LAST_INSERT_ID();"; $b->result_multi($sql); $row returns NULL and $result return FALSE, however when I…
Summary When I use the phpMyAdmin GUI to insert a new entry into my table (which has a BEFORE INSERT TRIGGER applied to it), it seems to insert the entry just fine... but it always displays this in response: (…
I have the following query which gets order data, works fine but takes 13.63 seconds: SELECT ( SELECT meta_value FROM `myprefix_postmeta` as postmeta WHERE postmeta.meta_key = '_sku' AND postmeta.post_id = woocommerce_order_itemmeta3.meta_value ) AS sku, woocommerce_order_items.order_item_name AS title, SUM( woocommerce_order_itemmeta.meta_value )…
I want to copy a row for example whith ID=23 in a table A into another table with ID=30 into another database. I got this INSERT INTO pacaya_control_venta.tb_venta_pacaya WHERE ID=33 SELECT * FROM llamadas.tb_venta_pacaya WHERE ID = 48; But I…