Questions tagged as 'select'

Tagged questions
3
answers

SQL searching for records from a Date and Time

I have the following SQL: select * from tb_valores where DATA >= '14/12/17' and HORA >= '16:34:00') I would like to bring all records from that date and time. The problem is that if I have records like: '14/12/17' '10:20:00' '14/...
asked by 15.12.2017 / 20:20
1
answer

Select with a return of several values from several columns

Greetings! This is my first post, I hope I can be helped and I can also help a lot on this journey with you! So some formatting error I just ask for patience until the standards here are adequate! Well, my first problem is being in creating a...
asked by 25.11.2017 / 17:16
1
answer

Query between Mysql dates showing every day of the range

Hello, I would like help with logic. I have an ecommerce system in which N products are sold and I am comparing the sales of a certain product per period of time, ie the admin will have an area in which he chooses a product and a date range (...
asked by 27.04.2018 / 03:37
1
answer

Select to return JSON [closed]

Hello! I have the following code in PHP: login.php <?php $msg; if (isset($_POST['login']) && isset($_POST['senha'])) { $login = str_replace(" ", "", $_POST['login']); $senha = str_replace(" ", "", $_POST[...
asked by 14.06.2017 / 14:24
1
answer

Problem to select a specific object within a hash

Hello! Good Morning. I have the following situation: In my Ruby code, there is a flower class (attributes: code (generated by a function with auto increment), name , and category (this attribute also represents the hash key)). Each inst...
asked by 20.03.2017 / 15:02
2
answers

Change select (ajax + php) element value with innerHTML

Hello, I'm doing the famous combo of state charges city. Everything is working perfectly, as I debugged in my script, until the moment it should change the value of select (options returned from the function). Here is my code (index.php): <...
asked by 17.02.2017 / 20:59
1
answer

ecommerce promotion consultation

I am developing an ecommerce platform, and I came across a problem to calculate the value of the products by applying discount on the SQL query, are being applied in PHP, but when I order sort by value, it sorts without taking into account t...
asked by 20.07.2016 / 16:36
0
answers

Select from a table inside a cell of another table [closed]

Can not you% construct a table that contains one result of another table in one of its columns? The master key would be the reference.     
asked by 01.02.2016 / 20:27
3
answers

2 COUNT within a SELECT with LEFT JOIN

I have two tables: Users: id | nome | email submissions: id | id_envia | id_recebe Every time a user sends a card (which goes by email) to another user, it marks this table, and every time it receives a tag as well. Doubt: I...
asked by 09.03.2016 / 20:52
1
answer

Select cities and states on the site [closed]

I'm setting up a site , and on the home page I've created a select for states and cities, the problem is that the homepage site is crashing very. Does anyone know how I can do this select without crashing the site ? Or maybe...
asked by 22.06.2015 / 18:53