I would like to count and display on my front page how many people have signed a civi petition. This I have been able to do using php as below. What I am wondering is if I am causing any kind of insecurity in my system - if I can get the data out what is to stop someone else inserting data in?
Sorry this may be a 101 question but I haven't been able to find this out by searching. Thanks! Caroline
open php $sql=("SELECT COUNT(*) FROM civicrm_activity WHERE activity_type_id=32"); $rs = mysql_query($sql); $result = mysql_fetch_array($rs); echo "<h1> <b><center>SIGNATURES SO FAR: $result</center></b> </h1> "; close php