I noticed that Message-ID:
<a4**************************@posting.google.com > from angel duran
contained the following:
i want something like this:
SUPPLIERS TABLE
supplierID, Name, Address,
AA Alfin21 1506 w. 66th street <>EDIT<>
Assuming you have a table containing the products, have a field in the
products table containing supplierID
I'll also assume you have another page with which you will display the
list of products called products.php.
When you list the suppliers include this bit
<a href="products.php<?php print "?supplierID=".$myrow['supplierID'];
?>EDIT</a>
then on the products page your SQL becomes
$sql="SELECT * FROM products WHERE supplierID=$_GET['supplierID']";
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs
http://www.ckdog.co.uk/rfdmaker/