need mysql help

Coreycyberdesig · 06-20-2006, 06:14 AM

Hello I am writeing a forum and for soem reason my mind has taken a dump and i cant figure out the query

I have a signle table that has the following cols
thread_type_id thread_name poster post Date_posted thread_order thread_id
and a key

I need to figure out based on the thread type id
how many posts there has been for that thread type id minus the ones that are marked first
How mnay are marked first
and when the last post was made for that thread type id

Could anyone help me out with this

lpxxfaintxx · 06-20-2006, 07:07 AM

Sorry, I do not understand what you are trying to say...

Peter · 06-20-2006, 10:23 AM

better off giving us the proper layout of the tables as well as an exact description of what you need to retrieve.

Coreycyberdesig · 06-22-2006, 03:28 PM

I just needed to find out some information it was basicly a complex count statment I got pissed and rewrote it in ajax and it works so yea its done

stscac · 06-22-2006, 04:26 PM

Rewrote it in Ajax?

Ajax opposed to what, traditional?

-Steve

Prch · 06-23-2006, 03:22 PM

Originally Posted by Coreycyberdesig

I have a signle table that has the following cols
thread_type_id thread_name poster post Date_posted thread_order thread_id
and a key

Originally Posted by Coreycyberdesig

I need to figure out based on the thread type id
how many posts there has been for that thread type id minus the ones that are marked first

Code:

SELECT COUNT(the_key) FROM `your_single_table` 
WHERE thread_type_id = 'variable_for_that_thread_type_id' 
AND what_field_was_that != 'first'

Originally Posted by Coreycyberdesig

How mnay are marked first

Code:

SELECT COUNT(the_key) FROM `your_single_table`
WHERE what_field_was_that = 'first'

Originally Posted by Coreycyberdesig

and when the last post was made for that thread type id

Code:

SELECT MAX(Date_posted) FROM `your_single_table` 
WHERE thread_type_id = 'variable_for_that_thread_type_id'

There's not enough details or table illustration provided. You might want to merge these queries.

Coreycyberdesig · 06-25-2006, 03:46 AM

Thanks i rewrote it in ajax and did the whole thing with an function

06-20-2006, 06:14 AM	THREAD STARTER #1 (permalink)
Coreycyberdesig NamePros Member Join Date: May 2006 Posts: 39	need mysql help Hello I am writeing a forum and for soem reason my mind has taken a dump and i cant figure out the query I have a signle table that has the following cols thread_type_id thread_name poster post Date_posted thread_order thread_id and a key I need to figure out based on the thread type id how many posts there has been for that thread type id minus the ones that are marked first How mnay are marked first and when the last post was made for that thread type id Could anyone help me out with this Last edited by Coreycyberdesig; 06-20-2006 at 06:33 AM.

06-20-2006, 07:07 AM	#2 (permalink)
lpxxfaintxx Senior Member Join Date: May 2006 Location: Irvine, CA Posts: 1,082	Sorry, I do not understand what you are trying to say... __________________ han(sup) yoon - internet entrepreneur

06-22-2006, 03:28 PM	THREAD STARTER #4 (permalink)
Coreycyberdesig NamePros Member Join Date: May 2006 Posts: 39	LOL its cool got it I just needed to find out some information it was basicly a complex count statment I got pissed and rewrote it in ajax and it works so yea its done

06-25-2006, 03:46 AM	THREAD STARTER #7 (permalink)
Coreycyberdesig NamePros Member Join Date: May 2006 Posts: 39	php Thanks i rewrote it in ajax and did the whole thing with an function

06-20-2006, 10:23 AM	#3 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	better off giving us the proper layout of the tables as well as an exact description of what you need to retrieve.

06-22-2006, 04:26 PM	#5 (permalink)
stscac A Wealth of Knowledge Join Date: Aug 2004 Posts: 3,809	Rewrote it in Ajax? Ajax opposed to what, traditional? -Steve

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

need mysql help

LOL its cool got it

php