Posts by maraguida • 64 points

• 3

  votes

  1

  answer

  51

  views

  A: Repeat id query most times

  Just a select with a totalizing function select userid, count(*) from visitas group by userid order by 2 desc To order use a order by, so the data appears with the most visited users first.…

  php sql

  answered 8 years, 7 months ago maraguida 64

• 1

  votes

  3

  answers

  35

  views

  A: Delete Line with email

  Explode the text area on different lines. Traverse the resulting array by printing only lines that have no email $linhas = explode("\n", $textarea); foreach ($linhas as $linha) { // teste básico…

  php

  answered 8 years, 7 months ago maraguida 64