getting values from a textarea to use in a sql query

passing values from textarea to sql statement

[bhav]

im trying to retrieve the text entered within a text area, split it into indiviual lines and use each line within a sql statement

I can retrieve the values but only the 1st value is inserted within the sql statement

can anyone help?

if ($STAGE == 11)
{

$ordernumbera = explode("\n", $p_ordernum);
$Count = count($ordernumbera);
echo $Count;
for ($i=0; $i < $Count; $i++) {
$arr_words = $ordernumbera[$i] ;
echo $arr_words ;
}
?>
<form method="POST" action=/admin/paymentrequest.php>
<table>
<tr><td>Date</td><td>Order Number</td><td>Artist Cost (Yen)</td><td>Request Payment</td></tr>
<?
$sql ="DROP TABLE IF EXISTS tempfinance1";
$result=mysql_query($sql);
$sql = "CREATE TABLE tempfinance1 SELECT tracking_id, tracking_date, tracking_total, order_shippingcost, item_artistcost, trackitem_quantity, tracking_shippingtotal, tracking_firstname, tracking_lastname from (((trackitem left join item_status on item_tkid=trackitem_id) left join tracking on tracking_id = trackitem_tracknum) left join order_status on order_number=tracking_id) WHERE tracking_id in ('$arr_words')";
$result=mysql_query($sql);
echo $sql;
$sql = "INSERT INTO tempfinance1 SELECT tracking_id, tracking_date , tracking_total , order_shippingcost , item_artistcost, trackitem_quantity, tracking_shippingtotal, tracking_firstname, tracking_lastname from trackitemmanual left join trackingmanual on trackitem_tracknum = tracking_id WHERE tracking_id in ('$arr_words')";
echo $sql;
$result=mysql_query($sql);

[Scally_Ally]

havent you got to do an insert for each of the values that you are finding

for($i = 0; $i < sizeof($arr_words); $i++){
$sql = "INSERT INTO tempfinance1 SELECT tracking_id, tracking_date , tracking_total , order_shippingcost , item_artistcost, trackitem_quantity, tracking_shippingtotal, tracking_firstname, tracking_lastname from trackitemmanual left join trackingmanual on trackitem_tracknum = tracking_id WHERE tracking_id in ('".$arr_words[$i]."')";
echo $sql;
$result=mysql_query($sql);
}

Ally