[Resolved] grid format on the form

chintupintu03

How to create "grid" structure on the form.

e.g. For a particular purchase order, multiple items are to be included with item code, quantity.

It will look like ;

In the upper part of the form :

Purchase order no : Purchase order date :
Order placed to : Expected acceptance date :

In the lower part of the form :

Item code Quantity
I001 2
I002 5
I006 3

like this

I received the reply from Frederick, but what i actually wanted is "for input from the user". i.e. if the user has to make the purchase order as explained above. ( any in-built like DBGrid in visual basic programming). Dynamically rows should increment as and when the user adds items for a particular purchase order. ( with reference to above example).

What Frederick explained / replied to above is "to retrieve and display" on the form. That solution is correct.

Frederick

From what I see you want.
You will need 2 tables.

Table 1: purchase_orders
Table 2: order_items

Table 1 fields:
poID int(5) unsigned zerofill NOT NULL auto_increment
order_date varchar(10) NOT NULL default ''
accept_date varchar(10) NOT NULL default ''
placed_to varchar(60) NOT NULL default ''

Table 2 fields:
itemID int(4) unsigned zerofill NOT NULL auto_increment
poID int(5) NOT NULL default '0'
item_code int(1) NOT NULL default '0'
item_qty int(3) NOT NULL default '0'

Relate the 2 tables together by using the poID field

<?php
$poSQL = mysql_query("SELECT * FROM purchase_order WHERE poID=$poID") or die (mysql_error());
$po = mysql_fetch_array($poSQL);
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">\n";
echo "<tr>\n";
echo "<td><b>PO#:</b> ".$po["poID"]."</td>\n";
echo "<td><b>Order Date:</b> ".$po["order_date"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td><b>Placed To:</b> ".$po["placed_to"]."</td>\n";
echo "<td><b>Accept Date:</b> ".$po["accept_date"]."</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
	echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">\n";
	echo "<tr>\n";
	echo "<td><b>Item#</b></td>\n";
	echo "<td><b>Code</b></td>\n";
	echo "<td><b>Qty</b></td>\n";
	echo "</tr>\n";
	$itemSQL = mysql_query("SELECT * FROM order_items WHERE poID=".$po["poID"]."") or die (mysql_error());
	while ($item = mysql_fetch_array($itemSQL)) {
		echo "<tr>\n";
		echo "<td>".$item["itemID"]."</td>\n";
		echo "<td>".$item["item_code"]."</td>\n";
		echo "<td>".$item["item_qty"]."</td>\n";
		echo "</tr>\n";
	}
	echo "</table>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
?>