subrtact help

[lozza1978]

I have a field in mysql called tickets - when a user completes the process of ordering the ticket i want the remaining_ticket field in mysql to be subracted my 1

is there a quick and easy way to this in one update query ?

$sql "UPDATE `db_affiliate_codes` SET `tickets_remaining` = 'subract 1' WHERE `id` =1 LIMIT 1 ;";";

[Piranha]

If you mean that the tickets should be booked and the tickets_remaining should be subtracted there is no way to do it with one query. Of course you could use a trigger to do it from the database, but normally I think it's easier to do from PHP.

If you mean that you want one query to update the number of tickets remaining it is quite easy:

$sql "UPDATE `db_affiliate_codes` SET `tickets_remaining` = tickets_remaning - 1 WHERE `id` =1 LIMIT 1 ;";";