Hi Can someone look at this code for me.... For Some reason when I add any
more:
<INPUT NAME = \"postcode[]\" TYPE = \"HIDDEN\" VALUE=\"$postcode\">
The form doesnt send!!
What I want is to have two more hidden fields storing the data for country
and contact
thanks
-----Code-------
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="ajr_oss_styles.css" type="text/css">
</head>
<body bgcolor="#FFFFCC" text="#000000">
<p class="page_heading">Call-off</p>
<p><span class="body_text">Select the recipients and add the quantities to
each
destination</span><br>
<?php
include ("holding_inc.php");
$sql="SELECT * FROM distribution WHERE userID = $userID";
$mysql_result=mysql_query($sql,$connection);
$num_rows=mysql_num_rows($mysql_result);
if ($num_rows == 0){
echo "Sorry no data";
} else {
#we have results
# create table
# next line removed temporarily while testing arrays
#echo "<FORM METHOD=GET ACTION=\"ajr_calloff_mail.php\" >";
echo "<img src=\"$image\"><BR>";
echo "<FORM METHOD=GET ACTION=\"ajr_calloff_confirm.php\">";
echo "Product ID <B>$productID</B><BR><BR>";
echo "Title <B>$title</B><BR><BR>";
echo "User ID <B>$userID</B><BR><BR>";
echo "Stock Level <B>$stock_level</B><BR><BR>";
echo "<TABLE BORDER=\"2\">";
echo "<TR><TH>Dist
ID</TH><TH>company</TH><TH>add1</TH><TH>add2</TH><TH>add3</TH><TH>town</TH><
TH>county</TH><TH>postcode</TH><TH>country</TH><TH>contact</TH><TH>quantity<
/TH></TR>";
echo "<INPUT NAME = \"var_total\" TYPE = \"text\" VALUE=\"$num_rows\">";
while ($row=mysql_fetch_array($mysql_result))
{
$distID=$row["distID"];
$company=$row["company"];
$add1=$row["add1"];
$add2=$row["add2"];
$add3=$row["add3"];
$town=$row["town"];
$county=$row["county"];
$postcode=$row["postcode"];
$country=$row["country"];
$contact=$row["contact"];
echo "<TR>
<TD>
$distID
<INPUT NAME = \"distID[]\" TYPE = \"HIDDEN\" VALUE=\"$distID\"></TD>
<TD>$company
<INPUT NAME = \"company[]\" TYPE = \"HIDDEN\" VALUE=\"$company\"></TD>
<TD>$add1
<INPUT NAME = \"add1[]\" TYPE = \"HIDDEN\" VALUE=\"$add1\"></TD>
<TD>$add2
<INPUT NAME = \"add2[]\" TYPE = \"HIDDEN\" VALUE=\"$add2\"></TD>
<TD>$add3
<INPUT NAME = \"add3[]\" TYPE = \"HIDDEN\" VALUE=\"$add3\"></TD>
<TD>$town
<INPUT NAME = \"town[]\" TYPE = \"HIDDEN\" VALUE=\"$town\"></TD>
<TD>$county
<INPUT NAME = \"county[]\" TYPE = \"HIDDEN\" VALUE=\"$county\"></TD>
<TD>$postcode
<INPUT NAME = \"postcode[]\" TYPE = \"HIDDEN\" VALUE=\"$postcode\"></TD>
<TD>$country
<TD>$contact</TD>
<TD>
<INPUT NAME = \"quantity[]\" TYPE = \"text\" VALUE=\"0\">
</TD>
</TR>";
}
echo "</TABLE>";
} #end else
echo "<INPUT TYPE=SUBMIT VALUE=\"Send\">";
echo "</FORM>";
mysql_close($connection);
?>
</p>
<p>To Do:<br>
add facility for ad-hoc addresses</p>
<p>select only those who have check boxes</p>
<p> add stock level calculation</p>
<p>form validation </p>
</body>
</html>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
