So i have a table that has multiple date time columns and i am trying to select certain records based on a certain date using SELECT * FROM `posdata` WHERE `CommissionDate` >= '2019-01-01 00:00:00' the table structure CREATE TABLE `posdata`…
I'm trying to query all posts from my Wordpress site that have wp_terms.slug = 'portfolio-photos'. I've connected the tables using wp_terms, wp_term_taxonomy, wp_term_relationships and wp_posts. I'm not sure what's wrong with the SQL code I have. Can someone advise what's…
I'm attempting to retrieve all the data from a column in mysql by having the user input which table and column the data is through the mysqlconnector library in python. When I ran the query through python no data would…
can you edit people's permission on PhpMyAdmin? like this guy can be a mod (Has more permissions) and this other guy cannot on the website by editing. Is it possible
Server version: 5.7.29-0ubuntu0.18.04.1 (Ubuntu) I am trying to save output to file: /var/www/dir/file.csv It gives me an error: Can't create/write to file '/var/www/dir/file.csv' (Errcode: 13 - Permission denied) It is PHP script, executing through browser. Permissions: /dir/ (ls -al) drwxrwxrwx…
I am trying to publish my website through cpanel. when I run the web url of my site, it gives the error Access denied for user 'root'@'localhost' and my .env file is given below APP_NAME=Laravel APP_ENV=local APP_KEY=base64:wwuqMKOwBR67OJgHY76xAxEFbCqyKTE/Fd1T25Xfjg8= APP_DEBUG=true APP_URL=http://salonfurnisher.co.uk/public/ LOG_CHANNEL=stack…
I need help figuring out what's wrong. I want to install phpmyadmin on a server to import a wordpress DB but when I install it I have a problem with php-twig I install phpmyadmin : debian@XXX:~$ sudo apt-get install phpmyadmin…
I use Wordpress/Woocommerce with MySQL. I need to find all orders with the same billing phone as a given one. The basic SQL is below. The problem is that when the phone numbers were stored in the DB they were…
I've been at this for a few days now trying different methods to reduce the 95-135% CPU load due to a recent AJAX script, calling this query: SELECT COUNT(*) as total FROM users WHERE last_access >= DATE_SUB(NOW(), INTERVAL 1 MINUTE)…
SELECT zmogaus_id, hobio_id, hobio_pav2 FROM zmogaus_hobiai LEFT JOIN hobiai ON zmogaus_hobiai.hobio_pav2=hobiai.hobio_pav WHERE zmogaus_id=3 Using this I want to get zomgaus_id =3 . hobio_id =1 . hobio_pav2 =name1 (from hobio_pav) zomgaus_id =3 . hobio_id =2 . hobio_pav2 =name2 (from hobio_pav) But…