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:
0)
{
print "";
// Get Record and Echo/Print Out Data
while(
Hello Jenniffer,
I think the you could do like this:
"; \\ The current id selected in the DB
echo "".$result['name'].""; \\ it will print the name of product
echo "Quantity ".$result['quantity'].""; \\ and the quantity
echo "Cost: ".$result['price']." SC"; \\ price as well
echo "
Hi all,
I have a table called items here is a dump:
CREATE TABLE items (
id int(10) NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
item_type int(4) NOT NULL default '0',
image varchar(100) NOT NULL default '',
price int(10) NOT NULL default '0',
quantity int(5) NOT NU