Hello Jenniffer,
I think the you could do like this:
<form action="buyitem.php" method="post">
<?php
// selects the image,name,quantity,price of the item from db
$query = "SELECT * FROM items where id = $id";
$ret = mysql_query($query);
if ( $ret && mysql_num_rows($ret) )
{
while(list($result) =mysql_fetch_array($ret))
{
echo "<input type=image src=images/blueholo.gif
name=\".$result['id']."\"><BR>"; \\ The current id selected in the DB
echo "<B>".$result['name']."</B>"; \\ it will print the name of product
echo "Quantity ".$result['quantity']."<BR>"; \\ and the quantity
echo "Cost: ".$result['price']." SC"; \\ price as well
echo "<INPUT TYPE=\"hidden\" name=\"item_type\"
value=\"".$result[''item_type].">"; \\ i don't know if if will be necessary
but it won't appear in the Browser :)
}
}
?>
</form>
i thinkk it's good
At 19:33 31/03/02 -0800, you wrote:
>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 NULL default '0',
> PRIMARY KEY (id)
>) TYPE=MyISAM;
>
>Here is my code and I know there has to be an easier way to do this so any
>help would be appreciated.
>
><form action="buyitem.php" method="post">
>
><?php
>// selects the image of the item from db
>$query = "SELECT image FROM items where id = 1";
> $ret = mysql_query($query);
> while(list($image) =
> mysql_fetch_row($ret))
> echo "<input type=image src=images/blueholo.gif name=\"1\"><BR>";
>
>//select the name of the item
>$query = "SELECT name FROM items where id = 1";
> $ret = mysql_query($query);
> while(list($name) =
> mysql_fetch_row($ret))
>echo "<B>$name</B>";
>
>//shows the quantity of the item
>$query = "SELECT quantity FROM items where id = 1";
> $ret = mysql_query($query);
> while(list($quantity) =
> mysql_fetch_row($ret))
>echo "Quantity $quantity<BR>";
>
>//the price of the item
>$query = "SELECT price FROM items where id = 1";
> $ret = mysql_query($query);
> while(list($price) =
> mysql_fetch_row($ret))
>echo "Cost: $price SC";
>?>
></form>
>
>What I am trying to do is make it so the user clicks on the image and is
>taken to buyitem.php through the form where it takes the item out of the
>items table and updates the user table with that item.
>
>Any ideas how I can accomplish this?
>
>TIA
>Jennifer
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
Henrique Flach Latorre Moreno
Smart Tech Consulting
www.smartech.com.br
Av. Rio Branco 181, 1005
Centro - Rio de Janeiro - RJ
Tels : (21) 2532-6335
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
