Hiding multiple records

Rivulent

The way I have my DB set up, I have multiple records for the same type rims (and with different colors in each record, as well as product number). I want to be able to only show the main rim picture/description, and then once they click on that, choose size/color etc. I'm not sure how to make it only display the first or (preferably) a certain record. Also, maybe would it be smarter/cleaner to make another table with a "stock" photo/info page for each of the rims of it's type? It won't be updated that frequently, so the trouble of adding new data wouldn't be that bad.

Thanks in advanced!

csousley

I'm not sure I understand exactly what your looking for but to answer this:

I'm not sure how to make it only display the first or (preferably) a certain record.

To limit to the first one:
$query = "select * from table limit 1";

To get a certain record:
$query = "select * from table where something = something";

I hope this helps, if you need more, post your database info.

Good Luck

Rivulent

ok well here is the table structure

# Table structure for table `rims`
#

CREATE TABLE `rims` (
  `part_number` int(11) NOT NULL default '0',
  `name` text NOT NULL,
  `color` text NOT NULL,
  `image` text NOT NULL,
  `size` text NOT NULL,
  `offset` text NOT NULL,
  `bolt_circle` text NOT NULL,
  `weight` text NOT NULL,
  `price` int(11) NOT NULL default '0',
  UNIQUE KEY `part_number` (`part_number`)
)

I have multiple records for the same type of rims (car rims), and i want, on a main selection page, show all the rims available for the car, but not multiples of the same type of rim. Basically I want it to select only one of each with a unique field value for name, and when they click on the link, they are taken to the page with all the records with the appropriate value for the field name

Rivulent

In thinking of solutions, I have decided on a pretty stable way of fixing the problem. I will be creating another field where it is either 1 or 0. 1 if it will be displayed on the main selection page, 0 if it wont be.

nlhowell

I know there's a way to do this...

opens up handy-dandy favorites folder

Check out "SELECT DISTINCT field FROM table" and "SELECT * FROM table GROUP BY field"

Note that I haven't played around with either of these; I don't know much about how they work. SELECT DISTINCT specifies a field; it will only select one record per value of that field. GROUP BY does basically the same thing, but returns the entire record, or whatever you specify in the select. Theoretically, at least.

I also don't know anything about the support of either of these; I'm pretty sure MySQL supports GROUP BY and DISTINCT, and I'm pretty sure Microsoft databases support GROUP BY (no clue about DISTINCT).

Nick