Pulling info from an access database-Newbie Q

[Hoju_ca]

Hope someone can help here. I'm hoping it's a simple solution that I just can't find anywhere.
I've built a database using Access containing (right now) 3 columns (part_number, part_description, part_price).

I'm pulling the data from the db and inserting it into a web page.
What I can't figure out is how to select a specific part_number (which is the primary key) from the DB and insert it. Doing a couple of tutorials I've learned how to print the entire DB (using loops) and can print the first line but I can't figure out how to skip rows up and down. I've been using the odbc_result command but cannot figure out how to set the result id to a new row/primary key. Help, what do I need to do?

🙁

[jpmoriarty]

easiest way would be to restrict the recordset in the sql that you run on it:

select * from table where id="value"

that way you only get given the one value, and you dont have to worry about searching the array (which is harder to do IMHO), you let the database do it for you. It's one of the benefits of using a database!