Page 1 of 1

Need help running a mysql query

Posted: Mon Jun 14, 2004 8:02 pm
by ghank
I have a way to do this, but it's probably not the right way. I have a mysql table with about 6k rows of info. Each row is the info for my dynamic php page. I also have another table with 50 rows. Each row contains a large paragraph. So what I want is my 6k pages to pull any paragraph from the 50 row table. A random query works fine. But what I really want is the page to pull the same paragraph every time. So I can make another 6k row table with the 50 rows that repeat and query from the ID. But that table is huge. Just trying to explain this is confusing me... Anybody have an idea of what to do on this one?

Posted: Tue Jun 15, 2004 10:05 am
by Buddha443556
Could you define your tables? A little more input might help? Sounds like a sql join....

Posted: Tue Jun 15, 2004 11:06 am
by ghank
I figured out a work around. Thanks.