[SOLVED] Need help running a mysql query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ghank
Forum Commoner
Posts: 35
Joined: Tue Apr 06, 2004 3:21 pm

Need help running a mysql query

Post 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?
User avatar
Buddha443556
Forum Regular
Posts: 873
Joined: Fri Mar 19, 2004 1:51 pm

Post by Buddha443556 »

Could you define your tables? A little more input might help? Sounds like a sql join....
ghank
Forum Commoner
Posts: 35
Joined: Tue Apr 06, 2004 3:21 pm

Post by ghank »

I figured out a work around. Thanks.
Post Reply