PDA

View Full Version : multiple queries on table + how to reduce?


student101
10-08-2008, 06:15 PM
I have a page with an included_page which needs multiple queries.
So the layout would be;Heading

record 1
record 2Next Heading and so on...
This is the query;If I need 15 then I need 15 recordsets (not cool)
$rsquery = SELECT id, dtedate, heading, txtchoice FROM table WHERE txtchoice = {whatever the choice may be, ie; summer, winter, autumn or spring}

What would be the best way to work this idea with the least amount of code?

Cheers

davidj
10-08-2008, 06:41 PM
one query structure in a function

loop the function call 15 times dropping the result into a array

student101
10-08-2008, 10:22 PM
On functions I have no clue;
I would have to drop the same query x amount of times, not saying I don't want to learn these functions - except it seems bigger than me.

Cheers

davidj
10-08-2008, 10:24 PM
contact me

messenger

student101
10-09-2008, 09:05 AM
did that yesterday.

davidj
10-09-2008, 03:56 PM
didnt

not on messenger

student101
10-10-2008, 10:03 AM
I sent to your email address on nirvana[at]msn
Sent on; 08 October 2008 09:45:41 PM
Sent on; 10 October 2008 08:59:50 AM

Cheers

davidj
10-10-2008, 01:13 PM
yes you sent me an email

i need to chat about this on messenger (chat client)

domedia
10-10-2008, 03:05 PM
Messenger is also an email client. You might want to specify MSN Messenger to prevent any confusion :)

student101
10-10-2008, 05:07 PM
yes you sent me an email
i need to chat about this on messenger (chat client)
Yes you are always Offline, I don't keep MSN open, it chows resources.

Which chat client do you use?

MSN messenger
Skype
Yahoo messenger
Google talk

davidj
10-10-2008, 06:51 PM
Messenger is also an email client. You might want to specify MSN Messenger to prevent any confusion :)

sorry never heard of messenger email client before

can you send me a link to this client?

davidj
10-10-2008, 06:58 PM
Yes you are always Offline, I don't keep MSN open, it chows resources.

err unless you have one of those machines which fred flintstone used then yes it could slow your machine down and i respect that reason.
If the reason is that you choose not to run it all the time out of choice then i respect that too.

if your using a half decent machine and your running universe expansion simulation math then i also respect that.

every thing else is bollocks!

davidj
10-10-2008, 07:26 PM
Messenger is also an email client. You might want to specify MSN Messenger to prevent any confusion :)

i am using MSN MESSENGER

to avoid confusion its...

The MicroSoft Network Messenger Client

clue:

http://images.google.co.uk/images?hl=en&q=msn%20messenger&um=1&ie=UTF-8&sa=N&tab=wi

edbr
10-11-2008, 02:22 AM
my my, this is going well so far :)

student101
10-11-2008, 07:19 AM
If the reason is that you choose not to run it all the time out of choice then i respect that too.
I run this;


Intel Celeron 1.60GHz Dual Core - CPU @ 20 - 25%
1GB Ram - Ram @ 20 - 35%
1 Terrabyte drive
GeForce 8600GTS OverclockerI prefer to keep my memory and cpu down by 80%, that way when I open anything "it works"

Cheers

davidj
10-11-2008, 11:01 AM
I run this;
I prefer to keep my memory and cpu down by 80%, that way when I open anything "it works"

Cheers

i give up!

davidj
10-11-2008, 11:03 AM
my my, this is going well so far :)

I tried my best