I have a very simple table that looks like this: It's called anni_tot and it has a single field called anni. Now, there is another table that looks like this: It is called people_emp. Now, I want to insert a…
I'm trying to build a filter function with several dependencys but when i add an AND to the SQL query, it seems like no results were found but if i'm searching with the queries before and after the AND, the…
I want to return rows where certain fields follow a particular pattern such as whether a particular character in a string is a letter or number. To test it out, I want to return fields where the first letter is…
How to create the well known export as SQL in latest phpMyAdmin ? There is no choice for SQL anymore!
fetch data from sql and store it in javascript variable. i already have phpmyadmin connected to my website. i am trying to get two variables (date) from my sql table. JAVSCRIPT: var countdown_48 = new Date; countdown_48.setHours( countdown_48.getHours() + 48…
I'm traying to get product sku that are displayed on the website with the category of that product. Output: +-------------+------------+ | sku | category_n | +-------------+------------+ | 855202 | test1 | | 87972_k | test2 | | 887997 | test1…
I am the designer for a small business and I have been tasked with trying to get a Laravel project to work on the customer's server. I am not a PHP expert and only know a small amount - I've…
I have tried to write a code that update category in the database using admin panel but whenever i try to do that it won't work and i don't get any errors to look into it, please help guys; thanks…
I need to delete/truncate the Magento 1.9 core URL rewrites which are older than 3 months of core_url_rewrite table in database. What's the exact SQL query to achieve this?
In my database, there is a table which shows the landing pages, and what I want to do is to classify if the traffic is from SEO channel. When the landing page is exactly equal to the pattern /countrycode/index.aspx, then…