[SQL]Grabbing the number of comments

[Hidden]

Im trying to make the results look like:
Comments(84) where 84 would be how many records there is in the comments table where news_id is 1

<a href="index.php?comment=<?php echo($data['ID']) ?>">Comments(
		  <?php
		   $counta=mysql_query("SELECT count(comments) FROM comments WHERE news_id='".$data['id']."'") or die(mysql_error());
		  $query=mysql_query("SELECT count(comments) FROM comments WHERE news_id='".$data['id']."'") or die(mysql_error());
		  ?></a>)

 

[King Izu]

I don't really understand since you don't clearly state your problem.

Here's how I would do it (not really):

<a href="index.php?comment=<?php echo($data['ID']) ?>">Comments(<?php echo mysql_result(mysql_query("SELECT COUNT(*) FROM comments WHERE news_id = '{$data['id']}'"), 0, 0) ?>)

 

[Hidden]

<3 that worked just fine!
thanks

 

[foxx]

mysql_num_row

 

[King Izu]

mysql_num_row

Bad way of doing it. As you'd be retrieving data you don't need, which is inefficient.

 

[foxx]

Mk, but it would work

 

[King Izu]

Mk, but it would work

Yes it would, just in a very suboptimal way.