SELECT COUNT(*) as value [not working]

interface

[COLOR=DarkGreen]SELECT COUNT([COLOR=Black]*[/COLOR]) as value FROM table_name[/COLOR]

The above line produces an error...
I tried different ways of getting the same result, but it never works ):

The thing is, I'm trying to make a paging script with MS Access and (ofcourse) PHP. Resources for this are stunningly hard to find on Google or PHP forums. I do not know why. Is it so hard or just not possible? I think it is, the only script I found didn't work.

But if I change the word value to something else, e.g. test it suddenly doesn't produce an error. BUT... when I call for that value (e.g. $row->test in stead of $row->value) the value $row->test is empty. But no errors occur anymore.

Any ideas how to get this script working for me in the first place so I could learn from it and write my own (: (I don't like copy/paste)

Once again, I use:

MS Access
PHP 5

Sincerely,

interface

[edit]
Yes, I replaced * with table data names (e.g. ID, title, genre, info etc)
[/edit]

coreyp_1

First of all, VALUE is a MySQL reserved word, which is probably why you get an error when you try to use it as an alias.

Secondly, I assume you are using mysql_fetch_array() to retrieve your results. The variable should then be accessed as $row['test'] (or whatever alias you decide to use).

Hope this helps!

nemonoman

In other words:

$result=mysql_query("SELECT  COUNT(*) as 'value' FROM table_name");
$row=mysql_fetch_array($result);
$value=$row[0]; // or $row['value']

toxic_brain

or try using print_r($row)

interface

Great, thanks for the help, but I explicitly wrote that I use an MS Access database (*.mdb), which ofcourse doesn't use mysql() ...

$con = odbc_connect('database', 'username', 'password')
$sql = "SELECT count(*) as value FROM table_name";

while ($row = odbc_fetch_object($con, $sql)) {
    print $row->value
}

That's the one I use (could be erroneus since I don't have it here with me 🙂