MYSQL query..update?

[Anon]

Hello,

I have written the following sql for updates..

$sql = "UPDATE atable SET price='$price' color='$color', size='$size' WHERE price=$price";

This works only if user enters price(assuming right entry) for price field(since I have just specified price field after WHERE)

I need something to accept whichever of three fileds entered and process data..

Should I use AND for this? or any other easy way of doing it?

Help would geratly apprecaited.

thanks.

[Anon]

I assume you are only dealing with only one entered field:

use if/else if

if ($price <>"") {
$sql = "UPDATE atable SET price='$price' color='$color', size='$size' WHERE price=$price";

} elseif ($color <>"") {
$sql = "UPDATE atable SET price='$price' color='$color', size='$size' WHERE color=$color";

} elseif ($size <>"") {
$sql = "UPDATE atable SET price='$price' color='$color', size='$size' WHERE size=$size";

} else {
print ("pick a valid field!");
}

[lawnmowerman]

It would probably be best if you include a unique row identifier in each query. Not doing so could result in serious problems.

What happens when 2 items have the same price and you update the color? Both items will be assigned the same color and size.

I would include something like itemID (which would be a primary key for the table) and do:

$sql = "UPDATE atable SET price='$price' color='$color', size='$size' WHERE itemID=$itemID";

-Rich