How to use count ()

[imtaqi]

I use the following :

<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("giftme@1-airtime", $con);

SELECT COUNT("FirstName")
FROM "person"
The output file
</body>

It is giving

Parse error: syntax error, unexpected T_STRING in /data/apache/users/kilu.de/giftme/www/lea/test.php on line 10

MOD EDIT: MySQL login credentials removed.

[laserlight]

You need to use [man]mysql_query/man to run queries using the MySQL API. Just writing them directly in the PHP code will not work.

Incidentally, I suggest using the MySQLi extension or PDO extension instead of this old MySQL extension. For one thing, they have support for prepared statements.