When Updating a One-Row Table ?

Hi,

I have a table which contains just one row, and is updated each day.

Like this:


$sql = "UPDATE pdc_promo_count SET cntr = '$new_cntr'"; // only one row
mysql_query($sql)or die("could not UPDATE pdc_promo_count". mysql_error());

As you can see, I don't have a WHERE clause.

Do I need one when there is only one row ?



.

If it is one row, you can get away without a WHERE clause.

As for performance concerns, not sure, would have to benchmark it, though I would assume it would be very small/negligible difference.

Hy,
your sql works fine as it is if the table has one row.