Skip to main content
A
Anonymous
April 3, 2010
Question

Can multiple SELECT queries be used per page?

  • April 3, 2010
  • 1 reply
  • 572 views

Hello all,

New question: Can more than one SQL SELECT query be used per page? I have tried it and I'm notgetting results...if the answer is yes, does anyone know of some good resources I can check out to see what the code should look like?

As always,thanks so much!

Sincerely,

wordman

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
April 3, 2010

>Can more than one SQL SELECT query be used per page?

Of course

>I have tried it and I'm notgetting results

What exactly did you try?

>does anyone know of some good resources I can

>check out to see what the  code should look like?

Not enough information in that statement. What exactly are you trying to do? It's always helpful to provide some context.

A
Anonymous
April 3, 2010

Bregent,

Good to hear from you again!

My head was splitting last night when I wrote that so that accounts for the vagueness.

Right.

Okay, I have a SELECT query that successfully pulls data from a table based on a query string number.

I want to do another SELECT query after that to pull different records, maybe even a third SELECT query.

I tried two SELECT queries, but the second one didn't pull any data. I read a bit in David Powers' book about free_result(); and was wondering if that should be used in between each SELECT query.

I'm still getting tuned in to the SELECT, FROM, WHERE AND logic, it may be possible to do what I want with one query, right now I'm still too green to know.

Thnaks!!!

Sincerely,

wordman

A
Anonymous
April 4, 2010

Bregent,

I hate to keep doing this, but I figured it out. I am on a slow, steady roll, but please know that you all helped me get here.

Cheers and a million thank yous,

wordman

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices