Sorry forgot to state the question. No bids. Looking for help. the first list that is displayed has an ID for each product. But when I click on it, it goes to the next page but does not display the rest of the products that are listed in the second table. $query = "SELECT * FROM product_list WHERE productid = id"; Id being the description ID that came off the first page. -----Original Message----- From: CPT John W. Holmes [mailto:holmes072000@charter.net] Sent: Monday, June 16, 2003 11:43 AM To: ryan@hgilive.com; php-db@lists.php.net Okay... and? Do you have a question? Are you wanting us to write this for free? Do you want bids on the project? ---John Holmes... ----- Original Message ----- From: "Ryan Holowaychuk" <ryan@hgilive.com> To: <php-db@lists.php.net> Sent: Monday, June 16, 2003 2:30 PM Subject: query selection I have a databae built, at the moment it has two tables. The first table has 2 fields, an ID and description. This is for a listing of all the different samples that we have at the company. When the user clicks on the description they want, it will open another page that will show all the items that fit that description. So in this case the first page shows: Brochures, business cards, tickets, etc They then click on tickets I want it to show all the tickets that we have done and then I will have a link from there they can click on and show all the jobs in there. but to even make it more complicated I only want it to show the first job for that client based on the job number. (eg. Tickets each client will have a back, front and inside to show) so when they click on tickets they will see the teams we have done, and then from there they can select a team. And then it will open all the examples they want in there, and then if they click on the thumb it would go to a page I have set up with the image at a large size. Thanks Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
