[SOLVED] how do you count the number of rows with id=1 ?

[Sincere]

hello

 

update pafiledb_cat set files_nb = (select file_catid from pafiledb_files WHERE pafiledb_files.file_catid=cat_id)

 

did not work.

 

how do you find out the number of rows in a table with cat_id=n ???

[mwasif]

This will return number of rows from a table against a specific category.

SELECT COUNT(*) FROM table_name WHERE cat_id=n

Replace table_name with your actual table name and n with category id.

[Sincere]

This will return number of rows from a table against a specific category.

SELECT COUNT(*) FROM table_name WHERE cat_id=n

Replace table_name with your actual table name and n with category id.

 

 

shukraaaaaaaaaaaaaaan

 

thank you thank you thank you

 

 

[mwasif]

Jazeeran