PHP / MYSQL / RESULTS

Anon

Hi there!

How can I do the following:

I have a mysql database with 1090 snowboards.
I have a search page where users can select different search terms etc weight, lenght, prize, ... Then my problem. After pressing submit button i would like to receive page with only board manufacter(etc Burton), model (charger), and lenght (161). Then when user clicks properiate board a new page will open with more details on. for example

Board | Burton | p |
----------------------- i |
Model | Charger | c |
----------------------- t |
Lenght | 161 cm | u |
----------------------- r |

etc | etc | e |

How can i do this?

Anon

Table should be like this;

Board |Burton | p |
---------------| i |
Model |Charger| c |
---------------| t |
Lenght | 161 cm| u |
---------------| r |

etc | etc | e |

Anon

Simpel:
I assume you have an auto_increment column like "ID"
in your table, so you can identify records by their ID.
If you don't, alter your table so it does.

When you print the boards that match the search,
print a link to a new php script and pass the ID to the new script through the link.

In the new script, use the ID to find the correct record and display the data.