Table: socialstats

Tool: Social Marketing
Associated Objects: SocialStats, SocialStat

Fields

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM socialstats");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $added = $resRow["added"];  //
 $member = $resRow["member"];  //
 $ttype = $resRow["ttype"];  //
 $ttypeid = $resRow["ttypeid"];  //
 $ctype = $resRow["ctype"];  //
 $ctypeid = $resRow["ctypeid"];  //
 $likes = $resRow["likes"];  //
 $comments = $resRow["comments"];  //
 $clicks = $resRow["clicks"];  //
 $shares = $resRow["shares"];  //
 $socialid = $resRow["socialid"];  //
 $updated = $resRow["updated"];  //
}

Other Social Marketing Tables

facebookvideo     googlecalendar     socialapisettings     socialconnect     socialconnections     socialcontacts     socialcontent     socialcontentassign     socialcontenttypes     socialprofiles     socialprofiletypes     socialprofilevars     socialque     socialsettings     socialsites     socialstats     socialvars     socialvartemplates     socialvartemplatevars