I need to generate all word combinations of a varchar of a record from a database.
I need to develop in MySQL in PostgreSQL
To get simpler:
BASE DATA TABLE
Howtomakeaprocedure/functionthatselecttherecordsanddot...
Good people,
I would like to know what approach they would take to make a union only if the above query, from the union, returns values.
Consider that the tables are compatible
EX:
SELECT * FROM Tabela1
UNION
SELECT * FROM Tabela2
/*Esta q...
I'm using Zend and I have the following function:
public function getChamado($id) {
try {
$cols = array(
'id', 'titulo', 'descricao', 'fk_status', 'fk_local',
'fk_tipo', 'created', 'modified', 'finished', 'fk_usuario',...
I need to create a table that contains days and times of operation of an establishment, a sort of agenda. This table should represent every day of the week and each day contain the opening and closing times. The challenge is to create this table...
Good afternoon, friends, I'm having a problem, I can not register all the users in the database, just register the last one, how can I solve this problem?
Index<formmethod="post" action="salvar.php">
Name
CPF
...
In a MySQL database table, I have a new user registry, the primary key of the table being an ID field. However, I may end up creating, even by accident, users with the same username.
For example, "joao.silva" can be registered for users named...
I am doing stock control system, and I would like to know the advantages and disadvantages between two ways of implementation to do the subtraction of the number in the stock after a sale / exit.
1) Do a% direct update in the application t...
I have a value in the mysql database that contains some html commands like:
<b>Olá</b>
<br>
Other ...
I need to display the value using <?php echo $row_rs['original']; ?> to ap...
I would like to make sure that after the script runs, there may only be the last 12 records in a specific table that has the date field in international format if you can assist.
<?php
# Este pequeno script PHP recupera o OD do imóvel visi...
I have the tbl_galeria table, what happens is that I want to make a query, but the query can not show the first result. That is, the query will return all values except the one with the smaller id.
$query = mysql_query("SELECT * FROM tb...