update with array

Anon

This code is not working what I am trying to do is update several records at the same time.I have $EstId as the primary key
$Price has the values to update SoldFor
It looks as if EstId is not looping with [$i] it is actually looping 1 digit at a time instead of each record.
$Price will hold say 1000 2000 3000
$EstId should have say 100 101 102
$sql_Est=("SELECT * FROM Estimates WHERE QuoteNumber=\"$Vari\"");
$result = mysql_query($sql_Est) or die("Couldn't execute query Estimating.");
$row = mysql_fetch_array($result);
$EstId=$row[EstId];

for ($i=0;$i<count($Price);$i++)

{

$result_Est="UPDATE Estimates SET SoldFor='$Price[$i]' WHERE EstId='$EstId[$i]'";
$result_Estd=mysql_query($result_Est,$link);

echo"$Price[$i]<br>";
echo"$EstId[$i]<br>";
}
I hope someone can take the time to help me with this I am stumped.
Thank you in advance

[deleted]

You are mixing a few things up.

First:
$EstId=$row[EstId];
should be
$EstId=$row["EstId"];

Second, $EstId now holds one value (not an array),
so you can't loop though it's contents. count($EstId) is 1

Third:
if you want to loop through all records retreived by

$sql_Est=("SELECT * FROM Estimates WHERE QuoteNumber=\"$Vari\"");
$result = mysql_query($sql_Est) or die("Couldn't execute query Estimating.");
$row = mysql_fetch_array($result);

you should use a while loop:

while ($row=mysql_fetch_array($result,MYSQL_ASSOC))
{
$EstId=$row["EstId"];

do your stuff.

};

Anon

Thanks for your reply could you please look at it again its not working properly.
heres my revision.
$sql_Est=("SELECT * FROM Estimates WHERE QuoteNumber=\"$Vari\"");
$result = mysql_query($sql_Est) or die("Couldn't execute query Estimating.");
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$EstId=$row["EstId"];

}
for ($i=0;$i<count($Price);$i++)
{

$result_Est="UPDATE Estimates SET SoldFor='$Price[$i]' WHERE EstId='$EstId'";
$result_Estd=mysql_query($result_Est,$link);

echo"$result_Est<br>";
echo"$EstId<br>";
}
my echo
UPDATE Estimates SET SoldFor='1080' WHERE EstId='12'
12
UPDATE Estimates SET SoldFor='4900' WHERE EstId='12'
12
$sql_Est=("SELECT * FROM Estimates WHERE QuoteNumber=\"$Vari\"");
$result = mysql_query($sql_Est) or die("Couldn't execute query Estimating.");
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$EstId=$row["EstId"];

}
for ($i=0;$i<count($Price);$i++)
{

$result_Est="UPDATE Estimates SET SoldFor='$Price[$i]' WHERE EstId='$EstId[$i]'";
$result_Estd=mysql_query($result_Est,$link);

echo"$result_Est<br>";
echo"$EstId[$i]<br>";
}
my echo
UPDATE Estimates SET SoldFor='1080' WHERE EstId=''

UPDATE Estimates SET SoldFor='4900' WHERE EstId=''

[deleted]

ehm you miss the point a little.

the "while ($row=mysql_fetch..."
is the part where all your records are fetched.
the While loop is executed once for each record.
So, inside the while loop you must get the price that should go into that record, and update the record.
then the while loop will move you to the next record automatically.

Anon

I guess I must have been at this one to long this is as far as I get. Could you please write it out.
$sql_Est=("SELECT * FROM Estimates WHERE QuoteNumber=\"$Vari\"");
$result = mysql_query($sql_Est) or die("Couldn't execute query Estimating.");
while($row = mysql_fetch_array($result,MYSQL_ASSOC)){
$EstId=$row["EstId"];

for ($i=0;$i<count($Price);$i++){
	echo"$Price[$i]<br>";

$result_Est="UPDATE Estimates SET SoldFor='$Price[$i]' WHERE EstId='$EstId'";}
$result_Estd=mysql_query($result_Est,$link);

echo"$result_Est<br>";

}
This is my echo
222
333
UPDATE Estimates SET SoldFor='333' WHERE EstId='26'
222
333
UPDATE Estimates SET SoldFor='333' WHERE EstId='27'
thank you
Carmine

[deleted]

Just what is it you are trying to do?

You have $Price that contains an array of prices that need to be updated in the database, but how do you know in which record each price should go?

Anon

I went back and looked at the previous page and that may be where the problem is this is bits of it.
The form is dynamically generated and I don't know how many $Price there will be.Thank you for your patience
Carmine

for ($i=0;$i<count($Qty);$i++)
{
// logic to find data to use
$result = mysql_query("SELECT * FROM Data WHERE
Type = '$ty'
AND Catagory = '$ca'
AND Quantity <= \"$Qty[$i]\"
ORDER BY Quantity DESC
LIMIT 1");

$row=mysql_fetch_array($result);{

$Quantity= $row['Quantity'];
$SheetSize= $row["SheetSize"];
$NoOnSheet= $row['NoOnSheet'];
$SetUp= $row['SetUp'];
$Run= $row['Run'];
$EmptyValue1= $row['EmptyValue1'];
$Catagory= $row['Catagory'];
$Type= $row['Type'];
}
// depending on count of $Qty this will be repeated several times
echo "
<table>
<tr>

<td> </td>
</td>
<td>
<td>Quote No.</td>
<td>
$id

        </td> 
      </tr> 
      <tr>  
        <td>Sheet Size</td> 
        <td>

$SheetSize
</td>
<td> </td>
</tr>
<tr>

<td>No. on Sheet</td>
<td>

// etc.. more in between
</td>
<td> $
$TotalValue

</td>
<td> </td>
<tr>
<td><H5>Sold For</H5></td>
<p>

<td>
//this is where it gets the $Price
<INPUT TYPE=\"text\" NAME=\"Price[]\" SIZE=\"10\">

</td>

</p>
</tr>
</tr>
</table>

</td>

\n";

}

Anon

I thought about it some more and here is a better description.
Each $Qty generates a form and calculates a suggested price then the customer Puts in the price they want to sell it for $Price.
I am not sure how to relate the $EstId to the $Price ($EstId is primary auto increment). If you can offer any guidance it would be appreciated the more I look at this the more confused I get.
Thanks
Carmine.