Is there a better way to do this?
| From: | Leif K-Brooks | Date: | Fri, 15 Mar 2002 18:41:20 +0000 |
| Subject: | Is there a better way to do this? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17701@lists.php.net to get a copy of this message | ||
I operate a small game site for kids. On this site, the players can, among
other things, buy virtual items. I have each item stored in a table called
"items" in a mysql database. The type is one column in that table, but it
is a number, not a name. When I want to display items with the item name, I
have to send a query to the item_types table to get the type name. The
problem is, if a user has 50 items, it takes 50 queries to get the types.
Is there any better way?