Count SQL query PHP

Question

I want to count for each gallery number of images in it, here's my query:

$req = db_query("SELECT count(*) FROM node,node_file WHERE node.nid = node_file.nid AND nid = ".$value['nid']);

here's the two tables :
node_file:

nid  |fid   |
-------------
  1  |  1   | 
-------------
  1  |  2   |  
-------------
  1  |  3   |
-------------
  2  |  1   |
-------------
  2  |  2   |
-------------
  2  |  3   |

node:

 nid |type  |
-------------
  1  |Gallery1| 
-------------
  2  |gallery2|

The error : Query : SELECT count(*) FROM node,node_file WHERE node.nid = node_file.nid AND nid = 34 Message : SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'nid' in where clause is ambiguous

Thanks!

Abdul Manaf · Accepted Answer · 2014-03-11 11:56:43Z

4

Both of your tables have column nid and you are using column in AND clause so you need to specify to which table it belongs.

SELECT 
    count(*)
FROM
    node,
    node_file
WHERE
    node.nid = node_file.nid AND node.nid = 34

OR

SELECT 
    count(*)
FROM
    node,
    node_file
WHERE
    node.nid = node_file.nid AND node_file.nid = 34

answered Mar 11, 2014 at 11:56

Abdul Manaf

4,8883 gold badges29 silver badges34 bronze badges

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

Comments

Ananth · Accepted Answer · 2014-03-11 11:57:06Z

2

use this

$req = db_query("SELECT count(*) FROM node,node_file WHERE node.nid = node_file.nid AND node.nid = ".$value['nid']);

answered Mar 11, 2014 at 11:57

Ananth

1,5823 gold badges17 silver badges36 bronze badges

Collectives™ on Stack Overflow

Count SQL query PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related