Using mysql, in a post table I use CURRENT_TIMESTAMP to store the date_time of publication. Everything was ok when I was working on wampserver on local. But I hosted my site yesterday on a server located in France, 2 hours…
I have a table containing 100's of entries - I have since after import, updated the columns to include a timestamp. The data is given to me by XMl and imported into DB I have 3 columns in the data.…
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 need to use some library to export product names, SKU and prices to one CSV file. This library connects using PDO and needs an SQL query. I want to select 'name', 'SKU' and 'price' from 2 WordPress tables, namely…
I have two tables ,departments and users.One department has many users.One user belongs to one department.Im trying to write a foreach loop to display the names of the departments with its users but i get this error. FacadeIgnitionExceptionsViewException Undefined variable:…
<?php session_start(); $mysqli = new mysqli('localhost', 'root', '', 'crud') or die(mysqli_error($mysqli)); //Izveido savienojumu ar datubāzi //default values $id = 0; $update = false; $name = ''; $age = ''; $mobile = ''; $location = ''; if (isset($_POST['save'])){ //pārbauda vai ir…
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 have a MySQL 5.7.29 database on which a website is built. I need to construct a query to find all table rows containing lines such as https://example.com/index.php?topic=7989.0 or similar and replace them with https://example.com/my-redirect-page/?7989.0 The wildcard here is the…