Hello davy_yg, I guess that you arenât a MySql table as you said but a human ( ;)) ) so try: ... About the mysql_select problem you are facing you have to share your code to give you advices. ( I am using PDO but what function is the mysql_select ? )
mysql_fetch_array() does not return an associative array, it returns a numeric indexed array. If you want to get something by it's field name i.e. return an associative array use mysql_fetch_assoc(). I would recommend using SELECT COUNT(idads) AS countidads FROM adsmgt; and then use countidads to reference it when using mysql_fetch_assoc().
If you want to show how many records (clicks) for a certain user...
//Assuming you have user id (idads) in memory already and you have it assigned to variable called $user_id...
$result = mysql_query("SELECT * FROM adsmgt WHERE idads='$user_id'");
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n";