whats wrong with this? 1

[jodiep]

hi there:
the idea of the following code is : $q is a result set with products_id and quantity, and i want to update the table products with this values, simple enough? not!
the script run but doesnt changes anything i tryed everything ican think of. please let me know what am I doing wrong

While ($row=mysql_fetch_row($q))
{
$up_q=mysql_query("UPDATE products Set products.products_quantity = '$row[1]' AND products_last_modified = NOW() WHERE products_id = '$row[0]' ");
if (mysql_affected_rows()>0){
echo "Changed Product: $row[0] stock is now: $row[1] <br>";
}

 

[sleipnir214]

I have a section on dealing with database interaction debugging in my FAQ: faq434-2999

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[HMarcBower]

As a quicker answer (though I highly recommend the excellent FAQs on this site), replace your AND with just a comma. You might also grab a mysql manual site and read up on the UPDATE syntax (I check it all the time, whenever there is a problem... sometimes my brain fills in things that ought not be in the query ). Try this line:

$up_q = mysql_query("UPDATE products set products_quantity='".$row[1]."',products_last_modified=NOW() WHERE products_id = '".$row[0]."'");

Marc

 

[jodiep]

marc: thanks a lot the AND was the problem i quote you "... sometimes my brain fills in things that ought not be in the query" well you know is the kind of thing you can read 100 times and not spot.
sleipnir214, I m sure this never happened to you ...

Cheers

j

 

[sleipnir214]

jodiep:

sleipnir214, I m sure this never happened to you ...

?

Want the best answers? Ask the best questions!

TANSTAAFL!!