Best answeres tagged with mysql

1

answer

PHP PHP error Parse error: syntax error, unexpected ';', expecting ')' when doing an array foreach

I'm having trouble making an array foreach, it's displaying an error, follow the code below: <table style="width: 100%;"> <thead> <tr> <th>Item</th> <th>Código</th> <th>Produto</th> <th&...

asked by 03.07.2017 / 13:34

2

answers

PHP update with for

UPDATED I need to update a tables with input fields as below: <table style="width: 100%;"> <thead> <tr> <th>Item</th> <th>Código</th> <th>Produto</th> <...

asked by 04.07.2017 / 14:57

2

answers

Calculate difference between dates and change status

I need to create some routine to calculate the difference between two dates directly in the MySql database and change the status of another field according to that difference. The database fields are: Date Calibration, Expiration Calibrati...

asked by 22.06.2016 / 11:50

3

answers

How to store static information without using a database?

How do I store static information without using the database? For example, let's say that I have a text on a page that does not need to change frequently, and to avoid using server resources and / or to load the page faster and also with edit...

asked by 19.06.2016 / 15:40

1

answer

Generate Table with PHP group index

How can I make a Table that shows me a Line at the beginning of each Group in a table To understand me better I am putting below an image of how I need Current Table TableWithIndex <tableclass="table table-bordered table-condensed table-s...

asked by 02.11.2016 / 01:14

2

answers

Duplicate multiple Table Records at once

I'm developing a payment system for my company where there are two different types of accounts. (Eg IPVA, Pen-Drive, etc.) and Fixed (eg Electricity, Water, Telephone, Internet, etc.); I have a table where only accounts with their type = 'fix...

asked by 12.04.2017 / 21:18

1

answer

Using function within Select

I have a select, inside it I have a function: SELECT VAL1, VAL2, ".funcao('VAL1', 'VAL2')." AS soma FROM Conta WHERE soma < 100 Table structure CONTA -------------------- | ID | VAL1 | VAL2 | -------------------- | 1 | 10 |...

asked by 15.09.2016 / 05:46

3

answers

Select different values in two tables - SQL and PHP

I have two tables in the tt_order and the request_grade , what I want to do is compare the values in the " request " column of the table and the column " n_pedido " of the request_grade, basically I would like to get the values you have in th...

asked by 22.11.2017 / 17:02

1

answer

Select in two tables at the same time

asked by 07.12.2016 / 00:40

2

answers

Mysql reserved keywords

When I log in to php my admin it displays the following message The column name 'default' is a MySQL reserved keyword. for a field called default of my table My question is: can this cause any inconvenience when registe...

asked by 19.01.2016 / 17:09

Questions tagged as 'mysql'