$sql = "INSERT into x (y,z,t) VALUES ((SELECT userID FROM users WHERE username ='".$usersql."')," ."'"."(SELECT itemID from items WHERE category ='".$category."')," ."'".$amountdays."')"; Thank you for your time.
I have two table events and session which looks like this Events table Sessions table I want to display data based on date ranges Here is my solution SELECT sessions.sid, events.datetime, count(*) as num_rows, count(distinct sessions.sid) as sessions, sum( targetbuttonname…
So I ran a php file where I'm connecting it to a Database and executing a query, but I ended up getting an error stating Error updating record: You have an error in your SQL syntax; check the manual that…
I have two table events and session which looks like this Events table Sessions table Here is expected results Here is my solution <table> <tr> <th>Sessions </th> <th>konto</th> <th>Mobile</th> <th>Komputer</th> <th>Date</th> </tr> <?php $conn = mysqli_connect("localhost", "root", "", "ideabank_julia"); //…
I'm trying to upload this sql file that's 225MB to phpmyadmin with MAMP. However, I keep getting this error Script timeout passed, if you want to finish import, please resubmit the same file and import will resume. I've changed the…
Script below creates a simple database and table. In windows environment, you can use it with wamp server's ( https://sourceforge.net/projects/wampserver/ ) phpmyadmin sql console: delimiter $$ create database testtimes $$ use testtimes $$ create table mytime ( hour bigint not…
Using MySQL, I have the following table called subscriptions shown below name, renewal_date, national_id --------------------------------------- ted, 1/2/2010, A1111R ben, 1/3/2010, A145E1 bob, 8/4/2009, A11C11 kate, 2/2/2010, A111E1 ted, 12/2/2011, A1111R bob, 12/2/2014, A11C11 ben, 12/2/2016, A145E1 etc.. The table has…
I'm trying to update a particular url in wordpress post_content table. I have over 5000 differents urls to update for a single same one. So in clear I have 5000 urls that all starts with : domain.com/params.php?.... AND always ends…
Good day, I have a woocommerce eshop in which I do not use variants ... all products are simple. But for partner shops I need to create XML with variable products. I have products that are not published are "hidden"…
Here my MySQL query (work in phpMyAdmin) : SELECT waktu_kerusakan, workcenter, COUNT(workcenter) AS jumlah_repair FROM repair WHERE year(waktu_kerusakan)='2019' GROUP BY workcenter , month(waktu_kerusakan) BETWEEN 1 and 6 Order By jumlah_repair Desc then, i try in Laravel Syntax like this below…