Hi Jennifer, Okay first, in your current page, just do one SQL statement that selects the 4 fields you want all at once, then use extract() to turn the record/result into variables, and print out your form like:
<? // Query $ret = mysql_query( "SELECT id, image, name, quantity, price FROM items WHERE id = 1" ); // Check for Error First if(mysql_num_rows > 0) { print "<form action='buyitem.php' method='post'>"; // Get Record and Echo/Print Out Data while($rec = mysql_fetch_assoc($ret)) { extract($rec); echo "<input type='image' src='images/blueholo.gif'><br>"; echo "<b>$name</b><br>"; echo "Quantity $quantity<br>"; echo "Cost: $price SC<br>"; echo "<input type='hidden' name='ItemID' value='$id'>"; } print "</form>"; } else { // Say there's a problem and echo the error message to an HTML comment. print "There was a problem while fetching the item from the database.\n"; print "<!-- " . mysql_error() . " -->\n"; } ?> ... Now you'll have a file that will post a field called ItemID containing the ID number (in this case, 1) to buyitem.php. Now you just code buyitem.php to add the product to the user's "basket". There are several ways of doing that, but this should be the proper stepping stone. - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php