Questions tagged as 'mysql'

Tagged questions
1
answer

Track store inventory

I'm in a virtual store project and I have a question about the stock control process. Initially I'm doing everything in the product table where I have two fields: manage_stock and stock . Manage Stock will control whether...
asked by 29.05.2016 / 16:39
2
answers

Syntax error when using UNION [closed]

Error: /* Erro SQL (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM pedido a, tipofornecimento b ' a...
asked by 26.10.2015 / 18:32
1
answer

Help to send data from PHP to DB

I'm new to the programming area and would like some help I set up a page to insert dates into 4 fields and I need those dates to be stored in DB And I kind of do not know and I'm having trouble riding ... can anyone help me? Another thing I n...
asked by 06.11.2015 / 20:20
1
answer

Link counter - no external page using JS onClick () or another solution in PHP + MySql [closed]

Hello, I'm looking for help to set up a link counter. I would not like to use a page that collects, but rather a solution that runs on any page. Example on a page with 03 links: link01.php, link02.php (which was clicked) and link03.php, now that...
asked by 26.10.2015 / 02:36
1
answer

select block block lines from a range of 10 in 10 by looping in the query? [duplicate]

I have a table of 500 thousand precise lines of this 500 thousand lines only of 1000 in 1000 for example select * from table limit 1000 offset 0; the range would be to stop at 1000 and then make another select starting from 1001 to 2000 for ex...
asked by 02.03.2016 / 19:12
1
answer

Delete table data without reloading page to update

I have a table with data of a certain equipment, above the table has a field where the number of the equipment is inserted and quantity, the other information comes from the bank through the equipment number. In the last column of each table the...
asked by 29.05.2018 / 18:57
1
answer

Logic formulation for problem solving

I have two tables, table A with id and tasks (description), and another table B with the task fk, quantity, fk, and official. In addition to other columns that is not the case. In my table in the html (table), I show all the tasks already in...
asked by 01.06.2018 / 17:59
1
answer

SELECT with multiple tables returns only one project

I'm doing a project management system, in the HOME page will appear all projects. In mySQL I have in the PROJECTS table the client and project manager saved as User ID and Client ... that has their data in other tables CLIENTS and USERS. I'm doi...
asked by 25.05.2018 / 20:13
2
answers

Difficulties in making select

I'd like some help on how to solve the last 3 selects below. Rememberingthatthereportsthatcontaintheitem"Total quantity" require the total quantity of the product taking into account all the requests made. SELECT pedido.horario_pedido AS h...
asked by 19.12.2017 / 21:44
1
answer

I need to manage a text field with separate values; [duplicate]

I need to insert, edit, delete a field of type text in this format: 11 2222-3333;11 3333-4444;11 5555-6666;11 7777-8888 In case you need a zebra grid that lists the data and in each row have this information in this format: Insert te...
asked by 13.06.2014 / 04:34