Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- problem with mysql fetch array


Malmo - 9:48 am on Jul 27, 2010 (gmt 0)


The thing I want to create is that it shows how many times a news article has been commented.
Here is an example of what I am trying to make: the bolded text is what numbers are shown if I run the code above

News article 1
short text 1
comments (5)(5)

News article 2
short text 2
comments (2) (2)

News article 3
short text 3
comments (0)(5)

News article 4
short text 4
comments (5)

the goal is that a zero is added if no comments have been made. The fields that I connect from the tables are id from the table novice and novicaID from novice_komentarji. Hopefully I have made it clearer what I want to achieve.

Best regards.


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4175730.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com