Re: mySQL query question
| From: | Jim Lucas | Date: | Sun, 16 Nov 2008 05:09:42 +0000 |
| Subject: | Re: mySQL query question | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-283329@lists.php.net to get a copy of this message | ||
Michael S. Dunsavage wrote:
On Fri, 2008-11-14 at 12:46 -0800, Jim Lucas wrote:The idea is to give you the number that was used in the INSERT statement. It might have changed since the INSERT. Never know. So, giving you the one used in the INSERT is the best way to make sure you get the one you are expecting.SELECT @confirm_number AS confirm_number;Are we not SELECTING the column value here? should we be selecting confirm_number as confirm_number?