connect to database - Joomla! Forum - community, help and support
hi,
i want total of numbers filled in application form, in database fall under column (element_value), in condition match column (form_id = 23) , column (element_label = 35).
i wrote follow, still not working.
what wrong?
<!doctype html>
<html>
<body>
<?php
$host_name = "myhostname";
$database = "mydatabase";
$user_name = "myusername";
$password = "mypasspword";
$sql = “select sum(element_value) dxthm_formmaker_submits (form_id=23 . (element_label=35))”;
?>
</body>
</html>
the result, want publish joomla custom module, position 12, template beez_20
thanks!
i want total of numbers filled in application form, in database fall under column (element_value), in condition match column (form_id = 23) , column (element_label = 35).
i wrote follow, still not working.
what wrong?
<!doctype html>
<html>
<body>
<?php
$host_name = "myhostname";
$database = "mydatabase";
$user_name = "myusername";
$password = "mypasspword";
$sql = “select sum(element_value) dxthm_formmaker_submits (form_id=23 . (element_label=35))”;
?>
</body>
</html>
the result, want publish joomla custom module, position 12, template beez_20
thanks!
Comments
Post a Comment