Posts by IronManBR • 46 points

• 1

  votes

  3

  answers

  1626

  views

  A: It is possible to collect data of the whole month in postgresql

  Only continuing the options already mentioned Option with date_trunc SELECT * FROM dados WHERE date_trunc('month', data_registro) = date_trunc('month', '2015-03-01'); In this case the parameter can…

  sql postgresql

  answered 8 years, 1 month ago IronManBR 46

• 1

  votes

  3

  answers

  707

  views

  A: MD5 password login problem

  As the colleague said, using language and bank md5 methods may be that of some difference, although I find it unlikely. I suggest you remove the MD5(...) and use this conversion before: $passwd =…

  php mysql sql login md5

  answered 8 years, 2 months ago IronManBR 46

• 0

  votes

  2

  answers

  37

  views

  A: Count Out of a Ranking

  Option 1: I will disregard that you make use of the result of your query after the loop so change it to: $query = "SELECT DISTINCT filmes FROM filmes_rec GROUP by filmes ORDER by count(filmes) DESC…

  php sql table

  answered 8 years, 2 months ago IronManBR 46

• 0

  votes

  2

  answers

  150

  views

  A: Is this kind of normalization feasible?

  Good as I can not comment, I would do everything on the same table and still make a Unique to ensure uniqueness, better maintenance, an example of my: customer{ id integer document varchar,…

  mysql sql normalization

  answered 8 years, 2 months ago IronManBR 46

• 0

  votes

  2

  answers

  818

  views

  A: Block click the menu item after the first click

  I don’t know if it solves your problem, but if tag creating a href and redirecting to a new page, but since it takes time to remove the action, could remove the "href" of tag after the click. try…

  javascript asp.net-mvc html5

  answered 8 years, 2 months ago IronManBR 46

• 0

  votes

  3

  answers

  729

  views

  A: Receive two positive numbers and repeat the interval between them with while?

  Good considering that num2 is larger than num1 the code to be able to count between them may be the following: var num1 = 3; var num2 = 14; var numero = num1; if ((num1 >=0 && num2…

  javascript while

  answered 8 years, 2 months ago IronManBR 46

• 1

  votes

  1

  answer

  39

  views

  A: Implement bookmark option on a server

  There is no way to generate a relationship between two entities without generating a new record, in the case as it is N p/N, there will always be a data to be replicated, then your decision should…

  business-rule

  answered 8 years, 3 months ago IronManBR 46

• -1

  votes

  3

  answers

  994

  views

  A: Query with connection to more than one mysql php database

  There is not much to complement, but the fact of not seeking in the right place is why it is not indicating the place to be sought, Example: $sql = '...'; // Para buscar no banco bigchamados…

  php mysql

  answered 8 years, 3 months ago IronManBR 46

• 0

  votes

  2

  answers

  2237

  views

  A: PHP insert a data array into a mysql table

  Well this is not by far the best solution, I’m only giving you a north, but the ideal would be to have value escapes to avoid SQL Injection, so this is only a reduced form. ah! I have not tested.…

  php mysql sql

  answered 8 years, 3 months ago IronManBR 46