I have a question with my if statement. I want to get check what is bigger than another price value. one value is saved in my database table and another one is getting with input value. but I wrote …
Tag: php
Descending not working in query, but it should work? [closed]
I am making a scoreboard for my internship, for the games we play in the break. I have a really big query to get the results of all games and count the total of wins by players. SELECT winner, SUM(…
PHP and MySQL, Using a foreign key to get data from another table where it originates from
This question involves 3 tables that I have in PHPmyAdmin called: tblShoots tblMemberOnShoot tblMember I need to run a query on a users dashboard which tells them, which photoshoots they have been …
Use a boolean function to determine the results in Laravel query builder
I have shops that open at a specific time and close at a specific time and I want to filter these stores according to a time period specified by the user so that all the returned shops will be available (opened) at any moment within filtering interval The shop opens at 10 pm and closes at 2 pm, I mean
PHP – Get Average Handling Time (AHT) from mySQLi Database
I followed this to try to get the AHT from my database. So, the database structure is: _____________________________________________________________________________________ | …
#1241 – Operand should contain 1 column(s) In wamp on phpmyadmin
Nested query in Sql. SELECT *, (SELECT `supplier_sign_up_id`, ( SELECT email_address FROM supplier_sign_up WHERE …
DO while based on query result
I got a block of the code written in PHP it uses a DB connection to an Oracle DB, i need to run a query on a data and the result for the first query it should be an input of the next query and this …
Grouping database entries into dynamic HTML tables
I have a database where teams will have multiple entries each with different locations. Each entry will have a team name. So for example, team1 might appear several times but each time the location …
Search area in Jquery for searching in a grid of input from another input
I wish to search from an input (type=”text”) in a grid (like table but made in .css for be responsive so with div ans span in html) if input (type=”text”). (I precise than this grid in imported from …
MySQL INSERT inserting BIT to 1 instead of 0
I have the following query which should insert a 0 but instead inserts 1. It is executed with prepared statements in PHP: All inserts are performed fine, except a 1 is inserted in column6 instead of a 0. Column 6 has the datatype BIT. The query works fine, however, when executing directly in the phpmyadmin ‘MySQL’ tab. What am I