would this...php/mysql question

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

PHP Code:

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

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

painperdu · 03-14-2005, 04: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, 08: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']."'")); 

$find_replies = $row[0];

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

PHP Code:

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

should do the trick as well.

liam_d · 03-15-2005, 06: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']."'"));

03-14-2005, 04:00 PM	#1 (permalink)
liam_d The original NP Emo Kid Join Date: Jan 2005 Location: Plymouth, UK Posts: 1,648 0.00 NP$ (Donate)	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']."'")); would that set $find_replies to the amount of id's counted?

03-14-2005, 04:29 PM	#2 (permalink)
painperdu NamePros Regular Join Date: Jun 2003 Location: Louisiana, USA Posts: 665 33.75 NP$ (Donate)	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** -Dotbob.com

03-14-2005, 08:36 PM	#3 (permalink)
eagle12 NamePros Member Join Date: Nov 2003 Location: Ontario, Canada Posts: 91 80.80 NP$ (Donate)	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']."'")); $find_replies = $row[0];

03-14-2005, 09:58 PM	#4 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395 655.10 NP$ (Donate)	PHP Code: $find_replies=mysql_result(mysql_query("SELECT COUNT(id) FROM `forum_replies` WHERE `topic_id` = '".$_GET['topic']."'"),0); should do the trick as well.

03-15-2005, 06:10 AM	#5 (permalink)
liam_d The original NP Emo Kid Join Date: Jan 2005 Location: Plymouth, UK Posts: 1,648 0.00 NP$ (Donate)	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']."'"));

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 04:28 AM
two-letter .com domain question	questioning	Domain Name Discussion	1	10-05-2004 04:08 PM
Simple PHP/MySQL question	dcmginc	Programming	8	10-02-2004 03:34 AM
PHP/MySQL question	QBert	Programming	1	10-01-2004 03:22 AM
OScommerce Loaded question	geoffd3	Programming	1	03-01-2004 07:35 AM