Problem with understanding why this insert wont work!

[QSDragon]

This is the snippet of code, the insert statement works the first time... but with the second loop it fails.. anyone know how or why this is and how i might correct it?

while($row=mysql_fetch_array($results)){
$ordernumber = $row["ordernumber"];
$product = $row["product"];
$date = date("d/m/Y");
$updateretail = mysql_query("INSERT INTO techbuy (ordernumber, date, product, price, new) VALUES ('$ordernumber', '$date', '$product', '', 'Y')") or die("Bugger .. no Updateretail");

Thanks.
Ben

[Lars_Berg]

Get the real error

$updateretail = mysql_query("INSERT INTO techbuy (ordernumber, date, product, price, new) VALUES ('$ordernumber', '$date', '$product', '', 'Y')") or die(mysql_error()); 

[[deleted]]

the problem is: the code can work only once,right?
so i think here is the problem:
while($row=mysql_fetch_array($results))
change it to:
while(list(ordernumber,product=@mysql_fetch_array($results))
or
while($row=@mysql_fetch_array($results) and ($count++)<$number

there number stands for times you do your loop

:-)
yours
shakespeare