I am using the below query for a single word in phpmyadmin: call insertIntoWPPOSTMETA('episode 2'); But when I try to use it like this, it does not work: call insertIntoWPPOSTMETA('episode 2','episode 2'); How can I use 2 words or more…
I attempt to get the result of a very simple query with the function query but nothing appears. If I execute the query in PHPMyAdmin, with the same data, I have a result. There is my code : $sql =…
I have this statement: UPDATE `tblAllocatedLeads` SET tblAllocatedLeads.fldAllocatedStatus = CASE WHEN tblAllocatedLeads.fldAllocatedStatus = 'Allocated' AND (SELECT COUNT(*) FROM (SELECT * FROM `tblAllocatedLeads`) AS tblallocate WHERE AND tblallocate.fldAllocatedLeadId = tblAllocatedLeads.fldAllocatedLeadId) > 1 THEN 'Outstanding' END What I wanted is that update…
I have a MySQL database containing a single table which is used as a temporary storage point for manipulating and querying data sets and is periodically deleted and replaced with new data. What I would like to be able to…
We have the following table id # primary key device_id_fk auth # there's an index on it old_auth # there's an index on it And the following query. $select_user = $this->db->prepare(" SELECT device_id_fk FROM wtb_device_auths AS dv WHERE (dv.auth= :auth…
In my PostgreSQL database I have table with such structure: | organization_id | organization_name | parent_organization_id | tree_organization_id | |-----------------|-------------------|------------------------|----------------------| | 1 | Alphabet | | | | 2 | Google | 1 | 12 | | 3 | Google…
I'm having some trouble with the final column that is to give me the number of days between the first and last date a movie was rented. My instructors correct output: My incorrect output. Some of the output in my…
I want to build simple database system about bike (or bicycle) rental store. Here are the tables, and columns in parantheses: Model (MNr, Modelname, dayprice) Bike (MNr, CopyNr, Frame, Color) Customer (CNr, Name, Surename, MobileNr) Rental (CNr, MNr, CopyNr, DateOut,…
I want to filter by query sql. Which color of blue, type of boy and size :35,36,39 to choose and display. For Example: SQL Table (PHPMYADMIN) -------------------------- |id| size | type | color | -------------------------- |1 | 35 | boy…
Using a SQL query, is it possible to count the number of Woocommerce orders for each user id? SELECT customer_id FROM subscriptions WHERE status = 'cancelled' GROUP BY customer_id I've generated the list above of user id's, now I need…