PHP error in the COUNT(*) as num

Question

I am getting the error Notice: Use of undefined constant num - assumed 'num' my code is following

$query = "SELECT COUNT(*) AS num FROM $tableName";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

how to fix this ?

i haven't got suited title so please don't min it an of possible change it to suited

Duniyadnd · Accepted Answer · 2012-06-30 02:37:02Z

4

@AkhileshBChandran gave one correct solution. In the future, if you're referring to the column, you need to put it in quotes.

$total_pages = $total_pages['num'];

answered Jun 30, 2012 at 2:37

Duniyadnd

4,0431 gold badge24 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jake Over a year ago

Is this going to work with mysql_fetch_array? If he had used mysql_fetch_assoc I know it would work.

Michael Berkowski Over a year ago

@AkhileshBChandran mysql_fetch_array() returns both numeric and associative keys unless you specify MYSQL_NUM or MYSQL_ASSOC

Akhilesh B Chandran · Accepted Answer · 2012-06-30 02:35:29Z

1

$total_pages = $total_pages[0];

answered Jun 30, 2012 at 2:35

Akhilesh B Chandran

6,6087 gold badges33 silver badges59 bronze badges

2 Comments

Mayank K. Swami Over a year ago

it working now but would you explain it so i can understand what it the problem?

Akhilesh B Chandran Over a year ago

Since you are fetching the result as an array, the first element would contain that 'num' field. So, we are accessing the first element using the index 0 :)

Ciro · Accepted Answer · 2012-06-30 02:36:47Z

0

$total_pages = $total_pages['num'];

answered Jun 30, 2012 at 2:36

Ciro

6628 silver badges19 bronze badges

Collectives™ on Stack Overflow

PHP error in the COUNT(*) as num

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related