[vz-users] Datenbankeinträge zählen ...

[dl4huf]

ohh, ist aber empfindlich der Spam-Filter.

Ist aber kein spam sonder ein Screenshot vom phpmyadmin, wo die Abfrage 
funktioniert.
(Ich stehe nur schon auf "data" und dementsprechend bei mir
SELECT count(*) FROM 'data' where channel_id=.....

Gruß Ronald



Am 02.01.2013 21:29, schrieb dl4huf:
> Spam detection software, running on the system "oqee.de", has
> identified this incoming email as possible spam.  The original message
> has been attached to this so you can view it (if it isn't spam) or label
> similar future email.  If you have any questions, see
> @@CONTACT_ADDRESS@@ for details.
>
> Content preview:  Am 02.01.2013 21:15, schrieb W3ll Schmidt: > Hat jemand einen
>     Tip, wie ich z.B. die Einträge eines Kanals für einen > bestimmten Zeitraum
>     zählen kann ? > SELECT count(*) FROM volkszaehler.data where channel_id=8
>     AND > from_unixtime(left(timestamp,10)) like '2012_12_%'; > funzt nicht :-(
>     [...]
>
> Content analysis details:   (7.0 points, 5.0 required)
>
>   pts rule name              description
> ---- ---------------------- --------------------------------------------------
>   3.2 FH_HAS_XID             Has X-ID
>   0.0 UNPARSEABLE_RELAY      Informational: message has unparseable relay lines
>   1.3 DC_GIF_UNO_LARGO       Message contains a single large inline gif
>   2.2 SB_GIF_AND_NO_URIS     SB_GIF_AND_NO_URIS
>   0.1 DC_IMAGE_SPAM_TEXT     Possible Image-only spam with little text
>   0.1 DC_IMAGE_SPAM_HTML     Possible Image-only spam
>
> The original message was not completely plain text, and may be unsafe to
> open with some email clients; in particular, it may contain a virus,
> or confirm that your address can receive spam.  If you wish to view
> it, it may be safer to save it to a file and open it with an editor.
>