Updating all

raouleduke

I have this script, but it is not updating all the values from the first query.

mysql_connect("","",""); 
mysql_select_db("a0020386");
$query = mysql_query("SELECT * FROM LUTHERSELLANDRECOMMENDDONOTVIN");
while($row = mysql_fetch_array($query)) {
$VIN = $row["VIN"];
}
for($i = 0; $i < count($VIN); $i++){
$query2 = "UPDATE LUTHERSELLANDRECOMMEND SET ACTIVE='0' WHERE VIN = '$VIN'"; 
$result = mysql_query($query2) or die(mysql_error());
print $query2;
}

Thanks in advance.

AstroTeg

Is Active a varchar or a numeric field. I doubt that would cause a hang up.

The code looks fine. Without any data details, I can't say why its not working.

What does $query2 look like (I noticed you printing it out). Does the VIN exist in the database? Remember, that query is designed to update the Active value for all records with the VIN you specified. If you want to update every single record, then just take the "WHERE VIN = [test]" clause out.

raouleduke

What I am doing is creating a do not call list, the VINs are stored in the first database, and I want to select all the VIN's from the first one, and update the second one where the VIN's are the same. Active is either a 0 or 1 depending on Active status.
I can get it to work but only updates one of them.

AstroTeg

You might query the 2nd table for that VIN and see how many records you get back. Maybe there's some odd spacing/trimming that needs to happen that isn't matching with what you have in your table. Otherwise, your code looks ok.

raouleduke

This query works fine when I use it on the otherside of a form, but then I am Posting Values, How can I make the first query Post the values.

AstroTeg

First - identify if you're query is getting the data. You should be seeing something like:

UPDATE LUTHERSELLANDRECOMMEND SET ACTIVE='0' WHERE VIN = '12345'

Right?

If so, tweak the query and see how many records you have in LUTHERSELLANDRECOMMEND that has that VIN. Such as:

SELECT * FROM LUTHERSELLANDRECOMMEND WHERE VIN = '12345'

Do you get 1 record or many records? If you get 1, then there's your problem. You only have 1 record in that table.