variable column name

[featherwebdiva]

This is what I've tried, which I know is incorrect:

 

for ($i=1;$i<=3;$i++) {
$query = "UPDATE contacts SET merchant_id.$i='".$new_mid."' WHERE merchant_id.$i='".$old_mid."'";
$result = mysql_query($query, $contacts) or die(mysql_error());
}

 

what I'm trying to do is append the value of $i to "merchant_id" because the column names in my mysql table are merchant_id1, merchant_id2, and merchant_id3

 

Is there a way to do this inline query?

 

Right now I've got a switch/(case $i:) within my for loop which just looks dumb and it's driving me nuts!

 

Thanks from Jennifer

 

 

 

[sasa]

try

$query = "UPDATE contacts SET merchant_id$i='".$new_mid."' WHERE merchant_id$i='".$old_mid."'";

remove dots

[featherwebdiva]

thanks so much!  it works!

 

I have never understood the mysql query strings, that's something I would've never tried.

 

Thank you!