Linked Questions

in Wordpress template's function.php following code is working well // Function accepting current query function my_change_order( $query ) { // Check if the query is for an archive if($query-&...

I am stuck with a query builder in laravel 8 DB::table('users') ->join('contracts', 'users.id', '=', 'contracts.user_id') ->join('roles', 'roles.id', '=', 'users.role_id') ->...

$query = ('SELECT tb_imam.*, tb_bidang.bidang FROM tb_imam JOIN tb_bidang ON tb_imam.bidang_id = tb_bidang.id WHERE tb_imam.status = "Pengerja" ...

I have two tables. One of them named files and there is al list of all files. the second table called payments, and there is in there a list of payments for some files. Payments: id | fileid | {...} ...

I have a query select c.CommentId ,c.CommentText , c.CommenterId , c.CommentDate , u.first_name , u.last_name , i.ImageName , i.Format from comment c join users u on c.CommenterId = u.user_id ...

I am attempting to join two tables, and also order the query results by one of the columns within the table I am joining. Everything works great until I add ORDER BY cm.num, at which point I get this ...

I'm having a problem with my Select command, first of all, I need to show all the hours that are different from the idHour on other table here's the code: SELECT DISTINCT Hours FROM agenda_hours A ...

I am absolute beginner in creating database and I only know that we can use, "SELECT * FROM users WHERE username = '$username' and password = '$password'"; but, what if there is multiple ...

How do i fetch multidimensional array data in my table. As per in my image foodname, quantity, price should be fetch in my table.

My database has 3 tables i wish to access in the select query but I cannot seem to get it to work. Selecting from 2 tables works fine so I know everything else is working apart from my code for ...

I execute Query A, it gives me the result i.e 4,5,6. And If I use that result directly into the Query B in WHERE IN clause, it gives me the perfect result again. But If I use both the query combined ...

I have the following MySQL query: SELECT u.id, u.ap, q.quests FROM users u JOIN( SELECT count(quest) as 'quests', user FROM active_quests WHERE user = 143 ) q ON u.id = q.user ...