would this...php/mysql question

liam_d · 03-14-2005, 05:00 PM

PHP Code:

  $find_replies = mysql_num_rows(mysql_query("SELECT COUNT(id) FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'")); 

????: NamePros.com http://www.namepros.com/programming/75336-would-this-php-mysql-question.html

would that set $find_replies to the amount of id's counted?

painperdu · 03-14-2005, 05:29 PM

Yes, it looks like it should count all of the id replies to topic_id.

Is this what you want. Have you tried it?

eagle12 · 03-14-2005, 09:36 PM

I don't think it does what you are looking for. That will always return a 1, because the SQL is going to return 1 row: "Count" that counts all the records where `topic_id` = '".$_GET['topic'].

You can do 1 of 2 things change the code to :

PHP Code:

   $find_replies = mysql_num_rows(mysql_query("SELECT * FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'"));

or

PHP Code:

  $row = mysql_fetch_row(mysql_query("SELECT COUNT(id) FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'")); 

????: NamePros.com http://www.namepros.com/showthread.php?t=75336
$find_replies = $row[0];

cerebus · 03-14-2005, 10:58 PM

PHP Code:

  $find_replies=mysql_result(mysql_query("SELECT COUNT(id) FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'"),0); 

????: NamePros.com http://www.namepros.com/showthread.php?t=75336

should do the trick as well.

liam_d · 03-15-2005, 07:10 AM

i have done this and it works fine now;

PHP Code:

  $count_replies = mysql_fetch_array(mysql_query("SELECT COUNT(id) AS `count` FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'")); 

????: NamePros.com http://www.namepros.com/showthread.php?t=75336

03-14-2005, 05:00 PM	THREAD STARTER #1 (permalink)
liam_d The original NP Emo Kid Join Date: Jan 2005 Location: Plymouth, UK Posts: 1,693 Follow @upurtweet	would this...php/mysql question PHP Code: $find_replies = mysql_num_rows(mysql_query("SELECT COUNT(id) FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'")); ????: NamePros.com http://www.namepros.com/programming/75336-would-this-php-mysql-question.html would that set $find_replies to the amount of id's counted? __________________ Gaming On Linux - Because Linux is Fun!

03-14-2005, 05:29 PM	#2 (permalink)
painperdu NamePros Regular Join Date: Jun 2003 Location: Louisiana, USA Posts: 658	Yes, it looks like it should count all of the id replies to topic_id. Is this what you want. Have you tried it? __________________ dotbob.com -Cheap Domain Name Registrations/Unlimited Web Hosting Plan $5.98/month

03-14-2005, 09:36 PM	#3 (permalink)
eagle12 NamePros Member Join Date: Nov 2003 Location: Ontario, Canada Posts: 127	I don't think it does what you are looking for. That will always return a 1, because the SQL is going to return 1 row: "Count" that counts all the records where `topic_id` = '".$_GET['topic']. You can do 1 of 2 things change the code to : PHP Code: $find_replies = mysql_num_rows(mysql_query("SELECT * FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'")); or PHP Code: $row = mysql_fetch_row(mysql_query("SELECT COUNT(id) FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'")); ????: NamePros.com http://www.namepros.com/showthread.php?t=75336 $find_replies = $row[0];

03-14-2005, 10:58 PM	#4 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395	PHP Code: $find_replies=mysql_result(mysql_query("SELECT COUNT(id) FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'"),0); ????: NamePros.com http://www.namepros.com/showthread.php?t=75336 should do the trick as well.

03-15-2005, 07:10 AM	THREAD STARTER #5 (permalink)
liam_d The original NP Emo Kid Join Date: Jan 2005 Location: Plymouth, UK Posts: 1,693 Follow @upurtweet	i have done this and it works fine now; PHP Code: $count_replies = mysql_fetch_array(mysql_query("SELECT COUNT(id) AS `count` FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'")); ????: NamePros.com http://www.namepros.com/showthread.php?t=75336 __________________ Gaming On Linux - Because Linux is Fun!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
little question..	khkhan	Domain Appraisals	2	11-20-2004 05:28 AM
two-letter .com domain question	questioning	Domain Name Discussion	1	10-05-2004 05:08 PM
Simple PHP/MySQL question	dcmginc	Programming	8	10-02-2004 04:34 AM
PHP/MySQL question	QBert	Programming	1	10-01-2004 04:22 AM
OScommerce Loaded question	geoffd3	Programming	1	03-01-2004 08:35 AM