I have 3 tables in MYSQL.
Account:
id nome
1 caio
2 zé
3 marcelo
Followers (the account id, that is, the user has 2 followers):
idqual
1
1
2
2
2
3
Products (the account id, that is, the user caio has 3 products):
idqual
1...
I have a question about the advantages of having standard tables and how to use them within a SELECT.
Let's suppose the following tables:
--------------
| tb_endereco |
--------------
| id |
| rua |
| numero |
| ba...
I'm cracking my head to try to get the select from my site to agree with my css. In fact, only in Mozilla that the saying whose does not look the desired.
I was looking for some jQuery to do editing these elements, but the problem is that on...
Good morning I need to bring only one product per branch, however in my table I have several times the same product just changing the date, I would like to get the product from the last date.
What I have:
SELECT ID, CODFIL, DT, COLUNAVARI...
I need to value the inventory of the company in which I work and for this I will get the last value of the items. I was using MAX , but I realized that if I did this, it would return me the highest price and not the last one registered in...
I think it's a simple question, but because I do not know 50% of Zend I'm breaking my head, so here it goes:
$sql = $db->select()
->distinct()
->from(array('cli' => 'fc_cblcli'),array('codigo','tipo','nome'))
->join...
Is it possible to know which last row was inserted into a MySql table where the primary key is not sequential?
I have a table where the primary key is made up of two columns that are FK, so they do not follow a sequence.
When executed the...
I fed this chart
ButIhaveaprobleminselectingit<?php$sql_2_vis=mysqli_query($config,"SELECT data, uniques, pageviews FROM tb_visitas ORDER BY id DESC LIMIT 7") or die(mysqli_error($config));
if(@mysqli_num_rows($sql_2_vis) <= '0'){...