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…
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…
My version table has 8 attributes, all are populated when inserting a Project (One to many relationship, projects - versions). Why do I get this error if I have the complete fields? Or how are values loaded to a table…
I did several tests, the view values are saved in the model, but do not pass to the database. The values entered by screen are printed perfectly by console, but at the time of being entered into the database, it…
I have a problem in SQL. I want to update a value on a given row if and only if a value on another row matches a condition; then update another value on the second row. Ok it can't be…
I'm having difficulty to make a cron job on cpanel to update the state of an user if the account has been created for 5 days. It just doesn't work at all. When I program the cron job on the…
I need to run a query in phpmyadmin that joins wp_users with wp_usermeta on the user_id to ID. I have the below so far. SELECT wp_users.ID AS 'User ID', wp_users.display_name AS 'Name', meta_value AS 'Representative' FROM wp_usermeta JOIN wp_users ON…
On Monday I messed up with a database. We have an application running on a VPS, using cPanel and phpmyadmin, and I informed the developers I will be doing some queries on the DB to extract information. So, I did…
I need to get the sum of digits of year in format date, for example 1997 = 1+9+9+7 = 26. I have to do it in MySQL with SELECT only. I've tried to use SUM function, but it sums only…
So I'm starting to learn how to use PHP to access MYSQL databases and after successfully connecting to the database. I want to select data from it. However I get the issue that the table doesn't exist. Yet, it exists…