Text file

[d-woo]

I'm using phpMyAdmin to execute the following command which changes the status of various order numbers:

UPDATE orders
SET order_status='S'
WHERE order_id IN ('0875', '0125', '0354', '8514', ...)

How would I do this if my order numbers where in a text file "ordernos.txt" that has the order numbers on separate lines?:

0875
0125
0354
8514
.
.
.

If this were to be executed in a phpfile, rather than phpMyAdmin, I would like the file to ask for the filename and then I can type in "ordernos.txt" and press "submit"

Thanks in advance!

[[deleted]]

Well, rather than just coding the whole thing for you..let me point you in the right direction...this will get you started, all you need to do is take the file name as input and whatnot now...

<?
$file = 'incodes.txt';
$incodes = file($file);
$query = "UPDATE orders SET order_status='S' WHERE order_id IN(";
for($i = 0; $i < (count($incodes) - 1); $i++) {
$query .= "'$incodes[$i]',";
}
$query .= "'$incodes[$i]')";
echo $query;
?>

Matt Wade
http://codewalkers.com/