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

Reply via email to