SET cardnumb=%d WHERE newphoto=1 and
tbprinted=1;", iHighNum);
This in effect leaves any processing possible to the client side.
Hope that helps,
-Shane
- Original Message -
From: "Phill Gillespie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 1
Hi *
I'm running MySQl 3.23 and I'm trying to run a very simple command that
basically finds the highest number in a column and then for all matching
rows sets their card number to be +1. The code looks
like this:
#cardnumb is actually a string of the form SNx so set @high=x as
a nu
