Count is not working

Dev Shed Forums Sponsor:

May 15th, 2012, 04:30 PM

timsharpe

Contributing User

Join Date: Apr 2001

Posts: 909

Time spent in forums: 5 Days 5 h 34 m 32 sec
Reputation Power: 0

Count is not working

I am using the code below I want a count beside each link but when I use it only 1 record link shows, why I do not use the count all links show why?

PHP Code:


		
			
while ($row = mysql_fetch_array($result))

        {

extract($row);

$result = mysql_query("SELECT * FROM answers WHERE qid ='qid'");

$num_rows = mysql_num_rows($result);





print "<a href=\"?tab=View Question&qid=$qid\">$question</a> - Votes: $num_rows<br>"; 





}

__________________
Daily Deals from Kingston to Brockville and Cornwall Ontario. www.seawaydeals.com

May 15th, 2012, 05:35 PM

Catacaustic

Code Monkey V. 0.9

Dev Shed Intermediate (1500 - 1999 posts)

Join Date: Mar 2005

Location: A Land Down Under

Posts: 1,886

Time spent in forums: 2 Weeks 4 Days 15 h 12 m 20 sec
Reputation Power: 1798

Just wondering if it's not supposed to be this (I think you've left the $ off the $qid variable in your query)?

PHP Code:


		
			
 $result = mysql_query("SELECT * FROM answers WHERE qid ='$qid'");

If your query is right, look at how many answers have the value for qid set as 'qid' and you'll find how many answers there are for that question.

May 15th, 2012, 05:43 PM

timsharpe

Contributing User

Join Date: Apr 2001

Posts: 909

Time spent in forums: 5 Days 5 h 34 m 32 sec
Reputation Power: 0

Yes I fixed that but it still does not work

May 15th, 2012, 05:52 PM

Catacaustic

Code Monkey V. 0.9

Join Date: Mar 2005

Location: A Land Down Under

Posts: 1,886

Time spent in forums: 2 Weeks 4 Days 15 h 12 m 20 sec
Reputation Power: 1798

Then echo out the query, and run that directly against your DB, using something like phpMyAdmin or whatever other DB management tool you have.

PHP Code:


		
			
 $query = "SELECT * FROM answers WHERE qid ='$qid'";

echo "<p>".$query."</p>";

 $result = mysql_query($query);

That will tell you the results from that query. The most likely cause of this is that there is only one answer in your DB for that question ID.

May 16th, 2012, 03:41 AM

sypack

Registered User

Join Date: May 2012

Posts: 2

Time spent in forums: 20 m
Reputation Power: 0

Try using back tick around the table name.

May 16th, 2012, 04:04 AM

cafelatte

Contributing User

Join Date: Mar 2008

Posts: 1,923

Time spent in forums: 1 Month 5 Days 16 h 21 m 8 sec
Reputation Power: 377

What does the query that builds the first result look like?

And can you provide a SHOW CREATE TABLE for each of the relevant tables?

May 16th, 2012, 04:56 AM

badger_fruit

Confused badger

Join Date: Mar 2009

Location: West Yorkshire

Posts: 760

Time spent in forums: 1 Week 4 Days 5 h 15 m 18 sec
Reputation Power: 339

You're using $result twice and I suspect that's the reason.

PHP Code:


		
			
while ($row = mysql_fetch_array($result))    <--- HERE

        {

extract($row);

$result = mysql_query("SELECT * FROM answers WHERE qid ='qid'");

$num_rows = mysql_num_rows($result); <---- HERE





print "<a href=\"?tab=View Question&qid=$qid\">$question</a> - Votes: $num_rows<br>"; 

}

I recommend calling the 2nd $result something else such as $sub_result or $whatever_you_want_to_call_it_just_as_long_as_its_not_called_result

Count is not working

Developer Shed Advertisers and Affiliates