I want get category name and no of products inside each of...

lse123 · #1 (**permalink**) 11-10-10, 02:37

is this query correct

Code:

SELECT Products.count(*), Categories.Category FROM Products GROUP BY Category_ID INNER JOIN Categories ON Categories.Category_ID = Products.Category_ID

count(*) of products === number of products in each Category
I want get category name and no of products inside each of...

r937 · #2 (**permalink**) 11-10-10, 05:13

Quote:

Originally Posted by lse123

is this query correct

what happened when you tested it?

lse123 · #3 (**permalink**) 11-10-10, 05:21

null ... error pupulate arrays...js population ..I want to populate php arrays and there after javascript arrays with the two fields...

r937 · #4 (**permalink**) 11-10-10, 05:39

Quote:

Originally Posted by lse123

null ...

here's a hint: the query contains a syntax error, and running the query outside of php, directly in the mysql engine, will produce an appropriate error message which will help you fnd the source of the problem

that's what i meant by testing it

you want to test the query itself, and not the application logic to build an array or whatever

healdem · #5 (**permalink**) 11-10-10, 07:31

mind you you should have got soe sort of error message from the PHP/MYSQL interface
did you examine the MySQL_Err & MySQLErrNo?
Google

Internet Services

Web Development

Digital Marketing

Consumer Tech